//Log email in db
public static void log_email_into_db(string type, int booking_id, string to_email_ids, string cc_email_ids, string bcc_email_ids, string error, int is_sent)
{
DB.clsDB db = new DB.clsDB();
db.AddParameter("TYPE", type, 20);
db.AddParameter("BOOKING_ID", booking_id);
db.AddParameter("TO_EMAIL_ID", to_email_ids, 200);
db.AddParameter("CC_EMAIL_ID", cc_email_ids, 200);
db.AddParameter("BCC_EMAIL_ID", cc_email_ids, 200);
db.AddParameter("SEND_TIME", DateTime.Now);
db.AddParameter("ERROR", error, 20);
db.AddParameter("IS_SENT", is_sent);
db.ExecuteDML("spEmailLog_Insert", CommandType.StoredProcedure, 30);
}
//Log email in db
public static void log_email_into_db(string type, int booking_id, string to_email_ids, string cc_email_ids, string bcc_email_ids, string error, int is_sent)
{
DB.clsDB db = new DB.clsDB();
db.AddParameter("TYPE", type, 20);
db.AddParameter("BOOKING_ID", booking_id);
db.AddParameter("TO_EMAIL_ID", to_email_ids, 200);
db.AddParameter("CC_EMAIL_ID", cc_email_ids, 200);
db.AddParameter("BCC_EMAIL_ID", cc_email_ids, 200);
db.AddParameter("SEND_TIME", DateTime.Now);
db.AddParameter("ERROR", error, 20);
db.AddParameter("IS_SENT", is_sent);
db.ExecuteDML("spEmailLog_Insert", CommandType.StoredProcedure, 30);
}
public static void log_sms_into_db(int booking_id, string mobile_no, string url, int is_sent)
{
int sms_id = 0;
string str_error = "";
DB.clsDB db = new DB.clsDB();
db.AddParameter("SMS_ID", sms_id);
db.AddParameter("BOOKING_ID", booking_id);
db.AddParameter("MOBILE_NO", mobile_no, 20);
db.AddParameter("URL", url, 500);
db.AddParameter("URL_DEPART", "", 20);
db.AddParameter("SEND_TIME", DateTime.Now);
db.AddParameter("ERR_MSG", str_error, 20);
db.AddParameter("IS_SENT", is_sent);
db.ExecuteDML("spSMSLog_Insert", CommandType.StoredProcedure, 30);
}
