public void AddEditDelLinkProfessor(DO_LinkProfessor objLinkProfessor, DA_LinkProfessor.LinkProfessor flag) { SqlConnection cn = new SqlConnection(); SQLManager co = new SQLManager(); cn = co.GetConnection(); cmd = new SqlCommand("Scrl_AddEditDelLinkProfessor", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; cmd.Parameters.Add("@LinkId", SqlDbType.BigInt).Value = objLinkProfessor.LinkId; cmd.Parameters.Add("@ProfessorId", SqlDbType.BigInt).Value = objLinkProfessor.ProfessorId; cmd.Parameters.Add("@SubjectId", SqlDbType.BigInt).Value = objLinkProfessor.SubjecId; cmd.Parameters.Add("@DeptId", SqlDbType.BigInt).Value = objLinkProfessor.DeptId; cmd.Parameters.Add("@CourseId", SqlDbType.BigInt).Value = objLinkProfessor.CourseId; cmd.Parameters.Add("@Semister", SqlDbType.VarChar, 200).Value = objLinkProfessor.Semister; cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objLinkProfessor.AddedBy; cmd.Parameters.Add("@ModifiedBy", SqlDbType.Int).Value = objLinkProfessor.ModifiedBy; cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar, 200).Value = objLinkProfessor.Semister; cmd.ExecuteNonQuery(); co.CloseConnection(cn); }
public DataTable GetDataTable(DO_LinkProfessor objLinkProfessor, DA_LinkProfessor.LinkProfessor flag) { DataTable dt = new DataTable(); SqlConnection cn = new SqlConnection(); SQLManager co = new SQLManager(); cn = co.GetConnection(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("Scrl_AddEditDelLinkProfessor", cn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; da.SelectCommand.Parameters.Add("@LinkId", SqlDbType.BigInt).Value = objLinkProfessor.LinkId; da.SelectCommand.Parameters.Add("@ProfessorId", SqlDbType.BigInt).Value = objLinkProfessor.ProfessorId; da.SelectCommand.Parameters.Add("@SubjectId", SqlDbType.BigInt).Value = objLinkProfessor.SubjecId; da.SelectCommand.Parameters.Add("@DeptId", SqlDbType.BigInt).Value = objLinkProfessor.DeptId; //da.SelectCommand.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = objLinkProfessor.FromDate; //da.SelectCommand.Parameters.Add("@ToDate", SqlDbType.DateTime).Value = objLinkProfessor.ToDate; da.Fill(dt); co.CloseConnection(cn); return(dt); }