public void AddPhoneCallMessage(int receptionistId, string phoneNo, string callDate, string callTime,
        string callerName, int messageFor, string message)
    {
        AddPhoneCallMessageBO objAddPhoneCallMessageBO = new AddPhoneCallMessageBO();
        objAddPhoneCallMessageBO.receptionistId = receptionistId;
        objAddPhoneCallMessageBO.phoneNo = phoneNo;
        objAddPhoneCallMessageBO.callDate = callDate;
        objAddPhoneCallMessageBO.callTime = callTime;
        objAddPhoneCallMessageBO.callerName = callerName;
        objAddPhoneCallMessageBO.messageFor = messageFor;
        objAddPhoneCallMessageBO.message = message;

        AddPhoneCallMessageDL objAddPhoneCallMessageDL = new AddPhoneCallMessageDL();
        objAddPhoneCallMessageDL.AddPhoneCallMessage(objAddPhoneCallMessageBO);
    }
 public void AddPhoneCallMessage(AddPhoneCallMessageBO objAddPhoneCallMessageBO)
 {
     SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
     SqlCommand cmd = new SqlCommand("spAddPhoneCallMessage", conn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@receptionistId", objAddPhoneCallMessageBO.receptionistId);
     cmd.Parameters.Add("@phoneNo", objAddPhoneCallMessageBO.phoneNo);
     cmd.Parameters.Add("@callDate", objAddPhoneCallMessageBO.callDate);
     cmd.Parameters.Add("@callTime", objAddPhoneCallMessageBO.callTime);
     cmd.Parameters.Add("@callerName", objAddPhoneCallMessageBO.callerName);
     cmd.Parameters.Add("@messageFor", objAddPhoneCallMessageBO.messageFor);
     cmd.Parameters.Add("@message", objAddPhoneCallMessageBO.message);
     conn.Open();
     cmd.ExecuteNonQuery();
     conn.Close();
 }
Esempio n. 3
0
    public void AddPhoneCallMessage(AddPhoneCallMessageBO objAddPhoneCallMessageBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand    cmd  = new SqlCommand("spAddPhoneCallMessage", conn);

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@receptionistId", objAddPhoneCallMessageBO.receptionistId);
        cmd.Parameters.Add("@phoneNo", objAddPhoneCallMessageBO.phoneNo);
        cmd.Parameters.Add("@callDate", objAddPhoneCallMessageBO.callDate);
        cmd.Parameters.Add("@callTime", objAddPhoneCallMessageBO.callTime);
        cmd.Parameters.Add("@callerName", objAddPhoneCallMessageBO.callerName);
        cmd.Parameters.Add("@messageFor", objAddPhoneCallMessageBO.messageFor);
        cmd.Parameters.Add("@message", objAddPhoneCallMessageBO.message);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }
Esempio n. 4
0
    public void AddPhoneCallMessage(int receptionistId, string phoneNo, string callDate, string callTime,
                                    string callerName, int messageFor, string message)
    {
        AddPhoneCallMessageBO objAddPhoneCallMessageBO = new AddPhoneCallMessageBO();

        objAddPhoneCallMessageBO.receptionistId = receptionistId;
        objAddPhoneCallMessageBO.phoneNo        = phoneNo;
        objAddPhoneCallMessageBO.callDate       = callDate;
        objAddPhoneCallMessageBO.callTime       = callTime;
        objAddPhoneCallMessageBO.callerName     = callerName;
        objAddPhoneCallMessageBO.messageFor     = messageFor;
        objAddPhoneCallMessageBO.message        = message;

        AddPhoneCallMessageDL objAddPhoneCallMessageDL = new AddPhoneCallMessageDL();

        objAddPhoneCallMessageDL.AddPhoneCallMessage(objAddPhoneCallMessageBO);
    }