protected void btngridsubmit_Click(object sender, EventArgs e)
{
try
{
objBL_Common = new BL_Common();
string columnname = string.Empty;
if (ddlcolumn.SelectedValue == "1")
columnname = "Designation";
else if (ddlcolumn.SelectedValue == "2")
columnname = "City1";
else if (ddlcolumn.SelectedValue == "3")
columnname = "State1";
else if (ddlcolumn.SelectedValue == "4")
columnname = "Country1";
else if (ddlcolumn.SelectedValue == "5")
columnname = "Addressline1";
objBL_Common.AccessUpdateAllCampaign("EC_UserContacts", "" + columnname + " = '" + txtCampName.Value.Trim() + "' ", "PK_ContactID in (" + Session["massupdatecontid"].ToString() + ")");
lblcontact.Text = "Your contact details are updated successfully.";
lblcontact.CssClass = "labelsuccess";
ddlcolumn.SelectedValue = "0";
txtCampName.Value = "";
Session["massupdatecontid"] = null;
Session.Remove("massupdatecontid");
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("MassUpdateContact.aspx:btngridsubmit_Click() - " + ex.Message);
}
}
public void InsertUserPlan(int loginid)
{
DataTable dtplantype = new DataTable();
objBL_Common = new BL_Common();
try
{
dtplantype = objBL_Common.plantypedetails("top 1 *", "EC_PlanType", "LOWER(PlanName)='FREE' and IsActive = 1 order by plandate desc");
if (dtplantype.Rows.Count > 0)
{
objUserPlan = new UserPlan();
objBL_UserPlan = new BL_UserPlan();
objUserPlan.FK_UserID = loginid;
objUserPlan.FK_PlanID = Convert.ToInt32(dtplantype.Rows[0]["PK_PlanID"].ToString());
objUserPlan.ActiveFrom = DateTime.Now;
objUserPlan.ActiveTo = DateTime.Now.AddMonths(1);
objUserPlan.IsActive = true;
objUserPlan.CreatedBy = loginid;
objUserPlan.CreatedOn = DateTime.Now;
objBL_UserPlan.AccessInsertUserPlan(objUserPlan);
string[] UPtype = new string[3];
UPtype[0] = Convert.ToString(dtplantype.Rows[0]["IsSingleUser"]);
UPtype[1] = Convert.ToString(dtplantype.Rows[0]["NOC"]);
UPtype[2] = Convert.ToString(dtplantype.Rows[0]["AllowedMails"]);
Session["lstUserPlanType"] = UPtype;
objUserPlan = null;
objBL_UserPlan = null;
}
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("FreeAccountSignUp.aspx:InsertUserPlan() - " + ex.Message);
}
}
public Boolean ValidateAllowedMails()
{
try
{
objBL_Common = new BL_Common();
DataTable dtplantype = new DataTable();
string[] UPtype = new string[3];
dtplantype = objBL_Common.plantypedetails("b.*", "dbo.EC_UserLogin a inner join EC_UserPlan b on a.PK_UserID = b.FK_UserID", "a.FK_CompanyID =" + Convert.ToInt32(Session["CompanyID"].ToString()) + " and b.IsActive = 1");
Boolean validstatus = false;
if (dtplantype.Rows.Count > 0)
{
string mailcount = objBL_CampaignQueue.SelectMailCount(Convert.ToInt32(Session["CompanyID"].ToString()), Convert.ToDateTime(dtplantype.Rows[0]["ActiveFrom"].ToString()), Convert.ToDateTime(dtplantype.Rows[0]["ActiveTo"].ToString()));
//string mailcount = objBL_Common.IsValidUser("", "", "");
if (mailcount != "")
{
if (Session["lstUserPlanType"] != null)
{
UPtype = (string[])Session["lstUserPlanType"];
if (Session["SelectContactID"].ToString() != null)
{
int selectidcount = 0;
if (Session["SelectContactID"].ToString().Contains(","))
{
string[] arrcontactid = Session["SelectContactID"].ToString().Split(',');
selectidcount = arrcontactid.Length;
}
if (Convert.ToInt32(mailcount) + selectidcount >= Convert.ToInt32(UPtype[2]))
{
if (Convert.ToInt32(mailcount) < Convert.ToInt32(UPtype[2]))
ClientScript.RegisterStartupScript(Page.GetType(), "mykey66", "alert('Only " + Convert.ToInt32(Convert.ToInt32(UPtype[2]) - Convert.ToInt32(mailcount)) + " recepients are remaining from your plan to send mails!');", true);
else
ClientScript.RegisterStartupScript(Page.GetType(), "mykey26", "alert('You cannot send mails beyond your plan, Mail quota is completed!');", true);
validstatus = false;
}
else
validstatus = true;
}
}
}
}
return validstatus;
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CreateCampign.aspx:ValidateAllowedMails() - " + ex.Message);
return false;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Boolean AllowMail = ValidateAllowedMails();
if (AllowMail == false)
return;
string body = txta9.Value;
if (body != "")
{
objBL_Common.AccessUpdateAllCampaign("EC_Campaign", "mailcontent = '" + body + "'", "PK_CampaignID =" + Convert.ToInt32(Session["CampgnID"].ToString()) + "");
string destcc = "*****@*****.**";
string fromEmailID = System.Configuration.ConfigurationSettings.AppSettings["AryvartAdminEmailID"].ToString();
string fromPassword = System.Configuration.ConfigurationSettings.AppSettings["AryvartAdminEmailPassword"].ToString();
for (int i = 0; i < gvAddContacts.Rows.Count; i++)
{
string tomailid = gvAddContacts.Rows[i].Cells[5].Text.ToString();
int contactid = 0;
Label lblEmpID = (Label)gvAddContacts.Rows[i].Cells[0].FindControl("lblThirdPartyId");
if (gvAddContacts.Rows[i].Cells[0].Text.ToString() != null)
contactid = Convert.ToInt32(lblEmpID.Text.ToString());
string CQIID = CampaignQueueInsert(false, contactid);
int PKID = 0;
if (CQIID != null)
{
PKID = Convert.ToInt32(CQIID);
var deliveryProcessor = "http://*****:*****@"<img src=""{0}?msg_id={1}"" width=""0"" height=""0""
style=""width: 0px; height: 0px; border:0px;"" alt=""""/>",
deliveryProcessor, PKID);
body += imgTag;
}
objMailTemplate.fnSendMailToRecipients(fromEmailID, fromPassword, body, destcc, txtTitle.Value.ToString(), tomailid, EmailID.Value.ToString().Trim(), PKID);
objBL_Common.AccessUpdateAllCampaign("EC_CampaignQueue", "IsMailSent = " + 1 + ", SentOn = '" + DateTime.Now + "', UpdatedBy = " + Convert.ToInt64(Session["UserID"].ToString()) + ", UpdatedOn = '" + DateTime.Now + "'", "PK_CampaignQueueID =" + Convert.ToInt32(PKID) + "");
}
objBL_Common = new BL_Common();
objBL_Common.AccessUpdateAllCampaign("EC_Campaign", "CampaignStatus = " + 1 + ", SchduleDateTime='" + DateTime.Now + "'", "PK_CampaignID =" + Convert.ToInt32(Session["CampgnID"].ToString()) + "");
//ClientScript.RegisterStartupScript(Page.GetType(), "mykey32", "alert('Mail sent successfully to all the recepients.');", true);
Session["SelectContactID"] = null;
Session.Remove("SelectContactID");
Session["CampgnID"] = null;
Session.Remove("CampgnID");
Response.Redirect("MailSentSuccess.aspx", false);
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "mykey25", "alert('Enter your mail content text message to send a mail!');", true);
}
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CreateCampign.aspx:Button1_Click() - " + ex.Message);
}
}
protected void btngridsubmit_Click(object sender, EventArgs e)
{
Boolean AllowMail = ValidateAllowedMails();
if (AllowMail == false)
return;
string CampTimezone = ddlTimeZone.SelectedValue;
string dttime = dtScheduledatetime.Value;
string[] dateString = dttime.Split('/');
DateTime enter_date = Convert.ToDateTime
(dateString[1] + "/" + dateString[0] + "/" + dateString[2]);
DateTime indtime;
DateTime utcTime = enter_date.ToUniversalTime();
if (ddlTimeZone.SelectedIndex > 0)
{
indtime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(Convert.ToDateTime(enter_date.ToString()), ddlTimeZone.SelectedValue, TimeZoneInfo.Local.Id);
utcTime = new DateTime();
utcTime = indtime.ToUniversalTime();
objCampaign.Utctime = utcTime;
}
//else
// objCampaign.Utctime = utcTime;
//objCampaign.SchduleDateTime = enter_date;
string body = txta9.Value;
if (body != "" && gvAddContacts.Rows.Count > 0)
{
objBL_Common = new BL_Common();
objBL_Common.AccessUpdateAllCampaign("EC_Campaign", "Utctime = '" + utcTime + "', CampTimezone = '" + ddlTimeZone.SelectedValue + "', mailcontent = '" + body + "', CampaignStatus = " + 0 + ", SchduleDateTime = '" + enter_date + "' ", "PK_CampaignID =" + Convert.ToInt32(Session["CampgnID"].ToString()) + "");
for (int i = 0; i < gvAddContacts.Rows.Count; i++)
{
string tomailid = gvAddContacts.Rows[i].Cells[5].Text.ToString();
int contactid = 0;
Label lblEmpID = (Label)gvAddContacts.Rows[i].Cells[0].FindControl("lblThirdPartyId");
if (gvAddContacts.Rows[i].Cells[0].Text.ToString() != null)
contactid = Convert.ToInt32(lblEmpID.Text.ToString());
CampaignQueueInsert(false, contactid);
}
//objBL_Common = new BL_Common();
//objBL_Common.AccessUpdateAllCampaign("EC_Campaign", "CampaignStatus = " + 0 + "", "PK_CampaignID =" + Convert.ToInt32(Session["CampgnID"].ToString()) + "");
objBL_ScheduleMailDetails = new BL_ScheduleMailDetails();
objScheduleMailDetails = new ScheduleMailDetails();
Label lblEmpID1 = (Label)gvAddContacts.Rows[0].Cells[0].FindControl("lblThirdPartyId");
objScheduleMailDetails.FK_ContactID = Convert.ToInt32(lblEmpID1.Text.ToString());
objScheduleMailDetails.Scheduledatetime = utcTime;
objScheduleMailDetails.FK_Scheduleby = Convert.ToInt32(Session["UserID"].ToString());
objScheduleMailDetails.QueueStatus = false;
objScheduleMailDetails.CreatedBy = Convert.ToInt32(Session["UserID"].ToString());
objScheduleMailDetails.CreatedOn = DateTime.Now;
objScheduleMailDetails.FK_CampaignID = Convert.ToInt32(Session["CampgnID"].ToString());
objBL_ScheduleMailDetails.AccessInsertScheduleMailDetails(objScheduleMailDetails);
objScheduleMailDetails = null;
objBL_ScheduleMailDetails = null;
Session["SelectContactID"] = null;
Session.Remove("SelectContactID");
Session["CampgnID"] = null;
Session.Remove("CampgnID");
//ClientScript.RegisterStartupScript(Page.GetType(), "mykey26", "alert('Your schedule mail content text message or Choose Recipients to send a mail!');", true);
Response.Redirect("MailScheduleSuccess.aspx", false);
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "mykey25", "alert('Enter your mail content text message or Choose time zone and Recipients to send a mail!');", true);
}
}
protected void btndelete_Click(object sender, EventArgs e)
{
try
{
string selectid = string.Empty;
Boolean deletestatus = false;
for (int i = 0; i < gvcampaign.Rows.Count; i++)
{
if (gvcampaign.Rows[i].RowType == DataControlRowType.DataRow)
{
CheckBox chk = (CheckBox)gvcampaign.Rows[i].Cells[0].FindControl("CheckBox1");
Label lblEmpID = (Label)gvcampaign.Rows[i].Cells[0].FindControl("lblEmpID");
if (chk.Checked)
{
DataTable dtplantype = new DataTable();
if (selectid == "")
{
if (!selectid.Contains(lblEmpID.Text.ToString()))
{
selectid = lblEmpID.Text;
dtplantype = objBL_Common.plantypedetails("PK_CampaignID", "EC_Campaign", "FK_UserID in (" + lblEmpID.Text + ")");
if (dtplantype.Rows.Count > 0)
deletestatus = true;
else
{
objBL_Common = new BL_Common();
string emailid = "'" + gvcampaign.Rows[i].Cells[5].Text + "'";
objBL_Common.AccessDeletAlleCampaign("EC_InviteUser", "Emailid", emailid);
objBL_Common = new BL_Common();
objBL_Common.AccessDeletAlleCampaign("EC_UserLogin", "PK_UserID", lblEmpID.Text);
}
}
}
else
{
if (!selectid.Contains(lblEmpID.Text.ToString()))
{
selectid = selectid + "," + lblEmpID.Text;
dtplantype = objBL_Common.plantypedetails("PK_CampaignID", "EC_Campaign", "FK_UserID in (" + lblEmpID.Text + ")");
if (dtplantype.Rows.Count > 0)
deletestatus = true;
else
{
objBL_Common = new BL_Common();
string emailid = "'" + gvcampaign.Rows[i].Cells[5].Text + "'";
objBL_Common.AccessDeletAlleCampaign("EC_InviteUser", "Emailid", emailid);
objBL_Common = new BL_Common();
objBL_Common.AccessDeletAlleCampaign("EC_UserLogin", "PK_UserID", lblEmpID.Text);
}
}
}
}
}
}
if (selectid == "")
ClientScript.RegisterStartupScript(Page.GetType(), "mykey28", "alert('Select at least one record !');", true);
else
{
if (deletestatus == true)
ClientScript.RegisterStartupScript(Page.GetType(), "mykey29", "alert('You cannot delete these user, Since it is referred by campaign!');", true);
this.Bindrolegrid();
}
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("InviteUserList.aspx:btndelete_Click() - " + ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
HttpCookie myCookie = new HttpCookie("myCookie");
bool IsRemember = chkRememberme.Checked;
lstUserDetails = new List<UserDetails>();
lstUserDetails = objBL_UserLoginDetails.SelectUserDetailsforLogin(txtUsername.Value.ToString(), txtpassword.Value.ToString());
if (lstUserDetails.Count > 0)
{
if (lstUserDetails[0].AccountActivated == true)
{
if (IsRemember)
{
myCookie.Values.Add("username", txtUsername.Value);
myCookie.Values.Add("password", objCryptographicHashCode.EncryptPlainTextToCipherText(txtpassword.Value));
myCookie.Expires = DateTime.Now.AddDays(15);
Response.Cookies.Add(myCookie);
}
else
{
myCookie.Values.Add("username", string.Empty);
myCookie.Values.Add("password", string.Empty);
myCookie.Expires = DateTime.Now.AddMinutes(5);
Response.Cookies.Add(myCookie);
}
Session["UserID"] = lstUserDetails[0].PK_UserID;
Session["Usertype"] = lstUserDetails[0].UserType;
Session["CompanyID"] = lstUserDetails[0].FK_CompanyID;
if (lstUserDetails[0].FirstName == "" && lstUserDetails[0].LastName == "")
Session["UserName"] = lstUserDetails[0].UserName;
else
Session["UserName"] = lstUserDetails[0].FirstName + " " + lstUserDetails[0].LastName;
if (Session["CompanyID"].ToString() != "")
Session["CompanyName"] = objBL_Common.IsValidUser("Company_Name", "EC_Company", "PK_CompanyID =" + Convert.ToInt32(Session["CompanyID"].ToString()) + "");
else
Session["CompanyName"] = "-";
if (Convert.ToInt64(Session["Usertype"].ToString()) == 10)
{
Response.Redirect("UserPlanTypeDetails.aspx", false);
return;
}
if (lstUserDetails[0].FK_RoleID != null)
Session["RoleID"] = lstUserDetails[0].FK_RoleID;
if (lstUserDetails[0].UserType == 1)
{
if (lstUserDetails[0].FK_RoleID == null)
{
objRole = new Role();
objRole.RoleName = "Admin";
objRole.CampaignCreate = true;
objRole.FK_CompanyID = Convert.ToInt32(Session["CompanyID"].ToString());
objRole.MailSend = true;
objRole.CreateUser = true;
objRole.CampaignDelete = true;
objRole.ViewingReports = true;
objRole.TemplateView = true;
objRole.ListExports = true;
objRole.CreatedOn = DateTime.Now;
objRole.CreatedBy = Convert.ToInt32(Session["UserID"].ToString());
string pkcqid = objBL_Role.AccessInsertRole(objRole);
if (pkcqid != "")
{
Session["RoleID"] = Convert.ToInt32(pkcqid);
objBL_Common = new BL_Common();
objBL_Common.AccessUpdateAllCampaign("EC_UserLogin", "FK_RoleID = '" + Convert.ToInt32(pkcqid) + "'", "PK_UserID =" + Convert.ToInt32(Session["UserID"].ToString()) + "");
objBL_Common = null;
}
}
}
objBL_UserPlan = new BL_UserPlan();
lstUserPlan = new List<UserPlan>();
lstUserPlan = objBL_UserPlan.GetUserPlanBasedonCompanyID(Convert.ToInt32(Session["CompanyID"].ToString()));
if (lstUserPlan.Count <= 0)
{
InsertUserPlan(Convert.ToInt32(Session["UserID"].ToString()));
Response.Redirect("Dashboard.aspx", false);
}
else
{
Response.Redirect("Dashboard.aspx", false);
DataTable dtplantype = new DataTable();
objBL_Common = new BL_Common();
dtplantype = objBL_Common.plantypedetails("*", "EC_PlanType", "PK_PlanID = " + Convert.ToInt32(lstUserPlan[0].FK_PlanID.ToString()) + " and IsActive = 1 order by plandate desc");
string[] UPtype = new string[3];
UPtype[0] = Convert.ToString(dtplantype.Rows[0]["IsSingleUser"]);
UPtype[1] = Convert.ToString(dtplantype.Rows[0]["NOC"]);
UPtype[2] = Convert.ToString(dtplantype.Rows[0]["AllowedMails"]);
Session["lstUserPlanType"] = UPtype;
}
if (lstUserDetails[0].Email_id != null)
Session["AdminEmilid"] = lstUserDetails[0].Email_id;
if (lstUserDetails[0].FK_RoleID != 0)
roledetails();
}
else
lblerrormsg.Text = "<span style='color:#c85305;font-size:11.5px;'>You have to activate your account from mail sent. Then only you can access your account.</span>";
}
else
lblerrormsg.Text = "<span style='color:#c85305;font-size:11.5px;'>That account doesn't exist. Enter a different account detail or </span> <a href='FreeAccountSignUp.aspx' style='font-size:11.5px; color: #00acec;'>get a new account</a>";
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("UserLogin.aspx:btnSubmit_Click() - " + ex.Message);
}
}
public void ReadDataFromExcelToDB()
{
objBL_Common = new BL_Common();
string cs = ConfigurationManager.ConnectionStrings["MyConnString"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
try
{
string path = Server.MapPath("~/FileUploadExcel/" + FileUpload1.FileName.ToString());
string excelread = string.Empty;
//validation userplan (24-9-2015)
DataTable dtCountValidation = new DataTable();
dtCountValidation = objBL_Common.SelectColumnQuery("(select count(b.PK_ContactID) from dbo.EC_UserLogin a inner join dbo.EC_UserContacts b on a.PK_UserID = b.FK_UserID where a.FK_CompanyID = " + Convert.ToInt32(Session["CompanyID"].ToString()) + ") + (SELECT count(*)FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0; Database=" + path + "', 'SELECT * FROM [Sheet1$]')) as ccount");
int contactscount = 0;
string[] UPtype = new string[3];
if (dtCountValidation.Rows.Count > 0)
contactscount = Convert.ToInt32(dtCountValidation.Rows[0][0]);
if(Session["lstUserPlanType"] != null)
UPtype = (string[])Session["lstUserPlanType"];
if (contactscount < Convert.ToInt32(UPtype[1]))
{
SqlDataAdapter da = new SqlDataAdapter();
con.Open();
excelread = "INSERT INTO [dbo].[EC_UserContacts] (" + Mapcolumn() + ", FK_UserID, CreatedBy, CreatedOn) SELECT *, " + Convert.ToInt32(Session["UserID"].ToString()) + " as FK_UserID, " + Convert.ToInt32(Session["UserID"].ToString()) + " as CreatedBy, '" + DateTime.Now + "' as CreatedOn FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0; Database=" + path + "', 'SELECT * FROM [Sheet1$]');";
//excelread = "INSERT INTO [dbo].[EC_UserContacts] ([ContactName], [email_id], [ContactNo], [Designation], Addressline1, City1, State1, Country1, DateofBirth, CreatedBy, CreatedOn) SELECT *, " + Convert.ToInt32(Session["UserID"].ToString()) + " as FK_UserID, " + Convert.ToInt32(Session["UserID"].ToString()) + " as CreatedBy, '" + DateTime.Today + "' as CreatedOn FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0; Database=" + path + "', 'SELECT * FROM [Sheet1$]');";
da.SelectCommand = new SqlCommand(excelread, con);
//da.SelectCommand = new SqlCommand("select * from Addresses_Temp1",con);
DataTable dt = new DataTable();
//dt.Columns.Add("S No", typeof(int));
//dt.Columns.Add("Name", typeof(string));
//dt.Columns.Add("Email", typeof(string));
da.Fill(dt);
con.Close();
}
else
{
Label1.Text = "You cannot add more recipients beyond your plan, Totaly you can have " + Convert.ToInt32(UPtype[1]) + " Contacts !";
Label1.CssClass = "alert alert-danger";
if(File.Exists(path))
File.Delete(path);
return;
}
excelread = string.Empty;
//dg.DataSource = dt;
objBL_UserContacts.DeleteDuplicateMailid(Convert.ToInt32(Session["Listid"].ToString()), Convert.ToInt32(Session["UserID"].ToString()));
Label1.Text = "Your contacts are now successfully imported.";
Label1.CssClass = "alert alert-success";
}
catch (Exception ex)
{
if (ex.ToString().Contains("The select list for the INSERT statement contains more items than the insert list"))
{
Label1.Text = "The select list for the INSERT statement contains more items than the insert list.";
Label1.CssClass = "alert alert-danger";
}
else if (ex.ToString().Contains("Cannot insert the value NULL into column 'email_id'"))
{
Label1.Text = "No data found for emailid. It is a mandatory one.";
Label1.CssClass = "alert alert-danger";
}
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("ImportReciepientsList.aspx:ReadDataFromExcelToDB() - " + ex.Message);
}
finally
{
con.Close();
}
}