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