Monday, July 27, 2020

SQL Server Unique Constraint

SQL Server Unique Constraint

Whats is Unique Constraint in SQL | How to create Unique Constraint in SQL | Unique Constraint with Example in SQL Server

A UNIQUE constraint ensures that all values in a column are unique. This provides uniqueness for the

SQL Server Primary Key

SQL Server Primary Key

Whats is primary Key in SQL | How to create Primary Key in SQL | Primary Key with Example in SQL Server

The PRIMARY KEY constraint which is uniquely identifies each row in a table into the Database. It

Friday, May 15, 2020

School Management System

School Management System


SCHOOL MANAGEMENT SYSTEM PROJECT REPORT | SCHOOL MANAGEMENT SYSTEM


Project Overview



1.1 Description Of the organization:

A school is an institution designed for the teaching of students (or "pupils") under the supervision of teachers. Most countries have systems of formal education, which is commonly compulsory. In these systems, students progress through a series of schools. The names for these schools vary by country, but generally include primary school for young children and secondary school for teenagers who have completed primary education.

Web based Seminar System

Web-based Seminar System


WEB-BASED SEMINAR SYSTEM PROJECT REPORT | WEB-BASED SEMINAR SYSTEM


Project Overview


 

1.1. Brief

This is the documentation of Final Year Project of BS (CS) degree. This document includes the detailed description of “Webinar (Web based seminar system)”. It covers all the phases of system development including requirement analysis, designing, and implementation and testing.

Firstly introduction of our SRS , This document is about the overall coverage of our project that which areas we cover and in which phases we work and how we use our techniques , when we deliver our project and what is main target of our  doing effort.

Online trainings are now playing important part in learning and act as beneficial alternative to class room sessions. Through webinars, a large number of attendees can participate in interactive sessions facilitated by the T&D department. This should turn out extremely useful for PTCL having large number of employees at various locations. Webinars can thus act as catalyst for knowledge sharing addressing large numbers conveniently.

2D GAME MAKING

2D GAME MAKING 


2D GAME MAKING PROJECT REPORT | 2D GAMING MANAGEMENT SYSTEM | VISUAL PROGRAMMING | GAME PROGRAMMING 


Project Overview


 1.1   Brief

 

This is the documentation of Final Year Project of BS (CS) Degree. This documentation includes the brief description of Tambo Game Maker. TGM is a windows application which provides user friendly interface which allows users to design game by On-Click events without the requirement of prior computer programming experience. It is specially designed for those people who want to create their own games without writing code. This system will provide a large variety of tools through which users will be able to develop 2D game easily and in less time.This documentation covers all the phases of system development including requirement analysis, designing, and implementation and testing.

 

Tambo Game Maker is proposed for the users who want to develop androids games without spending countless hours in learning how to become a programmer. TGM allows user to make exciting mobile games, without the need to write a single line of code. The people who have no interest in coding can easily make their own games. User can create quality games within very little time. User can make games with backgrounds, graphics, music and sound effects. There is an easy built-in LUA programming Language, which gives users the full flexibility of creating games with TGM.

 

Client Server Multi View Screen Application

Client-Server Multi-View Screen Application


MULTIVIEW SCREEN PROJECT REPORT | MULTIVIEW SCREEN SYSTEM


Project Overview

 

 

1.1. Brief

 

This is the documentation of Final Year Project of BS (CS) degree. This document includes the detailed description of “Multi-View Screen Application”. It covers all the phases of system development including requirement analysis, designing, and implementation and testing.

 

The Software shall allow the user to control multiple systems through a singular system connected to it over a network connection. The Software shall allow user to manipulate the environment of a system and grant the user the authority to monitor and control connected systems over a network such as LAN or WIFI (WLAN). Our research scope is to perform the application under different Application layer protocols such as RFB, JRMP and RDP in order to understand their constraints and limitations, in order to propose an optimized solution.

Client side

 

Client Side deals with the end users. End users will use MVS application in their PC, laptops devices to communicate with MVS server.

 

 Server side

 

MVS server plays an important role in the whole system. MVS server application display multiple client screens on the server machine and control these clients.

 

 

Transport Management System

Transport Management System


ONLINE TRANSPORT MANAGEMENT SYSTEM PROJECT REPORT | ONLINE TRANSPORT MANAGEMENT SYSTEM


