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