public ActionResult _Destroy([DataSourceRequest]DataSourceRequest request, TB_PromotionExt model)
{
string Msg = "";
try
{
TB_PromotionRepository modelRepo = new TB_PromotionRepository();
if (modelRepo.Delete(model, ref Msg, this) == false)
{
return this.Json(new DataSourceResult { Errors = Msg });
}
}
catch (Exception ex)
{
string hostName1 = Dns.GetHostName();
string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString();
string PageName = Convert.ToString(Session["PageName"]);
//string GetUserIPAddress = GetUserIPAddress1();
using (BaseRepository baseRepo = new BaseRepository())
{
//BizContext BizContext1 = new BizContext();
BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress);
}
Session["PageName"] = "";
string error = ErrorHandling.HandleException(ex);
return this.Json(new DataSourceResult { Errors = error });
}
return Json(request);
}
public bool Update(TB_PromotionExt model, ref string Msg, Controller ctrl)
{
bool status = true;
using (DBEntities DE = new DBEntities())
{
var DepObj = DE.TB_Promotion.Where(x => x.ID == model.ID).FirstOrDefault();
DepObj.PartID = model.PartID;
switch (CultureCode)
{
case "en": //ID from BizTbl_Table for this Table
DepObj.Name_en = model.Name;
DepObj.Description_en = model.Description;
break;
case "tr":
DepObj.Name_tr = model.Name;
DepObj.Description_tr = model.Description;
break;
case "de":
DepObj.Name_de = model.Name;
DepObj.Description_de = model.Description;
break;
case "es":
DepObj.Name_es = model.Name;
DepObj.Description_es = model.Description;
break;
case "fr":
DepObj.Name_fr = model.Name;
DepObj.Description_fr = model.Description;
break;
case "ru":
DepObj.Name_ru = model.Name;
DepObj.Description_ru = model.Description;
break;
case "it":
DepObj.Name_it = model.Name;
DepObj.Description_it = model.Description;
break;
case "ar":
DepObj.Name_ar = model.Name;
DepObj.Description_ar = model.Description;
break;
case "ja":
DepObj.Name_ja = model.Name;
DepObj.Description_ja = model.Description;
break;
case "pt":
DepObj.Name_pt = model.Name;
DepObj.Description_pt = model.Description;
break;
case "zh":
DepObj.Name_zh = model.Name;
DepObj.Description_zh = model.Description;
break;
default:
break;
}
DepObj.Type = model.Type;
DepObj.GeneralPromotion = model.GeneralPromotion;
DepObj.StartDate = model.StartDate;
DepObj.TargetStartDate = model.TargetStartDate;
DepObj.TargetEndDate = model.TargetEndDate;
DepObj.Count = model.Count;
DepObj.DiscountPercentage = model.DiscountPercentage;
DepObj.RegionID = model.RegionID;
DepObj.Sort = Convert.ToInt16(model.Sorts);
DepObj.Active = model.Active;
DepObj.OpDateTime = DateTime.Now;
DepObj.OpUserID = 0;
DE.SaveChanges();
}
return status;
}
public List<TB_PromotionExt> GetAllTypeFirmRequest(int TableID)
{
List<TB_PromotionExt> list = new List<TB_PromotionExt>();
DataTable dt = new DataTable();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("B_DisplayTableNew_BizTbl_Table_Sp", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TableID", TableID);
cmd.Parameters.AddWithValue("@CultureCode", CultureCode);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
SQLCon.Close();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TB_PromotionExt model = new TB_PromotionExt();
model.ID = Convert.ToInt32(dr["ID"]);
model.PartID = Convert.ToInt32(dr["PartID"]);
model.PartName = dr["FK_PartID_ID"].ToString();
model.Name = dr["Name"].ToString();
model.Type = dr["Type"].ToString();
model.Description = dr["Description"].ToString();
if (dr["GeneralPromotion"].ToString() != "")
{
model.GeneralPromotion = Convert.ToBoolean(dr["GeneralPromotion"]);
}
else
{
model.GeneralPromotion =false;
}
if (dr["StartDate"].ToString() != "")
{
model.StartDate = Convert.ToDateTime(dr["StartDate"]);
}
else
{
model.StartDate = null;
}
if (dr["EndDate"].ToString() != "")
{
model.EndDate = Convert.ToDateTime(dr["EndDate"]);
}
else
{
model.EndDate = null;
}
if (dr["TargetStartDate"].ToString() != "")
{
model.TargetStartDate = Convert.ToDateTime(dr["TargetStartDate"]);
}
else
{
model.TargetStartDate = null;
}
if (dr["TargetEndDate"].ToString() != "")
{
model.TargetEndDate = Convert.ToDateTime(dr["TargetEndDate"]);
}
else
{
model.TargetEndDate = null;
}
if (dr["Count"].ToString() != "")
{
model.Count = Convert.ToInt32(dr["Count"]);
}
else
{
model.Count = null;
}
if (dr["DiscountPercentage"].ToString() != "")
{
model.DiscountPercentage = Convert.ToInt32(dr["DiscountPercentage"]);
}
else
{
model.DiscountPercentage = null;
}
if (dr["RegionID"].ToString() != "")
{
model.RegionID = Convert.ToInt64(dr["RegionID"]);
}
else
{
model.RegionID = null;
}
//model.StartDate = Convert.ToDateTime(dr["StartDate"]);
//model.EndDate = Convert.ToDateTime(dr["EndDate"]);
//model.TargetStartDate = Convert.ToDateTime(dr["TargetStartDate"]);
//model.TargetEndDate = Convert.ToDateTime(dr["TargetEndDate"]);
//model.Count = Convert.ToInt32(dr["Count"]);
//model.DiscountPercentage = Convert.ToInt32(dr["DiscountPercentage"]);
//model.RegionID = Convert.ToInt64(dr["RegionID"]);
model.Region = dr["FK_RegionID_ID"].ToString();
model.Sorts = dr["Sort"].ToString();
model.Active = Convert.ToBoolean(dr["Active"]);
list.Add(model);
}
}
return list;
}
public bool Delete(TB_PromotionExt model, ref string Msg, Controller ctrl)
{
bool status = true;
using (DBEntities DE = new DBEntities())
{
var DepObj = DE.TB_Promotion.Where(x => x.ID == model.ID).FirstOrDefault();
DE.TB_Promotion.Remove(DepObj);
DE.SaveChanges();
}
return status;
}