public void AddPhoneCallGeneralInquiry(int receptionistId, string phoneNo, string callDate, string callTime, 
        string callerName, string callerQuery, string callOutcome)
    {
        AddPhoneCallGeneralInquiryBO objAddPhoneCallGeneralInquiryBO = new AddPhoneCallGeneralInquiryBO();
        objAddPhoneCallGeneralInquiryBO.receptionistId = receptionistId;
        objAddPhoneCallGeneralInquiryBO.phoneNo = phoneNo;
        objAddPhoneCallGeneralInquiryBO.callDate = callDate;
        objAddPhoneCallGeneralInquiryBO.callTime = callTime;
        objAddPhoneCallGeneralInquiryBO.callerName = callerName;
        objAddPhoneCallGeneralInquiryBO.callerQuery = callerQuery;
        objAddPhoneCallGeneralInquiryBO.callOutcome = callOutcome;

        AddPhoneCallGeneralInquiryDL objAddPhoneCallGeneralInquiryDL = new AddPhoneCallGeneralInquiryDL();
        objAddPhoneCallGeneralInquiryDL.AddPhoneCallGeneralInquiry(objAddPhoneCallGeneralInquiryBO);
    }
 public void AddPhoneCallGeneralInquiry(AddPhoneCallGeneralInquiryBO objAddPhoneCallGeneralInquiryBO)
 {
     SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
     SqlCommand cmd = new SqlCommand("spAddPhoneCallGeneralInquiry", conn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@receptionistId", objAddPhoneCallGeneralInquiryBO.receptionistId);
     cmd.Parameters.Add("@phoneNo", objAddPhoneCallGeneralInquiryBO.phoneNo);
     cmd.Parameters.Add("@callDate", objAddPhoneCallGeneralInquiryBO.callDate);
     cmd.Parameters.Add("@callTime", objAddPhoneCallGeneralInquiryBO.callTime);
     cmd.Parameters.Add("@callerName", objAddPhoneCallGeneralInquiryBO.callerName);
     cmd.Parameters.Add("@callerQuery", objAddPhoneCallGeneralInquiryBO.callerQuery);
     cmd.Parameters.Add("@callOutcome", objAddPhoneCallGeneralInquiryBO.callOutcome);
     conn.Open();
     cmd.ExecuteNonQuery();
     conn.Close();
 }
    public void AddPhoneCallGeneralInquiry(int receptionistId, string phoneNo, string callDate, string callTime,
                                           string callerName, string callerQuery, string callOutcome)
    {
        AddPhoneCallGeneralInquiryBO objAddPhoneCallGeneralInquiryBO = new AddPhoneCallGeneralInquiryBO();

        objAddPhoneCallGeneralInquiryBO.receptionistId = receptionistId;
        objAddPhoneCallGeneralInquiryBO.phoneNo        = phoneNo;
        objAddPhoneCallGeneralInquiryBO.callDate       = callDate;
        objAddPhoneCallGeneralInquiryBO.callTime       = callTime;
        objAddPhoneCallGeneralInquiryBO.callerName     = callerName;
        objAddPhoneCallGeneralInquiryBO.callerQuery    = callerQuery;
        objAddPhoneCallGeneralInquiryBO.callOutcome    = callOutcome;

        AddPhoneCallGeneralInquiryDL objAddPhoneCallGeneralInquiryDL = new AddPhoneCallGeneralInquiryDL();

        objAddPhoneCallGeneralInquiryDL.AddPhoneCallGeneralInquiry(objAddPhoneCallGeneralInquiryBO);
    }
Esempio n. 4
0
    public void AddPhoneCallGeneralInquiry(AddPhoneCallGeneralInquiryBO objAddPhoneCallGeneralInquiryBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand    cmd  = new SqlCommand("spAddPhoneCallGeneralInquiry", conn);

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@receptionistId", objAddPhoneCallGeneralInquiryBO.receptionistId);
        cmd.Parameters.Add("@phoneNo", objAddPhoneCallGeneralInquiryBO.phoneNo);
        cmd.Parameters.Add("@callDate", objAddPhoneCallGeneralInquiryBO.callDate);
        cmd.Parameters.Add("@callTime", objAddPhoneCallGeneralInquiryBO.callTime);
        cmd.Parameters.Add("@callerName", objAddPhoneCallGeneralInquiryBO.callerName);
        cmd.Parameters.Add("@callerQuery", objAddPhoneCallGeneralInquiryBO.callerQuery);
        cmd.Parameters.Add("@callOutcome", objAddPhoneCallGeneralInquiryBO.callOutcome);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }