public int dalcrud2_setStatus(setbgcdetails cd, int teststatus, string remarks) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("update E_Data_Candidate_Profile set Can_BCGTestStatus=" + cd.bgcteststatus + ", Can_TestStatus=" + teststatus + ", Can_Remarks='" + remarks + "' where Can_CandidateID=" + cd.candidateid, con); int i = cmd.ExecuteNonQuery(); return(i); }
public int balcrud2_setStatus(setbgcdetails cd, string remarks) { int teststatus = 7; if (cd.bgcteststatus == 0 && remarks.Equals("")) { teststatus = 5; } else if (cd.bgcteststatus == 1) { teststatus = 6; } BgcScheduleDAL dc = new BgcScheduleDAL(); int i = dc.dalcrud2_setStatus(cd, teststatus, remarks); return(i); }