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