public static ResultResponse UploadItem(PromotionItemFileViewModel entity) { ResultResponse result = new ResultResponse(); try { using (var db = new MarComContext()) { if (entity.Id == 0) { T_Promotion_Item_File it = new T_Promotion_Item_File(); it.Id = it.Id; it.Filename = it.Filename; it.Qty = it.Qty; it.Todo = it.Todo; it.Request_Due_Date = it.Request_Due_Date; it.Note = it.Note; it.Create_By = it.Create_By; it.Create_Date = DateTime.Now; db.T_Promotion_Item_File.Add(it); db.SaveChanges(); } } } catch (Exception) { throw; } return(result); }
public static ResultResponse Update(PromotionViewModel entity, List <PromotionItemViewModel> entityItem, List <PromotionItemFileViewModel> entityFile) { ResultResponse result = new ResultResponse(); try { using (var db = new MarComContext()) { if (entity.Id == 0) { string newCode = GetTransactionCode(); T_Promotion promotion = new T_Promotion(); promotion.Code = newCode; promotion.T_Event_Id = entity.T_Event_Id; promotion.T_Design_Id = entity.T_Design_Id; promotion.Is_Delete = entity.Is_Delete; promotion.Flag_Design = "1"; promotion.Status = 1; promotion.Title = entity.Title; promotion.Note = entity.Note; promotion.Create_By = entity.Create_By; promotion.Create_Date = DateTime.Now; promotion.Request_By = entity.Request_By; promotion.Request_Date = DateTime.Now; db.T_Promotion.Add(promotion); foreach (var item in entityItem) { T_Promotion_Item promotionItem = new T_Promotion_Item(); promotionItem.M_Product_Id = item.M_Product_Id; promotionItem.Title = item.Title; promotionItem.T_Design_Item_Id = item.T_Design_Item_Id; promotionItem.Qty = item.Qty; promotionItem.Todo = item.Todo; promotionItem.Request_Due_Date = item.Request_Due_Date; promotionItem.Note = item.Note; promotionItem.T_Promotion_Id = entity.Id; promotionItem.Request_Pic = 8; promotionItem.Create_By = promotion.Create_By; promotionItem.Create_Date = DateTime.Now; db.T_Promotion_Item.Add(promotionItem); } foreach (var item in entityFile) { T_Promotion_Item_File promotionFile = new T_Promotion_Item_File(); promotionFile.T_Promotion_id = promotion.Id; promotionFile.Filename = item.Filename; //promotionFile.ImagePath = item.ImagePath; promotionFile.Extention = item.Extention; promotionFile.Qty = item.Qty; promotionFile.Todo = item.Todo; promotionFile.Request_Due_Date = item.Request_Due_Date; promotionFile.Note = item.Note; promotionFile.Create_By = promotion.Create_By; promotionFile.Create_Date = DateTime.Now; db.T_Promotion_Item_File.Add(promotionFile); } db.SaveChanges(); } else { T_Promotion promotion = db.T_Promotion.Where(pr => pr.Id == entity.Id).FirstOrDefault(); if (promotion != null) { promotion.Code = entity.Code; promotion.T_Event_Id = entity.T_Event_Id; promotion.T_Design_Id = entity.T_Design_Id; promotion.Flag_Design = "1"; promotion.Title = entity.Title; promotion.Note = entity.Note; promotion.Status = 1; promotion.Update_By = entity.Update_By; promotion.Update_Date = DateTime.Now; foreach (var item in entityItem) { if (item.Id == 0) //ini buat add item edit misal mau nambah file { T_Promotion_Item promotionItem = new T_Promotion_Item(); promotionItem.T_Promotion_Id = promotion.Id; promotionItem.M_Product_Id = item.M_Product_Id; promotionItem.Title = item.Title; promotionItem.Qty = item.Qty; promotionItem.Todo = item.Todo; promotionItem.Request_Due_Date = item.Request_Due_Date; promotionItem.Note = item.Note; promotionItem.Request_Pic = 8; promotionItem.Create_By = promotion.Create_By; promotionItem.Create_Date = DateTime.Now; db.T_Promotion_Item.Add(promotionItem); } else { T_Promotion_Item promotionItem = db.T_Promotion_Item.Where(pi => pi.Id == item.Id).FirstOrDefault(); if (promotionItem != null) //nah ini misal mau edit si add item. { promotionItem.T_Promotion_Id = promotion.Id; promotionItem.T_Design_Item_Id = item.T_Design_Item_Id; promotionItem.M_Product_Id = item.M_Product_Id; promotionItem.Title = item.Title; promotionItem.Qty = item.Qty; promotionItem.Todo = item.Todo; promotionItem.Request_Due_Date = item.Request_Due_Date; promotionItem.Note = item.Note; promotionItem.Request_Pic = 8; promotionItem.Update_By = promotion.Update_By; promotionItem.Update_Date = DateTime.Now; } } } foreach (var item in entityFile) { if (item.Id == 0) { T_Promotion_Item_File promotionFile = new T_Promotion_Item_File(); promotionFile.T_Promotion_id = promotion.Id; promotionFile.Filename = item.Filename; //promotionFile.ImagePath = item.ImagePath; promotionFile.Extention = item.Extention; promotionFile.Qty = item.Qty; promotionFile.Todo = item.Todo; promotionFile.Request_Due_Date = item.Request_Due_Date; promotionFile.Note = item.Note; promotionFile.Create_By = promotion.Create_By; promotionFile.Create_Date = DateTime.Now; db.T_Promotion_Item_File.Add(promotionFile); } else { T_Promotion_Item_File promotionFile = new T_Promotion_Item_File(); if (promotionFile != null) { promotionFile.T_Promotion_id = promotion.Id; promotionFile.Filename = item.Filename; //promotionFile.ImagePath = item.ImagePath; promotionFile.Extention = item.Extention; promotionFile.Qty = item.Qty; promotionFile.Todo = item.Todo; promotionFile.Request_Due_Date = item.Request_Due_Date; promotionFile.Note = item.Note; promotionFile.Update_By = promotion.Update_By; promotionFile.Update_Date = DateTime.Now; } } db.SaveChanges(); } } } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }