public void CompanyInsert(Company objCompany) { try { objEmailCampDataContext = new EmailCampDataContext(); var Insert = (from cde in objEmailCampDataContext.spCompany_AllActions(objCompany.PK_CompanyID ,objCompany.Company_Name ,objCompany.Email_id ,objCompany.ContactNo ,objCompany.Addressline1 ,objCompany.City1 ,objCompany.State1 ,objCompany.Country1 ,objCompany.CreatedBy ,objCompany.CreatedOn ,objCompany.UpdatedBy ,objCompany.UpdatedOn, "i") select cde).ToList(); Insert = null; objCompany = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
public void CompanyDelete(int Companyid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spCompany_AllActions(Companyid, null, null, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objCompany = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
public void AccessUpdateCompany(Company objCompany1) { objDL_CompanyDetails.CompanyUpdate(objCompany1); }
public void AccessInsertCompany(Company objCompany1) { objDL_CompanyDetails.CompanyInsert(objCompany1); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { int status = objBL_UserLoginDetails.AccessVerifyUserEmailidExist(txtEmail.Value.ToString().Trim()); if (status == 0) { objCompany = new Company(); objCompany.Email_id = txtEmail.Value.ToString().Trim(); objCompany.Company_Name = txtCompanyName.Value.ToString().Trim(); objCompany.ContactNo = txtContactNumber.Value.ToString().Trim(); objCompany.CreatedOn = DateTime.Now; objBL_CompanyDetails.AccessInsertCompany(objCompany); objUserDetails = new UserDetails(); int CompanyID = Convert.ToInt32(objBL_CompanyDetails.ReturnCompanyMaxID()); if (objUserDetails.FK_CompanyID != 0) objUserDetails.FK_CompanyID = CompanyID; objUserDetails.UserName = txtUserName.Value.ToString().Trim(); objUserDetails.UserPassword = txtPassword.Value.ToString().Trim(); objUserDetails.Email_id = txtEmail.Value.ToString().Trim(); objUserDetails.ContactNo = txtContactNumber.Value.ToString().Trim(); objUserDetails.IsActive = true; objUserDetails.CreatedOn = DateTime.Now; objUserDetails.MemberSince = DateTime.Now; objUserDetails.AccountActivated = false; if (chkNewsLetter.Checked) objUserDetails.SendNewsLetter = true; else objUserDetails.SendNewsLetter = false; objUserDetails.UserType = 1; objBL_UserLoginDetails.AccessInsertUserLogin(objUserDetails); int loginid = objBL_UserLoginDetails.ReturnUserLoginMaxID(); //------Sending confirmtion Email of account created to client.----- string sEmailId = "*****@*****.**"; //subject string sSubject = "Aryvart Email Campaign: Please verify your email address."; ////sending emails to client string strReceiverName = "ADMIN"; string EncryptQry = "id=" + objCryptographicHashCode.EncryptPlainTextToCipherText(loginid.ToString()) + "'"; //string EncryptQry = "id=" + objBL_UserLoginDetails.ReturnUserLoginMaxID().ToString() + "'"; //string strDetails = "<table border='1' cellspacing='0' cellpadding='0'><tr><td width='152' valign='middle'><span style='font-size:14px;color:#aa483c'> File Name:</span></td><td width='200' valign='middle'><span style='font-size:14px;color:#aa483c'> " + sFileName + ".</span></td></tr><tr><td width='152' valign='middle'><span style='font-size:14px;color:#aa483c'> Uploaded on:</span></td><td width='200' valign='middle'><span style='font-size:14px;color:#aa483c'> " + DateTime.Now.ToString() + "." + "</span></td></tr></table>"; //string body = MailTemplate.MailCoUpldHTML(MailTemplate.GetEmailTemplate("CoUpldEmail.html").Replace("<CompanyName>", sCompanyName).Replace("<Details>", strDetails).Replace("<ReceiverName>", strReceiverName).Replace("<ClientName>", sClientName)); //objMailTemplate.fnSendMailToClientForCoUpld(body, "*****@*****.**", sSubject, sEmailId); string body = MailTemplate.MailAccountActivate(EncryptQry); objMailTemplate.fnSendMailToClientForCoUpld(body, txtEmail.Value.ToString().Trim(), sSubject, sEmailId); //---------End--------------------- ClientScript.RegisterStartupScript(Page.GetType(), "mykey1", "Clearuserinput1();", true); } else if (status == 1) { lblerrormsg.Text = "<span style='color:#c85305;font-size:12px;'>Emailid already exist use some other emailid or </span> <a href='UserLogin.aspx' style='font-size:12px; color: #00acec;'>Log in using your credential</a>."; } } catch (Exception ex) { New_EmailCampaign.App_Code.GlobalFunction.StoreLog("FreeAccountSignUp.aspx:btnSubmit_Click() - " + ex.Message); } }
public List<Company> CompanySelectbasedonid(int id) { objEmailCampDataContext = new EmailCampDataContext(); lstCompany = new List<Company>(); var Select = (from cde in objEmailCampDataContext.spCompany_AllActions(id, null, null, null, null, null, null, null, null, null, null, null, "s") select cde).ToList(); if (Select.Count > 0) { lstCompany = new List<Company>(); foreach (var item in Select) { objCompany = new Company(); objCompany.Addressline1 = Convert.ToString(item.addressline1); objCompany.City1 = Convert.ToString(item.city1); objCompany.CreatedBy = Convert.ToInt16(item.CreatedBy); objCompany.CreatedOn = Convert.ToDateTime(item.CreatedOn); objCompany.UpdatedBy = Convert.ToInt16(item.UpdatedBy); objCompany.UpdatedOn = Convert.ToDateTime(item.UpdatedOn); objCompany.Company_Name = item.Company_Name; objCompany.ContactNo = item.ContactNo; objCompany.Country1 = item.country1; objCompany.PK_CompanyID = item.PK_CompanyID; objCompany.Email_id = item.email_id; objCompany.State1 = item.state1; lstCompany.Add(objCompany); } } objEmailCampDataContext = null; objCompany = null; return lstCompany; }