public void AddPhoneCallEmergency(int receptionistId, string phoneNo, string callDate, string callTime, 
        string callerName, string callerArea, string emergencyDetails)
    {
        AddPhoneCallEmergencyBO objAddPhoneCallEmergencyBO = new AddPhoneCallEmergencyBO();
        objAddPhoneCallEmergencyBO.receptionistId = receptionistId;
        objAddPhoneCallEmergencyBO.phoneNo = phoneNo;
        objAddPhoneCallEmergencyBO.callDate = callDate;
        objAddPhoneCallEmergencyBO.callTime = callTime;
        objAddPhoneCallEmergencyBO.callerName = callerName;
        objAddPhoneCallEmergencyBO.callerArea = callerArea;
        objAddPhoneCallEmergencyBO.emergencyDetails = emergencyDetails;

        AddPhoneCallEmergencyDL objAddPhoneCallEmergencyDL = new AddPhoneCallEmergencyDL();
        objAddPhoneCallEmergencyDL.AddPhoneCallEmergency(objAddPhoneCallEmergencyBO);
    }
 public void AddPhoneCallEmergency(AddPhoneCallEmergencyBO objAddPhoneCallEmergencyBO)
 {
     SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
     SqlCommand cmd = new SqlCommand("spAddPhoneCallEmergency", conn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@receptionistId", objAddPhoneCallEmergencyBO.receptionistId);
     cmd.Parameters.Add("@phoneNo", objAddPhoneCallEmergencyBO.phoneNo);
     cmd.Parameters.Add("@callDate", objAddPhoneCallEmergencyBO.callDate);
     cmd.Parameters.Add("@callTime", objAddPhoneCallEmergencyBO.callTime);
     cmd.Parameters.Add("@callerArea", objAddPhoneCallEmergencyBO.callerArea);
     cmd.Parameters.Add("@callerName", objAddPhoneCallEmergencyBO.callerName);
     cmd.Parameters.Add("@emergencyDetails", objAddPhoneCallEmergencyBO.emergencyDetails);
     conn.Open();
     cmd.ExecuteNonQuery();
     conn.Close();
 }
Beispiel #3
0
    public void AddPhoneCallEmergency(AddPhoneCallEmergencyBO objAddPhoneCallEmergencyBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand    cmd  = new SqlCommand("spAddPhoneCallEmergency", conn);

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@receptionistId", objAddPhoneCallEmergencyBO.receptionistId);
        cmd.Parameters.Add("@phoneNo", objAddPhoneCallEmergencyBO.phoneNo);
        cmd.Parameters.Add("@callDate", objAddPhoneCallEmergencyBO.callDate);
        cmd.Parameters.Add("@callTime", objAddPhoneCallEmergencyBO.callTime);
        cmd.Parameters.Add("@callerArea", objAddPhoneCallEmergencyBO.callerArea);
        cmd.Parameters.Add("@callerName", objAddPhoneCallEmergencyBO.callerName);
        cmd.Parameters.Add("@emergencyDetails", objAddPhoneCallEmergencyBO.emergencyDetails);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }
    public void AddPhoneCallEmergency(int receptionistId, string phoneNo, string callDate, string callTime,
                                      string callerName, string callerArea, string emergencyDetails)
    {
        AddPhoneCallEmergencyBO objAddPhoneCallEmergencyBO = new AddPhoneCallEmergencyBO();

        objAddPhoneCallEmergencyBO.receptionistId   = receptionistId;
        objAddPhoneCallEmergencyBO.phoneNo          = phoneNo;
        objAddPhoneCallEmergencyBO.callDate         = callDate;
        objAddPhoneCallEmergencyBO.callTime         = callTime;
        objAddPhoneCallEmergencyBO.callerName       = callerName;
        objAddPhoneCallEmergencyBO.callerArea       = callerArea;
        objAddPhoneCallEmergencyBO.emergencyDetails = emergencyDetails;

        AddPhoneCallEmergencyDL objAddPhoneCallEmergencyDL = new AddPhoneCallEmergencyDL();

        objAddPhoneCallEmergencyDL.AddPhoneCallEmergency(objAddPhoneCallEmergencyBO);
    }