public ActionResult Delete(string domain)
{
if (ModelState.IsValid)
{
var blackListDomain = new eBlackListedDomainM();
if (!string.IsNullOrEmpty(domain))
{
//company.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
blackListDomain.iActionBy = 11;
blackListDomain.sDomainName = domain;
}
var result = BL_BlackListedDomainM.DeleteBlackListDomain(blackListDomain);
if (result.Key == -1)
{
return(Json(new { status = false, Msg = result.Value }, JsonRequestBehavior.AllowGet));
}
else if (result.Key == 1)
{
return(Json(new { status = true, Msg = result.Value }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false, Msg = "An error occured while deleting the record, Kindly try after some time." }, JsonRequestBehavior.AllowGet));
}
public static KeyValuePair <int, string> DeleteBlackListDomain(eBlackListedDomainM domain)
{
try
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
SqlParameter[] MyParam = new SqlParameter[1];
MyParam[0] = new SqlParameter("@sDomainName", domain.sDomainName);
var dataSet = SqlHelper.ExecuteDataset(db.Database.Connection.ConnectionString, CommandType.StoredProcedure, "uspDeleteBlackListDomain", MyParam);
int statusId = -1;
string message = string.Empty;
if (dataSet != null && dataSet.Tables[0] != null)
{
statusId = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]);
message = Convert.ToString(dataSet.Tables[0].Rows[0][1]);
}
return(new KeyValuePair <int, string>(statusId, message));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static eBlackListedDomainM GetBlacklistedDomain(string domainName)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
var m = db.tblBlackListedDomains.Where(x => x.sDomainName == domainName).FirstOrDefault();
var blackListModel = new eBlackListedDomainM();
blackListModel.sDomainName = m.sDomainName;
blackListModel.cStatus = m.cStatus;
blackListModel.dtActionDate = m.dtActionDate;
blackListModel.iActionBy = m.iActionBy;
return(blackListModel);
}
}
public ActionResult AddUpdateBlackListDomain(eBlackListedDomainM domain)
{
if (ModelState.IsValid)
{
domain.sActionType = "A";
domain.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
//domain.iActionBy = 11;
var result = BL_BlackListedDomainM.AddEditBlacklistDomain(domain);
if (result.Key == -1)
{
return(Json(new { status = false, Msg = result.Value }, JsonRequestBehavior.AllowGet));
}
else if (result.Key == 1)
{
return(Json(new { status = true, Msg = result.Value }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false, Msg = "An error occured while adding the record, Kindly try after some time." }, JsonRequestBehavior.AllowGet));
}
