private void binddrpsms() { DTO.sms Ob = new DTO.sms(); DataSet ds = new DataSet(); Ob.BranchId = Globals.BranchID; ds = BAL.BALFactory.Instance.BAL_sms.ShowAll(Ob); if (ds.Tables[0].Rows.Count > 0) { Drpnewbooking.DataSource = ds.Tables[0]; Drpnewbooking.DataTextField = "template"; Drpnewbooking.DataValueField = "smsid"; Drpnewbooking.DataBind(); Drpclothready.DataSource = ds.Tables[0]; Drpclothready.DataTextField = "template"; Drpclothready.DataValueField = "smsid"; Drpclothready.DataBind(); drpdelivery.DataSource = ds.Tables[0]; drpdelivery.DataTextField = "template"; drpdelivery.DataValueField = "smsid"; drpdelivery.DataBind(); } }
public DTO.sms getvalueapi() { DTO.sms Ob = new DTO.sms(); DataSet ds = new DataSet(); Ob.BranchId = Globals.BranchID; ds = BAL.BALFactory.Instance.BAL_sms.fetchapi(Ob); Ob.userid = txtuserName.Text; if (txtpassword.Text == "") { Ob.password = ds.Tables[0].Rows[0]["password"].ToString(); } else { Ob.password = txtpassword.Text; } Ob.api = txtapi.Text; Ob.senderid = Txtsenderid.Text; Ob.senderdemo = Txtsenderidpreview.Text; Ob.massagedemo = Txtmassagepreview.Text; Ob.mobiledemo = txtmobile.Text; Ob.useriddemo = txtusernamepreview.Text; Ob.passworddemo = txtpasswordpreview.Text; Ob.senderposition = Drpsender.SelectedItem.ToString(); Ob.mobileposition = Drpmobile.SelectedItem.ToString(); Ob.passwordposition = Drppassword.SelectedItem.ToString(); Ob.massageposition = Drpmassage.SelectedItem.ToString(); Ob.userposition = Drpusername.SelectedItem.ToString(); Ob.BranchId = Globals.BranchID; return(Ob); }
public string apiupdate(DTO.sms Ob) { SqlCommand cmd = new SqlCommand(); string res = string.Empty; cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userid", Ob.userid); cmd.Parameters.AddWithValue("@password", Ob.password); cmd.Parameters.AddWithValue("@api", Ob.api); cmd.Parameters.AddWithValue("@senderid", Ob.senderid); cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@massagedemo", Ob.massagedemo); cmd.Parameters.AddWithValue("@mobiledemo", Ob.mobiledemo); cmd.Parameters.AddWithValue("@senderdemo", Ob.senderdemo); cmd.Parameters.AddWithValue("@useriddemo", Ob.useriddemo); cmd.Parameters.AddWithValue("@passworddemo", Ob.passworddemo); cmd.Parameters.AddWithValue("@senderposition", Ob.senderposition); cmd.Parameters.AddWithValue("@userposition", Ob.userposition); cmd.Parameters.AddWithValue("@passwordposition", Ob.passwordposition); cmd.Parameters.AddWithValue("@mobileposition", Ob.mobileposition); cmd.Parameters.AddWithValue("@massageposition", Ob.massageposition); cmd.Parameters.AddWithValue("@Flag", 6); res = PrjClass.ExecuteNonQuery(cmd); return(res); }
protected void btpreview_Click(object sender, EventArgs e) { DTO.sms Ob = new DTO.sms(); Ob = previewdropfetch(); DataSet ds = new DataSet(); ds = BAL.BALFactory.Instance.BAL_sms.previewbooking(Ob); //Lbbooking.Text = ds.Tables[0].Rows[0]["massage"].ToString(); //Lbclothready.Text = ds.Tables[1].Rows[0]["massage"].ToString(); //Lbdelivery.Text = ds.Tables[2].Rows[0]["massage"].ToString(); string databasemessage = ds.Tables[0].Rows[0]["massage"].ToString(); string databasemessage1 = ds.Tables[1].Rows[0]["massage"].ToString(); string databasemessage2 = ds.Tables[2].Rows[0]["massage"].ToString(); Dictionary <string, string> replacements = new Dictionary <string, string>() { { "[Customer Name]", ds.Tables[3].Rows[0]["CustomerName"].ToString() }, { "[Booking No]", ds.Tables[3].Rows[0]["BookingNumber"].ToString() }, { "[Amount]", ds.Tables[3].Rows[0]["TotalAmount"].ToString() }, { "[Quantity]", ds.Tables[3].Rows[0]["TotalQty"].ToString() }, { "[Delivery Date]", ds.Tables[3].Rows[0]["duedate"].ToString() } }; Dictionary <string, string> replacements1 = new Dictionary <string, string>() { { "[Customer Name]", ds.Tables[3].Rows[0]["CustomerName"].ToString() }, { "[Booking No]", ds.Tables[3].Rows[0]["BookingNumber"].ToString() }, { "[Amount]", ds.Tables[3].Rows[0]["TotalAmount"].ToString() }, { "[Quantity]", ds.Tables[3].Rows[0]["TotalQty"].ToString() }, { "[Delivery Date]", ds.Tables[3].Rows[0]["duedate"].ToString() } }; Dictionary <string, string> replacements2 = new Dictionary <string, string>() { { "[Customer Name]", ds.Tables[3].Rows[0]["CustomerName"].ToString() }, { "[Booking No]", ds.Tables[3].Rows[0]["BookingNumber"].ToString() }, { "[Amount]", ds.Tables[3].Rows[0]["TotalAmount"].ToString() }, { "[Quantity]", ds.Tables[3].Rows[0]["TotalQty"].ToString() }, { "[Delivery Date]", ds.Tables[3].Rows[0]["duedate"].ToString() } }; foreach (var r in replacements) { databasemessage = databasemessage.Replace(r.Key, r.Value); } foreach (var r in replacements1) { databasemessage1 = databasemessage1.Replace(r.Key, r.Value); } foreach (var r in replacements2) { databasemessage2 = databasemessage2.Replace(r.Key, r.Value); } Lbbooking.Text = databasemessage; Lbclothready.Text = databasemessage1; Lbdelivery.Text = databasemessage2; }
public DTO.sms previewdropfetch() { Ob = new DTO.sms(); Ob.bookingsms = Drpnewbooking.SelectedValue.ToString(); Ob.clothsms = Drpclothready.SelectedValue.ToString(); Ob.deliverysms = drpdelivery.SelectedValue.ToString(); Ob.BranchId = Globals.BranchID; return(Ob); }
private void binddrpdefaultsms() { DTO.sms Ob = new DTO.sms(); DataSet ds = new DataSet(); Ob.BranchId = Globals.BranchID; ds = BAL.BALFactory.Instance.BAL_sms.fetchdropdelivery(Ob); PrjClass.SetItemInDropDown(drpsmstemplate, ds.Tables[4].Rows[0]["Template"].ToString(), true, false); }
public DTO.sms defaultsmsSetValue() { Ob = new DTO.sms(); Ob.bookingsms = Drpnewbooking.SelectedValue.ToString(); Ob.clothsms = Drpclothready.SelectedValue.ToString(); Ob.deliverysms = drpdelivery.SelectedValue.ToString(); Ob.BranchId = Globals.BranchID; return(Ob); }
public DataSet ShowAll(DTO.sms Ob) { SqlCommand cmd = new SqlCommand(); DataSet ds = new DataSet(); cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@Flag", 3); ds = PrjClass.GetData(cmd); return(ds); }
public DTO.sms SetValue() { Ob = new DTO.sms(); Ob.Template = txttemplate.Text; Ob.Massage = txtmessage.Text; Ob.Active = 1; Ob.DateModified = Globals.date[0].ToString(); Ob.SmsId = lblUpdateId.Text; Ob.BranchId = Globals.BranchID; Ob.DefaultMsg = drpDefaultMsg.SelectedItem.Text; return(Ob); }
public string Deletesms(DTO.sms Ob) { SqlCommand cmd = new SqlCommand(); string res = string.Empty; cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SmsId", Ob.SmsId); cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@Flag", 5); res = PrjClass.ExecuteNonQuery(cmd); return(res); }
public DataSet BindGridView(DTO.sms Ob) { SqlCommand cmd = new SqlCommand(); DataSet ds = new DataSet(); cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@template", Ob.Template); cmd.Parameters.AddWithValue("@massage", Ob.Massage); cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@Flag", 4); ds = PrjClass.GetData(cmd); return(ds); }
protected void btnapisettting_Click(object sender, EventArgs e) { Ob = getvalueapi(); string res = BAL.BALFactory.Instance.BAL_sms.apiupdate(Ob); if (res == "Record Saved") { lblapiSuccess.Text = "Update Sucessfully"; } else { lblapiError.Text = "Error"; } }
public void setDefault() { btnSave.Visible = true; btnEdit.Visible = false; txttemplate.Enabled = true; txttemplate.Focus(); txttemplate.Text = ""; txtmessage.Text = ""; drpDefaultMsg.SelectedIndex = -1; Ob = SetValue(); grdsms.DataSource = BAL.BALFactory.Instance.BAL_sms.ShowAll(Ob); grdsms.DataBind(); Select1.SelectedIndex = -1; }
public DataSet previewbooking(DTO.sms Ob) { SqlCommand cmd = new SqlCommand(); DataSet ds = new DataSet(); cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@bookingsms", Ob.bookingsms); cmd.Parameters.AddWithValue("@clothsms", Ob.clothsms); cmd.Parameters.AddWithValue("@deliverysms", Ob.deliverysms); cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@Flag", 12); ds = PrjClass.GetData(cmd); return(ds); }
public string defaultsmsupdate(DTO.sms Ob) { SqlCommand cmd = new SqlCommand(); string res = string.Empty; cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@bookingsms", Ob.bookingsms); cmd.Parameters.AddWithValue("@clothsms", Ob.clothsms); cmd.Parameters.AddWithValue("@deliverysms", Ob.deliverysms); cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@Flag", 8); res = PrjClass.ExecuteNonQuery(cmd); return(res); }
private void binddrpdefault() { DTO.sms Ob = new DTO.sms(); DataSet ds = new DataSet(); Ob.BranchId = Globals.BranchID; ds = BAL.BALFactory.Instance.BAL_sms.fetchdropdelivery(Ob); PrjClass.SetItemInDropDown(Drpnewbooking, ds.Tables[3].Rows[0]["Template"].ToString(), true, false); PrjClass.SetItemInDropDown(Drpclothready, ds.Tables[1].Rows[0]["Template"].ToString(), true, false); PrjClass.SetItemInDropDown(drpdelivery, ds.Tables[2].Rows[0]["Template"].ToString(), true, false); if (ds.Tables[0].Rows.Count > 0) { btpreview_Click(null, null); } }
protected void btdefaultsmsupdate_Click(object sender, EventArgs e) { string res = ""; Ob = defaultsmsSetValue(); res = BAL.BALFactory.Instance.BAL_sms.defaultsmsupdate(Ob); if (res == "Record Saved") { Lbdefaultsmssuccess.Text = "Record Updated"; } else { Lbdefaultsmserror.Text = "Error"; } }
public string Savesmsconfig(DTO.sms Ob) { string res = string.Empty; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SP_smsconfig"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@template", Ob.Template); cmd.Parameters.AddWithValue("@massage", Ob.Massage); cmd.Parameters.AddWithValue("@Active", Ob.Active); cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId); cmd.Parameters.AddWithValue("@MsgScreen", Ob.DefaultMsg); cmd.Parameters.AddWithValue("@Flag", 1); res = PrjClass.ExecuteNonQuery(cmd); return(res); }
protected void btnSave_Click(object sender, EventArgs e) { string res = ""; Ob = SetValue(); res = BAL.BALFactory.Instance.BAL_sms.Savesmsconfig(Ob); if (res == "Record Saved") { lblMsg.Text = res; setDefault(); } else { lblErr.Text = res; } }
public string Savesmsconfig(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.Savesmsconfig(Ob)); }
public DataSet previewbooking(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.previewbooking(Ob)); }
public DataSet fetchdropcloth(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.fetchdropcloth(Ob)); }
public string Deletesms(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.Deletesms(Ob)); }
public DataSet fetchapi(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.fetchapi(Ob)); }
public DataSet fetchdropdelivery(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.fetchdropdelivery(Ob)); }
protected void btnSearch_Click(object sender, EventArgs e) { Ob = SetValue(); grdsms.DataSource = BAL.BALFactory.Instance.BAL_sms.BindGridView(Ob); grdsms.DataBind(); }
public string apiupdate(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.apiupdate(Ob)); }
public string defaultsmsupdate(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.defaultsmsupdate(Ob)); }
public DataSet ShowAll(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.ShowAll(Ob)); }
public DataSet fetchdropbooking(DTO.sms Ob) { return(DAL.DALFactory.Instance.DAL_sms.fetchdropbooking(Ob)); }