public HttpResponseMessage DeleteRequisitionDetails(promotion_details promotionDetails)
{
try
{
var reqMaster = promotionRepository.DeletePromotionDetails(promotionDetails.promotion_details_id, promotionDetails.promotion_master_id);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Delete Successfully."
}, formatter));
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public long EditPromotion(PromotionModel promotionModel)
{
try
{
var promotionMaster = promotionModel.PromotionMasterData;
var promotionDetailsList = promotionModel.PromotionDetailsList;
var promotionChannelMappingList = promotionModel.PromotionChannelMappingList;
var promotionMasterId = promotionMaster.promotion_master_id;
// UPDATE PROMOTION MASTER DATA
var promotionMasterOld = _entities.promotion_master.Find(promotionMasterId);
promotionMasterOld.promotion_name = promotionModel.PromotionMasterData.promotion_name;
promotionMasterOld.promotion_start_date = promotionModel.PromotionMasterData.promotion_start_date;
promotionMasterOld.promotion_end_date = promotionModel.PromotionMasterData.promotion_end_date;
promotionMasterOld.product_category_id = promotionModel.PromotionMasterData.product_category_id;
promotionMasterOld.product_id = promotionModel.PromotionMasterData.product_id;
promotionMasterOld.lifting_quantity_for_promotion = promotionModel.PromotionMasterData.lifting_quantity_for_promotion;
promotionMasterOld.promotion_discount = promotionModel.PromotionMasterData.promotion_discount;
promotionMasterOld.is_discount_percent = promotionModel.PromotionMasterData.is_discount_percent;
promotionMasterOld.remarks = promotionModel.PromotionMasterData.remarks;
promotionMasterOld.is_active = promotionModel.PromotionMasterData.is_active;
promotionMasterOld.updated_by = promotionModel.PromotionMasterData.updated_by;
promotionMasterOld.updated_date = DateTime.Now;
_entities.SaveChanges();
//UPDATE PROMOTION DETAILS DATA
if (promotionDetailsList != null && promotionDetailsList.Count > 0)
{
foreach (var item in promotionDetailsList)
{
var promotionDetailsOld = _entities.promotion_details
.FirstOrDefault(pd => pd.promotion_master_id == promotionMasterId && pd.promotion_details_id == item.promotion_details_id);
if (promotionDetailsOld != null)
{
promotionDetailsOld.product_id = item.product_id;
promotionDetailsOld.product_category_id = item.product_category_id;
promotionDetailsOld.gift_quantity = item.gift_quantity;
_entities.SaveChanges();
}
else
{
var promotionDetails = new promotion_details
{
promotion_master_id = promotionMasterId,
product_id = item.product_id,
product_category_id = item.product_category_id,
gift_quantity = item.gift_quantity
};
_entities.promotion_details.Add(promotionDetails);
_entities.SaveChanges();
}
}
}
if (promotionChannelMappingList.Count > 0)
{
foreach (var item in promotionChannelMappingList)
{
var promotionChannelOld = _entities.promotion_channel_mapping.Find(item.promotion_channel_mapping_id);
if (promotionChannelOld != null)
{
promotionChannelOld.is_active = item.is_active;
_entities.SaveChanges();
}
else
{
var promotionChannelMapping = new promotion_channel_mapping
{
promotion_master_id = promotionMasterId,
channel_id = item.channel_id,
is_active = item.is_active
};
_entities.promotion_channel_mapping.Add(promotionChannelMapping);
_entities.SaveChanges();
}
}
}
return(1);
}
catch (Exception)
{
return(0);
}
}
public long AddPromotion(PromotionModel promotionModel)
{
try
{
var promotionMaster = promotionModel.PromotionMasterData;
var promotionDetailsList = promotionModel.PromotionDetailsList;
var promotionChannelMappingList = promotionModel.PromotionChannelMappingList;
long promotionSerial = _entities.promotion_master.Max(po => (long?)po.promotion_master_id) ?? 0;
promotionSerial++;
var promotionStr = promotionSerial.ToString().PadLeft(7, '0');
string promotionNo = "PROMO-" + promotionStr;
promotionMaster.promotion_code = promotionNo;
promotionMaster.promotion_name = promotionModel.PromotionMasterData.promotion_name;
promotionMaster.promotion_start_date = promotionModel.PromotionMasterData.promotion_start_date;
promotionMaster.promotion_end_date = promotionModel.PromotionMasterData.promotion_end_date;
promotionMaster.product_category_id = promotionModel.PromotionMasterData.product_category_id;
promotionMaster.product_id = promotionModel.PromotionMasterData.product_id;
promotionMaster.lifting_quantity_for_promotion = promotionModel.PromotionMasterData.lifting_quantity_for_promotion;
promotionMaster.promotion_type = promotionModel.PromotionMasterData.promotion_type;
promotionMaster.promotion_discount = promotionModel.PromotionMasterData.promotion_discount;
promotionMaster.is_discount_percent = promotionModel.PromotionMasterData.is_discount_percent;
promotionMaster.remarks = promotionModel.PromotionMasterData.remarks;
promotionMaster.is_active = promotionModel.PromotionMasterData.is_active;
promotionMaster.created_by = promotionModel.PromotionMasterData.created_by;
promotionMaster.created_date = DateTime.Now;
promotionMaster.updated_by = promotionModel.PromotionMasterData.updated_by;
promotionMaster.updated_date = DateTime.Now;
_entities.promotion_master.Add(promotionMaster);
_entities.SaveChanges();
long promotionMasterId = promotionMaster.promotion_master_id;
if (promotionDetailsList.Count > 0)
{
foreach (var item in promotionDetailsList)
{
var promotionDetails = new promotion_details
{
promotion_master_id = promotionMasterId,
product_id = item.product_id,
product_category_id = item.product_category_id,
gift_quantity = item.gift_quantity
};
_entities.promotion_details.Add(promotionDetails);
_entities.SaveChanges();
}
}
if (promotionChannelMappingList.Count > 0)
{
foreach (var item in promotionChannelMappingList)
{
{
var promotionChannelMapping = new promotion_channel_mapping
{
promotion_master_id = promotionMasterId,
channel_id = item.channel_id,
is_active = true
};
_entities.promotion_channel_mapping.Add(promotionChannelMapping);
_entities.SaveChanges();
}
}
}
return(1);
}
catch (Exception)
{
return(0);
}
}
