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);
    }