Project Overview


INTRODUCTION

 

In this modern era, where every thing greatly relies on technology there is a possibility to develop unique application which can justify the problems faced by ordinary methodology to achieve a desired functionality in a real time system. Our project belongs to that half.

 

            This project is a real time application that is being developed for one of the reputed transport companies in the state of Andhra Pradesh. The project takes dotnet as development platform and C# is the language used for development.

 

Vehicle Management System

Vehicle Management System


VEHICLE MANAGEMENT SYSTEM PROJECT REPORT | VEHICLE MANAGEMENT SYSTEM


Project Overview


INTRODUCTION

Vehicle Management System is software which is helpful for bus operators, who wants to operate many bus trips in a day. Vehicle Management System is a windows application written for 32-bit Windows operating systems which focused in the area of adding, editing and deleting the passengers, staff and the bus routes. In this software a person can be register as a user and he can manage the bus routes and the staff, passengers’ details.  He can add a bus and its details including bus route details. User can also add the details of the staff and their duty time in the system.

There are mainly 5 modules in this software

  • Bus Management
  • Route Management
  • Employee Management
  • Passenger Management

 

SHARE POINT CAML QUERY

SHARE POINT DESIGN CAML QUERY

How to Sort into the Sharepoint | Sharepoint Ordering and Sorting | Custom Sort with CAML in Sharepoint 



CAML, The query for Order By / Group By


// This Code is used for sorting by a column
Query : <View><Query><OrderBy>< FieldRef Name='Column_Name' Ascending='True' ></OrderBy></Query></View>



CAML code:  &lt;View&gt;&lt;Query&gt;&lt;OrderBy&gt;&lt;FieldRef Name='Column_Name' Ascending='True' /&gt;&lt;/OrderBy&gt;&lt;/Query&gt;&lt;/View&gt;

Send Email Using CSharp

Send Email Using C Sharp

Send an email with SMTP | Send Gmail Using C#




using System.Net.Mail;//Namespace to include
/// <summary>
    /// This Function is to send email 
    /// </summary>
    /// <param name="subject">Subject of Email</param>
    /// <param name="body">Body of Email</param>
    /// <param name="mailto">Receiver's Email Address</param>
    /// <param name="userid">Sender's Email Address</param>
    /// <param name="attach">Any aatchment to be send with email</param>
    /// <returns>Return value if mail successfully sent</returns>
public static string SendMail(string subject, string body, string mailto, string userid, Attachment attach)
    {
        SmtpClient client = new SmtpClient();
        MailMessage mail = new MailMessage();
        mail.To.Add(mailto);
        mail.Bcc.Add("inderbhan@singsys.com");
        mail.From = new MailAddress(userid, " ", System.Text.Encoding.UTF8);
        mail.Subject = subject;
        mail.SubjectEncoding = System.Text.Encoding.UTF8;
        mail.Body = body;
        mail.BodyEncoding = System.Text.Encoding.UTF8;
        mail.IsBodyHtml = true;
        mail.Priority = MailPriority.High;

        mail.ReplyTo = new MailAddress(EmailAccount.EmailReplyTo);
          mail.Attachments.Add(attach);
        client.Port = 587;
        client.Host = "smtp.gmail.com";
        client.EnableSsl = true;
        client.UseDefaultCredentials = true;
        client.Timeout = 100000;
        client.Credentials = new System.Net.NetworkCredential(EmailAccount.SMTPUserName, EmailAccount.SMTPPassword);
        //client.Port = 25;
        //client.Host = "localhost";
        //client.EnableSsl = false;
        //client.Timeout = 100000;
        //client.DeliveryMethod = SmtpDeliveryMethod.Network;

        try
        {
            client.Send(mail);
            return "Email successfully sent.";
        }
        catch (Exception ex)
        {
            Exception ex2 = ex;
            string errorMessage = string.Empty;
            while (ex2 != null)
            {
                errorMessage += ex2.ToString();
                ex2 = ex2.InnerException;
            }
              HttpContext.Current.Response.Write(errorMessage);
            return ex.Message.ToString();

        } // end try 


    }

SQL Server Unique Constraint

SQL Server Unique Constraint Whats is Unique Constraint in SQL | How to create Unique Constraint in SQL | Unique Constraint with Example in ...