public EmailDNS getDNSEmailProduct(int custEmailProductId) { SqlCommand dinsert = new SqlCommand("usp_GetEmailDNSMangement"); dinsert.Parameters.AddWithValue("@CustEmailProductId", SqlDbType.Int).Value = custEmailProductId; DataSet DsList = objcon.GetDsByCommand(dinsert); EmailDNS List = new EmailDNS(); if (DsList.Tables[0].Rows.Count > 0) { List.CustId = Convert.ToString(DsList.Tables[0].Rows[0]["CustId"]); List.CustName = Convert.ToString(DsList.Tables[0].Rows[0]["CustName"]); List.EmailId = (DsList.Tables[0].Rows[0]["Email"].ToString()); List.MobileNo = (DsList.Tables[0].Rows[0]["MobileNo"].ToString()); List.Address = DsList.Tables[0].Rows[0]["Address"].ToString(); List.Country = DsList.Tables[0].Rows[0]["Country"].ToString(); List.State = DsList.Tables[0].Rows[0]["StateId"].ToString(); List.City = DsList.Tables[0].Rows[0]["City"].ToString(); List.PostalCode = DsList.Tables[0].Rows[0]["PostedCode"].ToString(); List.ProductCode = DsList.Tables[0].Rows[0]["ProductCode"].ToString(); List.SACCode = DsList.Tables[0].Rows[0]["SACCode"].ToString(); List.DomainName = DsList.Tables[0].Rows[0]["ProductName"].ToString(); List.creatationdate = Convert.ToString(DsList.Tables[0].Rows[0]["EmailCreationDate"]); List.Expirationdate = Convert.ToString(DsList.Tables[0].Rows[0]["EmailExpirationDate"]); List.Deletiondate = Convert.ToString(DsList.Tables[0].Rows[0]["EmailDeletionDate"]); List.Subscription = Convert.ToString(DsList.Tables[0].Rows[0]["Description"]); List.Registrationprise = Convert.ToString(DsList.Tables[0].Rows[0]["RegistrationPrice"]); List.Renewalprise = Convert.ToString(DsList.Tables[0].Rows[0]["RenewalPrice"]); List.Domain = Convert.ToString(DsList.Tables[0].Rows[0]["EmailDomain"]); List.DomainEmailId = Convert.ToString(DsList.Tables[0].Rows[0]["DomainEmail"]); List.CustEmailProductId = Convert.ToString(DsList.Tables[0].Rows[0]["CustEmailId"]); } return(List); }
public ActionResult SetDNSEmail(EmailDNS DNS, FormCollection fc) { bool res = objPartnerBAL.setDNSEmailMangDtl(DNS); // return View(); return(RedirectToAction("EditEmail", "CPC", new { CustDomainProductId = DNS.CustEmailProductId })); }
public List <EmailDNS> _partialgetEmailDNS(int custEmailProductId) { SqlCommand dinsert = new SqlCommand("usp_GetEmailDNSManagment"); dinsert.Parameters.AddWithValue("@CustEmailProductId", SqlDbType.Int).Value = custEmailProductId; DataSet dtList = objcon.GetDsByCommand(dinsert); List <EmailDNS> list1 = new List <EmailDNS>(); foreach (DataRow dr in dtList.Tables[0].Rows) { EmailDNS pd = new EmailDNS(); pd.EmailDNSId = (dr["EmailDNSId"].ToString()); pd.DomainEmailId = dr["EmailId"].ToString(); pd.Domain = dr["Domain"].ToString(); list1.Add(pd); } return(list1); }
public bool SetDNSEmailMangDtl(EmailDNS dNS) { SqlCommand dinsert1 = new SqlCommand("usp_SetEmailDNS"); dinsert1.Parameters.AddWithValue("@CustEmailId", SqlDbType.Int).Value = dNS.CustEmailProductId; if (!string.IsNullOrWhiteSpace(dNS.DomainEmailId)) { dinsert1.Parameters.AddWithValue("@EmailId", SqlDbType.NVarChar).Value = dNS.DomainEmailId; } if (!string.IsNullOrWhiteSpace(dNS.Domain)) { dinsert1.Parameters.AddWithValue("@Domain", SqlDbType.NVarChar).Value = dNS.Domain; } bool Result1 = objcon.InsrtUpdtDlt(dinsert1); return(Result1); }
public bool setDNSEmailMangDtl(EmailDNS dNS) { return(dsh.SetDNSEmailMangDtl(dNS)); }