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