protected void BindSearchFieldDdl()
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
DataTable table = new DataTable();
table.Columns.Add("Text");
table.Columns.Add("Value");
DataRow dr;
List <string> lst = new List <string> {
"None / All", "Policy No.", "Claim No.", "Mobile Number", "Date",
};
if (CurrentUser.Role() == "Admin")
{
lst.Add("Sent By");
}
foreach (var x in lst)
{
dr = table.NewRow();
dr["Value"] = x;
dr["Text"] = x;
table.Rows.Add(dr);
}
ddlSearchField.DataSource = table;
ddlSearchField.DataTextField = table.Columns["Text"].ColumnName;
ddlSearchField.DataValueField = table.Columns["Value"].ColumnName;
ddlSearchField.AutoPostBack = true;
ddlSearchField.DataBind();
ddlSearchField.SelectedIndexChanged += new System.EventHandler(BindCategories);
}
protected void BindDataToGridView()
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Created At", typeof(string)));
dt.Columns.Add(new DataColumn("User Name", typeof(string)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
dt.Columns.Add(new DataColumn("Edit", typeof(string)));
dt.Columns.Add(new DataColumn("Change Password", typeof(string)));
foreach (var x in _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.Role != "Admin").OrderBy(x => x.Created_At).ToList())
{
dr = dt.NewRow();
dr["Created At"] = DateTimeHelper.ConvertToString(x.Created_At.ToString());
dr["User Name"] = x.User_Name;
dr["Status"] = x.Status;
dr["Edit"] = x.Id;
dr["Change Password"] = x.Id;
dt.Rows.Add(dr);
}
gvUsers.DataSource = dt;
gvUsers.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var userName = txtUserName.Text.Trim();
if (hdnCurrentUserName.Value != txtUserName.Text.Trim())
{
var count = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.User_Name == userName).Count();
if (count > 0)
{
Session["ErrorMessage"] = "User with the user name already exists!";
return;
}
}
var userId = int.Parse(hdnUserId.Value);
var user = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.Id == userId).First();
user.User_Name = userName;
user.Status = ddlStatus.SelectedValue;
user.Updated_At = DateTime.Now;
user.Can_Search = ckbSearch.Checked;
_sms_EMAIL_DB_Entities.SaveChanges();
Session["NoticeMessage"] = "Successfully updated the user!";
Response.Redirect("index.aspx");
}
protected void btnResend_Click(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var smsId = long.Parse(hdnFldSMSId.Value);
sms = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Id == smsId).First();
var phone = sms.Mobile_Number;
var message = sms.Text;
var sms_code = SmsSender.Send(phone, message);
var sms_code_decode = StringHelper.ConvertResponseCode(sms_code);
sms.SMS_Code = sms_code;
sms.SMS_Code_Decode = sms_code_decode;
sms.SMS_Sent_At = DateTime.Now;
_sms_EMAIL_DB_Entities.SaveChanges();
tEvent = new tbl_Events {
Created_At = DateTime.Now,
Code = sms_code,
Status = sms_code_decode,
Email_Sms_Id = sms.Id
};
_sms_EMAIL_DB_Entities.AddTotbl_Events(tEvent);
_sms_EMAIL_DB_Entities.SaveChanges();
Session["NoticeMessage"] = "Please check SMS status !";
Response.Redirect("Details.aspx?id=" + smsId.ToString());
}
protected void btnSave_Click(object sender, EventArgs e)
{
HttpPostedFile postedFile = Request.Files["smsFile"];
if (postedFile == null || postedFile.ContentLength <= 0)
{
Session["ErrorMessage"] = "Please select a file";
return;
}
var outputFile = FileHelper.SaveFile(postedFile);
long tmpId = long.Parse(ddlTemplate.SelectedValue);
int userId = CurrentUser.Id();
_SMS_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
bulk_SMS = new tbl_Bulk_SMS
{
Created_At = DateTime.Now,
File_Name = outputFile["FileName"].ToString(),
File_Path = outputFile["FilePath"].ToString(),
Status = "New",
Updated_At = DateTime.Now,
Template_Id = tmpId,
User_Id = userId
};
_SMS_EMAIL_DB_Entities.AddTotbl_Bulk_SMS(bulk_SMS);
_SMS_EMAIL_DB_Entities.SaveChanges();
Response.Redirect("Index.aspx");
}
public static tbl_Users DBUser()
{
SMS_EMAIL_DB_Entities _sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var currentUserId = CurrentUser.Id();
var user = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.Id == currentUserId).First();
return(user);
}
protected void lkBtnErrorDownload_Click(object sender, EventArgs e)
{
var lkBtn = (LinkButton)sender;
var id = long.Parse(lkBtn.CommandArgument.ToString());
_SMS_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
bulk_SMS = _SMS_EMAIL_DB_Entities.tbl_Bulk_SMS.Where(x => x.Id == id).First();
sendFile(bulk_SMS.Error_File_Name, bulk_SMS.Error_File_Path);
}
protected void BindGridView()
{
_SMS_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
if (CurrentUser.Role() == "Admin")
{
var data = from bs in _SMS_EMAIL_DB_Entities.tbl_Bulk_SMS
join t in _SMS_EMAIL_DB_Entities.tbl_Templates
on bs.Template_Id equals t.Id
orderby bs.Created_At descending
select new
{
Id = bs.Id,
TemplateName = t.Name,
CreatedAt = bs.Created_At,
InputFileName = bs.File_Name,
InputFilePath = bs.File_Path,
OutputFilePath = bs.Output_File_Path,
OutputFileName = bs.Output_File_Name,
ErrorFileName = bs.Error_File_Name,
ErrorFilePath = bs.Error_File_Path,
Visible = !string.IsNullOrEmpty(bs.Output_File_Path),
ErrorVisible = !string.IsNullOrEmpty(bs.Error_File_Path),
Status = bs.Status
};
gvSMS.DataSource = data;
gvSMS.DataBind();
}
else
{
var id = CurrentUser.Id();
var data = from bs in _SMS_EMAIL_DB_Entities.tbl_Bulk_SMS
join t in _SMS_EMAIL_DB_Entities.tbl_Templates
on bs.Template_Id equals t.Id
where bs.User_Id == id
orderby bs.Created_At descending
select new
{
Id = bs.Id,
TemplateName = t.Name,
CreatedAt = bs.Created_At,
InputFileName = bs.File_Name,
InputFilePath = bs.File_Path,
OutputFilePath = bs.Output_File_Path,
OutputFileName = bs.Output_File_Name,
ErrorFileName = bs.Error_File_Name,
ErrorFilePath = bs.Error_File_Path,
Visible = !string.IsNullOrEmpty(bs.Output_File_Path),
ErrorVisible = !string.IsNullOrEmpty(bs.Error_File_Path),
Status = bs.Status
};
gvSMS.DataSource = data;
gvSMS.DataBind();
}
}
protected void btnSendDuplicate_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var phoneNumber = "966" + txtMobile.Text.Trim();
using (_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities())
{
sendSMS(phoneNumber);
}
Response.Redirect("Index.aspx");
}
}
protected void AddNewTemplate(object sender, EventArgs e)
{
entity = new SMS_EMAIL_DB_Entities();
tmp = new tbl_Templates();
tmp.Type = ddlNewType.SelectedValue;
tmp.Name = txtNewName.Text;
tmp.Text = txtTextNew.Text;
tmp.Created_At = DateTime.Now;
tmp.Updated_At = DateTime.Now;
entity.AddTotbl_Templates(tmp);
entity.SaveChanges();
BindGridView();
}
protected void UpdateTemplate(object sender, GridViewUpdateEventArgs e)
{
Id = long.Parse(((HiddenField)gvTemplates.Rows[e.RowIndex].FindControl("hdnFldId")).Value);
entity = new SMS_EMAIL_DB_Entities();
tmp = entity.tbl_Templates.Where(x => x.Id == Id).First();
tmp.Type = ((DropDownList)gvTemplates.Rows[e.RowIndex].FindControl("ddlType")).Text;
tmp.Name = ((TextBox)gvTemplates.Rows[e.RowIndex].FindControl("txtName")).Text;
tmp.Text = ((TextBox)gvTemplates.Rows[e.RowIndex].FindControl("txtText")).Text;
tmp.Updated_At = DateTime.Now;
entity.SaveChanges();
gvTemplates.EditIndex = -1;
BindGridView();
}
protected void btnSave_Click(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var userId = int.Parse(hdnUserId.Value);
var password = StringHelper.MD5Hash(txtPassword.Text.Trim());
var user = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.Id == userId).First();
user.Password = password;
user.Updated_At = DateTime.Now;
_sms_EMAIL_DB_Entities.SaveChanges();
Session["NoticeMessage"] = "Successfully changed password!";
Response.Redirect("Index.aspx");
}
protected void btnSend_Click(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var currentUserId = CurrentUser.Id();
var email = new tbl_Emails_SMS {
Claim_Number = txtClaimNumber.Text, Policy_Number = txtPolicyNumber.Text, TP_Name = txtTpName.Text, Email = txtEmail.Text, Text = txtText.Text, Type = "Email", User_Id = currentUserId, Created_At = DateTime.Now, Mobile_Number = txtMobile.Text, Email_Subject = txtSubject.Text, TP_ID = txtTPID.Text, SMS_Sent_At = DateTime.Now
};
_sms_EMAIL_DB_Entities.AddTotbl_Emails_SMS(email);
_sms_EMAIL_DB_Entities.SaveChanges();
Session["NoticeMessage"] = "Successfully send an email !";
Mailer.SendMailMessage(txtEmail.Text.ToString().Trim(), "", "", txtSubject.Text.ToString().Trim(), txtText.Text.ToString().Trim());
Response.Redirect("Index.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
SMS_EMAIL_DB_Entities _sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var password = StringHelper.MD5Hash(txtPassword.Text.ToString());
tbl_Users user = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.User_Name == txtUserName.Text).Where(x => x.Password == password && x.Status == "Active").FirstOrDefault();
if (user == null)
{
errorDiv.Visible = true;
return;
}
FormsAuthentication.SetAuthCookie(user.User_Name, false);
FormsAuthenticationTicket ticket1 =
new FormsAuthenticationTicket(
1, // version
user.User_Name, // get username from the form
DateTime.Now, // issue time is now
DateTime.Now.AddHours(11), // expires in 10 minutes
false, // cookie is not persistent
user.Role + "#" + user.Id.ToString() // role assignment is stored
);
HttpCookie cookie1 = new HttpCookie(
FormsAuthentication.FormsCookieName,
FormsAuthentication.Encrypt(ticket1));
Response.Cookies.Add(cookie1);
int?count = user.Sign_In_Count.Equals(String.Empty) ? 0 : user.Sign_In_Count;
user.Sign_In_Count = count + 1;
user.Last_Sign_In_At = DateTime.Now;
_sms_EMAIL_DB_Entities.SaveChanges();
String returnUrl1 = "";
if (Request.QueryString["ReturnUrl"] != null)
{
returnUrl1 = Request.QueryString["ReturnUrl"];
}
else
{
returnUrl1 = CurrentUser.GetRedirectPath(user.Role);
}
Session["NoticeMessage"] = "Successfully logged in !";
Response.Redirect(returnUrl1);
}
protected void Page_Load(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var emailId = long.Parse(Request.QueryString["id"]);
if (CurrentUser.Role() == "Admin")
{
email = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Id == emailId).First();
}
else
{
var currentUserId = CurrentUser.Id();
email = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Id == emailId).Where(x => x.User_Id == currentUserId).FirstOrDefault();
if (email == null)
{
Response.Redirect("NotAuthorized.aspx");
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
hdnUserId.Value = Request.QueryString["id"];
var userId = int.Parse(hdnUserId.Value);
var user = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.Id == userId).Where(x => x.Role != "Admin").FirstOrDefault();
if (user == null)
{
Session["ErrorMessage"] = "You are not authorizrd to acces this user!";
Response.Redirect("Index.aspx");
return;
}
txtUserName.Text = user.User_Name;
ddlStatus.SelectedValue = user.Status;
hdnCurrentUserName.Value = user.User_Name;
ckbSearch.Checked = user.Can_Search.Value;
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var phoneNumber = "966" + txtMobile.Text.Trim();
//id = long.Parse(ddlTemplate.SelectedValue);
using (_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities())
{
var count = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Mobile_Number == phoneNumber).Count();
if (count == 0)
{
sendSMS(phoneNumber);
Response.Redirect("Index.aspx");
return;
}
}
btnSend.Visible = false;
duplicateSmsDiv.Visible = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var currentUserId = CurrentUser.Id();
string currentPassword = StringHelper.MD5Hash(txtCurrentPassword.Text.Trim());
var user = _sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.Id == currentUserId).First();
if (currentPassword != user.Password)
{
Session["ErrorMessage"] = "You current password is in correct!";
return;
}
var password = StringHelper.MD5Hash(txtPassword.Text.Trim());
user.Password = password;
user.Updated_At = DateTime.Now;
_sms_EMAIL_DB_Entities.SaveChanges();
Session["NoticeMessage"] = "Successfully changed your password!";
Response.Redirect(CurrentUser.GetRedirectPath(CurrentUser.Role()));
}
protected void btnSave_Click(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var userName = txtUserName.Text.Trim();
if (_sms_EMAIL_DB_Entities.tbl_Users.Where(x => x.User_Name == userName).FirstOrDefault() != null)
{
Session["ErrorMessage"] = "User with same user name already exists!";
return;
}
var password = StringHelper.MD5Hash(txtPassword.Text.Trim());
var currentTime = DateTime.Now;
var user = new tbl_Users {
User_Name = userName, Password = password, Role = "Normal_User", Can_Search = ckbSearch.Checked,
Status = ddlStatus.SelectedValue, Sign_In_Count = 0, Created_At = currentTime, Updated_At = currentTime
};
_sms_EMAIL_DB_Entities.AddTotbl_Users(user);
_sms_EMAIL_DB_Entities.SaveChanges();
Session["NoticeMEssage"] = "Successfully created a new user";
Response.Redirect("Index.aspx");
}
protected void AddNewTemplate(object sender, EventArgs e)
{
_text = txtTextNew.Text;
if (ddlNewType.SelectedValue == "BULK_SMS_DYNAMIC" && !_text.Contains("{variable}"))
{
lblErrorN.Visible = true;
return;
}
lblErrorN.Visible = false;
entity = new SMS_EMAIL_DB_Entities();
tmp = new tbl_Templates();
tmp.Type = ddlNewType.SelectedValue;
tmp.Name = txtNewName.Text;
tmp.Text = txtTextNew.Text;
tmp.Created_At = DateTime.Now;
tmp.Updated_At = DateTime.Now;
entity.AddTotbl_Templates(tmp);
entity.SaveChanges();
BindGridView();
txtNewName.Text = string.Empty;
txtTextNew.Text = string.Empty;
ddlNewType.SelectedValue = "SMS";
}
protected void UpdateTemplate(object sender, GridViewUpdateEventArgs e)
{
_text = ((TextBox)gvTemplates.Rows[e.RowIndex].FindControl("txtText")).Text;
_lblError = gvTemplates.Rows[e.RowIndex].FindControl("lblError") as Label;
var ddl = ((DropDownList)gvTemplates.Rows[e.RowIndex].FindControl("ddlType"));
if (ddl.SelectedValue == "BULK_SMS_DYNAMIC" && !_text.Contains("{variable}"))
{
_lblError.Visible = true;
return;
}
_lblError.Visible = false;
Id = long.Parse(((HiddenField)gvTemplates.Rows[e.RowIndex].FindControl("hdnFldId")).Value);
entity = new SMS_EMAIL_DB_Entities();
tmp = entity.tbl_Templates.Where(x => x.Id == Id).First();
tmp.Type = ddl.SelectedValue;
tmp.Name = ((TextBox)gvTemplates.Rows[e.RowIndex].FindControl("txtName")).Text;
tmp.Text = _text;
tmp.Updated_At = DateTime.Now;
entity.SaveChanges();
gvTemplates.EditIndex = -1;
BindGridView();
}
protected void BindDataToGridView()
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Sent At", typeof(string)));
dt.Columns.Add(new DataColumn("Sent To", typeof(string)));
dt.Columns.Add(new DataColumn("Sent By", typeof(string)));
dt.Columns.Add(new DataColumn("Details", typeof(string)));
List <tbl_Emails_SMS> list;
if (CurrentUser.Role() == "Admin")
{
list = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Type == "Email").OrderByDescending(x => x.Created_At).ToList();
}
else
{
var currentUserId = CurrentUser.Id();
list = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Type == "Email").Where(x => x.User_Id == currentUserId).OrderByDescending(x => x.Created_At).ToList();
}
foreach (var x in list)
{
dr = dt.NewRow();
dr["Sent At"] = DateTimeHelper.ConvertToString(x.Created_At.ToString());
dr["Sent To"] = x.Email;
dr["Sent By"] = x.tbl_Users.User_Name;
dr["Details"] = x.Id;
dt.Rows.Add(dr);
}
gvEmails.DataSource = dt;
gvEmails.DataBind();
}
protected void BindDdlUsersRoot(DropDownList ddlRoot, bool active = true)
{
using (_entity = GetEntity())
{
var data = from u in _entity.tbl_Users
//where u.Status == "Active"
orderby u.User_Name
select new
{
Name = u.User_Name,
Id = u.Id,
Role = u.Role
};
lstTV = new List <TextValue>();
foreach (var x in data)
{
objTV = new TextValue {
Text = x.Name, Value = x.Id.ToString()
};
lstTV.Add(objTV);
}
}
BindDDlRoot(ddlRoot);
}
protected void Page_Load(object sender, EventArgs e)
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
var smsId = long.Parse(Request.QueryString["id"]);
if (CurrentUser.Role() == "Admin")
{
sms = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Id == smsId).First();
}
else
{
var currentUserId = CurrentUser.Id();
sms = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Id == smsId).Where(x => x.User_Id == currentUserId).FirstOrDefault();
if (sms == null)
{
Response.Redirect("NotAuthorized.aspx");
return;
}
}
hdnFldSMSId.Value = smsId.ToString();
btnResend.Visible = sms.SMS_Code_Decode != "Success";
gvEvents.DataSource = sms.tbl_Events;
gvEvents.DataBind();
}
protected void BindGridView()
{
entity = new SMS_EMAIL_DB_Entities();
gvTemplates.DataSource = entity.tbl_Templates.ToList();
gvTemplates.DataBind();
}
protected void BindDataToGridView()
{
_sms_EMAIL_DB_Entities = new SMS_EMAIL_DB_Entities();
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Sent At", typeof(string)));
dt.Columns.Add(new DataColumn("Sent To", typeof(string)));
dt.Columns.Add(new DataColumn("Sent By", typeof(string)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
dt.Columns.Add(new DataColumn("Details", typeof(string)));
IQueryable <tbl_Emails_SMS> ls;
List <tbl_Emails_SMS> list;
if (CurrentUser.Role() == "Admin")
{
ls = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Type == "SMS");
}
else
{
var currentUserId = CurrentUser.Id();
ls = _sms_EMAIL_DB_Entities.tbl_Emails_SMS.Where(x => x.Type == "SMS").Where(x => x.User_Id == currentUserId);
}
switch (ddlSearchField.SelectedValue)
{
case "Mobile Number":
ls = ls.Where(x => x.Mobile_Number.Contains(txtField.Text));
break;
case "Date":
var date = txtSentDate.Text;
DateTime startDate, endDate;
DateTimeHelper.GetStartAndEndTime(date, out startDate, out endDate);
ls = ls.Where(x => x.SMS_Sent_At >= startDate).Where(x => x.SMS_Sent_At <= endDate);
break;
case "Sent By":
ls = ls.Where(x => x.tbl_Users.User_Name.Contains(txtField.Text));
break;
case "Policy No.":
ls = ls.Where(x => x.Policy_Number.Contains(txtField.Text));
break;
case "Claim No.":
ls = ls.Where(x => x.Claim_Number.Contains(txtField.Text));
break;
default: break;
}
list = ls.OrderByDescending(x => x.Created_At).ToList();
foreach (var x in list)
{
dr = dt.NewRow();
dr["Sent At"] = x.SMS_Sent_At.ToString();
dr["Sent To"] = x.Mobile_Number;
dr["Sent By"] = x.tbl_Users.User_Name;
dr["Status"] = x.SMS_Code_Decode;
dr["Details"] = x.Id;
dt.Rows.Add(dr);
}
gvSMS.DataSource = dt;
gvSMS.DataBind();
}
protected SMS_EMAIL_DB_Entities GetEntity()
{
_entity = new SMS_EMAIL_DB_Entities();
return(_entity);
}
