public int AddCase(int doctorId, int patientId, string caseStartDate, string caseEndDate) { AddCaseBO objAddCaseBO = new AddCaseBO(); objAddCaseBO.doctorId = doctorId; objAddCaseBO.patientId = patientId; objAddCaseBO.caseStartDate = caseStartDate; objAddCaseBO.caseEndDate = caseEndDate; AddCaseDL objAddCaseDL = new AddCaseDL(); return objAddCaseDL.AddCase(objAddCaseBO); }
public int AddCase(int doctorId, int patientId, string caseStartDate, string caseEndDate) { AddCaseBO objAddCaseBO = new AddCaseBO(); objAddCaseBO.doctorId = doctorId; objAddCaseBO.patientId = patientId; objAddCaseBO.caseStartDate = caseStartDate; objAddCaseBO.caseEndDate = caseEndDate; AddCaseDL objAddCaseDL = new AddCaseDL(); return(objAddCaseDL.AddCase(objAddCaseBO)); }
public int AddCase(AddCaseBO objAddCaseBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddCase", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@doctorId", objAddCaseBO.doctorId); cmd.Parameters.Add("patientId", objAddCaseBO.patientId); cmd.Parameters.Add("@caseStartDate", objAddCaseBO.caseStartDate); cmd.Parameters.Add("@caseEndDate", objAddCaseBO.caseEndDate); conn.Open(); int caseId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return caseId; }
public int AddCase(AddCaseBO objAddCaseBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddCase", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@doctorId", objAddCaseBO.doctorId); cmd.Parameters.Add("patientId", objAddCaseBO.patientId); cmd.Parameters.Add("@caseStartDate", objAddCaseBO.caseStartDate); cmd.Parameters.Add("@caseEndDate", objAddCaseBO.caseEndDate); conn.Open(); int caseId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(caseId); }