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