// GET: TradePromotion/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblt_TradePromotion tbltTradePromotion = Db.tblt_TradePromotion.Find(id);
if (tbltTradePromotion != null)
{
List <int> dbId = Db.tblt_TradePromotionDBhouseMapping.Where(x => x.promo_id == id).Select(x => x.db_id).ToList();
TradePromotioninfoVm tradePromotioninfoVm = new TradePromotioninfoVm
{
Name = tbltTradePromotion.name,
Code = tbltTradePromotion.code,
Description = tbltTradePromotion.code,
CreateDate = tbltTradePromotion.create_date,
StartDate = tbltTradePromotion.start_date,
EndDate = tbltTradePromotion.end_date,
IsActive = tbltTradePromotion.is_active,
ConditionType = Db.tblt_TradePromotionConditionType.Where(y => y.id == Db.tblt_TradePromotionDefinition.Where(x => x.promo_id == id && x.promo_line_type != 2).Select(x => x.condition_type).FirstOrDefault()).Select(y => y.ConditionType).FirstOrDefault(),
RuleType = Db.tblt_TradePromotionType.Where(y => y.promo_type_id == Db.tblt_TradePromotionDefinition.Where(x => x.promo_id == id && x.promo_line_type != 2).Select(x => x.rule_type).FirstOrDefault()).Select(y => y.promo_type_name).FirstOrDefault(),
OfferType = Db.tblt_TradePromotionOfferType.Where(y => y.id == Db.tblt_TradePromotionDefinition.Where(x => x.promo_id == id && x.promo_line_type != 2).Select(x => x.offer_type).FirstOrDefault()).Select(y => y.offertype).FirstOrDefault(),
Orderskulist = Db.tblt_TradePromotionDefinition.Where(x => x.promo_id == id && x.promo_line_type != 2).Select(x => new TpOrderskuDetailslistVm {
Sku = Db.tbld_SKU.FirstOrDefault(y => y.SKU_id == x.condition_sku_id).SKUName, BetchId = x.condition_sku_Batch, PackSize = x.condition_sku_pack_size, Qty = x.condition_sku_amount, SlabCsQty = x.condition_bundle_qty_CS
}).ToList(),
Freeskulist = Db.tblt_TradePromotionDefinition.Where(x => x.promo_id == id && x.promo_line_type == 2).Select(x => new TpOrderskuDetailslistVm {
Sku = Db.tbld_SKU.FirstOrDefault(y => y.SKU_id == x.offer_sku_id).SKUName, BetchId = x.offer_sku_Batch, PackSize = x.offer_sku_pack_size, Qty = x.offer_sku_amount
}).ToList()
};
var dbList = from a in Db.tbld_db_zone_view
where a.Status == 1 && dbId.Contains(a.DB_Id)
orderby a.REGION_id, a.AREA_id, a.CEAREA_id, a.DB_Id
select(new { a.DB_Id, DBName = "[" + a.REGION_Name + "][" + a.AREA_Name + "] [" + a.CEAREA_Name + "][" + a.DB_Name + "]" });
ViewBag.DB = new SelectList(dbList.ToList(), "DB_Id", "DBName");
var cluster = (from a in Db.tbld_distribution_house
join b in Db.tbld_cluster on a.Cluster_id equals b.id
where dbId.Contains(a.DB_Id)
select b).Distinct();
ViewBag.Cluster = new SelectList(cluster.ToList(), "id", "name");
return(View(tradePromotioninfoVm));
}
return(null);
}
public ActionResult StatusChange(int?id)
{
tblt_TradePromotion tbltTradePromotion = Db.tblt_TradePromotion.SingleOrDefault(x => x.id == id);
if (tbltTradePromotion != null)
{
tbltTradePromotion.is_active = tbltTradePromotion.is_active == 1 ? 2 : 1;
Db.Entry(tbltTradePromotion).State = EntityState.Modified;
Db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult ExtendTradePromotion(int tpid, DateTime extenddate)
{
tblt_TradePromotion tbltTradePromotion = Db.tblt_TradePromotion.SingleOrDefault(x => x.id == tpid);
if (tbltTradePromotion != null)
{
tbltTradePromotion.end_date = extenddate;
tbltTradePromotion.expiry_date = extenddate;
Db.Entry(tbltTradePromotion).State = EntityState.Modified;
Db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult SaveTradePromotation(TradePromotionCreateVm tradePromotionCreateVm)
{
tblt_TradePromotion tbltTradePromotion = new tblt_TradePromotion
{
name = sp.Remove_Special_Characters(tradePromotionCreateVm.Name),
code = tradePromotionCreateVm.Code,
description = sp.Remove_Special_Characters(tradePromotionCreateVm.Description),
TP_type = 1,
TPOffer_type = 1,
promotion_unit_id = 1,
promotion_sub_unit_id = 1,
start_date = tradePromotionCreateVm.StartDate,
end_date = tradePromotionCreateVm.EndDate,
expiry_date = tradePromotionCreateVm.EndDate,
create_date = DateTime.Now,
is_active = 1
};
Db.tblt_TradePromotion.Add(tbltTradePromotion);
Db.SaveChanges();
int tpId = tbltTradePromotion.id;
if (tradePromotionCreateVm.OfferType == 1)
{
foreach (var orderskulistitem in tradePromotionCreateVm.Orderskulist)
{
tblt_TradePromotionDefinition tbltTradePromotionOrderDefinition = new tblt_TradePromotionDefinition
{
promo_id = tpId,
rule_type = tradePromotionCreateVm.RuleType,
promo_line_type = 1,
condition_type = tradePromotionCreateVm.ConditionType,
offer_type = tradePromotionCreateVm.OfferType,
condition_sku_id = orderskulistitem.SkuId,
condition_sku_Batch = orderskulistitem.BetchId,
condition_sku_pack_size = orderskulistitem.PackSize,
condition_sku_amount = orderskulistitem.Qty,
offer_sku_id = 0,
offer_sku_pack_size = 0,
offer_sku_Batch = 0,
offer_sku_amount = 0,
condition_bundle_qty_CS = orderskulistitem.SlabCsQty,
condition_sku_group = 1
};
Db.tblt_TradePromotionDefinition.Add(tbltTradePromotionOrderDefinition);
}
foreach (var freeskulistitem in tradePromotionCreateVm.Freeskulist)
{
tblt_TradePromotionDefinition tbltTradePromotionfreeDefinition = new tblt_TradePromotionDefinition
{
promo_id = tpId,
rule_type = 1,
promo_line_type = 2,
condition_type = 1,
offer_type = tradePromotionCreateVm.OfferType,
condition_sku_id = 0,
condition_sku_Batch = 0,
condition_sku_pack_size = 0,
condition_sku_amount = 0,
offer_sku_id = freeskulistitem.SkuId,
offer_sku_pack_size = freeskulistitem.PackSize,
offer_sku_Batch = freeskulistitem.BetchId,
offer_sku_amount = freeskulistitem.Qty,
condition_bundle_qty_CS = freeskulistitem.SlabCsQty,
condition_sku_group = 1
};
Db.tblt_TradePromotionDefinition.Add(tbltTradePromotionfreeDefinition);
}
}
else
{
foreach (var orderskulistitem in tradePromotionCreateVm.Orderskulist)
{
tblt_TradePromotionDefinition tbltTradePromotionOrderDefinition = new tblt_TradePromotionDefinition
{
promo_id = tpId,
rule_type = 1,
promo_line_type = 3,
condition_type = 1,
offer_type = 2,
condition_sku_id = orderskulistitem.SkuId,
condition_sku_Batch = orderskulistitem.BetchId,
condition_sku_pack_size = orderskulistitem.PackSize,
condition_sku_amount = orderskulistitem.Qty,
offer_sku_id = 0,
offer_sku_pack_size = 0,
offer_sku_Batch = 0,
offer_sku_amount = tradePromotionCreateVm.ValueDiscount,
condition_bundle_qty_CS = 0,
condition_sku_group = 1
};
Db.tblt_TradePromotionDefinition.Add(tbltTradePromotionOrderDefinition);
}
}
HashSet <int> dbids = sp.Alldbids(tradePromotionCreateVm.RsmId, tradePromotionCreateVm.AsmId,
tradePromotionCreateVm.CeId, tradePromotionCreateVm.DbId);
var dbidList = Db.tbld_distribution_house.Where(
x => dbids.Contains(x.DB_Id) && tradePromotionCreateVm.ClusterList.Contains(x.Cluster_id));
foreach (var dbid in dbidList)
{
tblt_TradePromotionDBhouseMapping tbltTradePromotionDBhouseMapping =
new tblt_TradePromotionDBhouseMapping
{
promo_id = tpId,
db_id = dbid.DB_Id,
status = 1
};
Db.tblt_TradePromotionDBhouseMapping.Add(tbltTradePromotionDBhouseMapping);
}
Db.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
