public ItemsModel AssignItem(TbItems item)
{
if (item != null)
{
return(new ItemsModel
{
Id = item.Id,
TrackingNumber = item.TrackingNumber,
CustomerId = item.Customer.Id,
ItemName = item.ItemName,
Status = item.Status.Status,
ItemValue_Baht = item.ItemValue_Baht,
ItemValue_Dollar = item.ItemValue_Dollar,
ItemValue_Kip = item.ItemValue_Kip,
CustomerPhonenumber = item.Customer.Phonenumber,
CustomerName = item.Customer.Name,
Description = item.Descripttion,
ReceiverName = item.ReceiverName,
ReceipverPhone = item.ReceipverPhone,
ReceiverAddress = item.ReceiverAddress,
ReceiveDate = item.ReceiveDate == null ? "" : item.ReceiveDate?.ToString("dd-MM-yyyy"),
ConfrimDate = item.ConfrimDate == null ? "" : item.ConfrimDate?.ToString("dd-MM-yyyy"),
CreatedDate = item.CreatedDate == null ? "" : item.CreatedDate?.ToString("dd-MM-yyyy"),
SendingDate = item.SendingDate == null ? "" : item.SendingDate?.ToString("dd-MM-yyyy"),
SentDate = item.SentDate == null ? "" : item.SentDate?.ToString("dd-MM-yyyy"),
isDeleted = item.isDeleted,
});
}
else
{
return(null);
}
}
public TbItems CreateProductByAdmin(CustomerItemsModel model, EntityContext db, int itemstatus)
{
TbItems item = new TbItems
{
ItemName = model.ItemName,
ItemValue_Baht = model.ItemValue_Baht,
ItemValue_Dollar = model.ItemValue_Dollar,
ItemValue_Kip = model.ItemValue_Kip,
isDeleted = false,
Status = db.tbItemStatuses.FirstOrDefault(s => s.Id == itemstatus),
Customer = _customer.GetSingle(db, model.CustomerId),
CreatedDate = DateTime.Now,
ReceipverPhone = model.ReceipverPhone,
ReceiverAddress = model.ReceiverAddress,
ReceiverName = model.ReceiverName,
Descripttion = model.Description
};
db.TbItems.Add(item);
db.SaveChanges();
db.Entry(item).State = EntityState.Modified;
string customerId = model.CustomerId.ToString().PadLeft(4, '0');
string itemId = item.Id.ToString().PadLeft(7, '0');
StringBuilder sb = new StringBuilder();
sb.Append("U" + customerId);
sb.Append("I" + itemId);
item.TrackingNumber = sb.ToString();
db.SaveChanges();
return(item);
}
public ItemSingleModel CreateItemById(ItemSingleModel model)
{
using (var db = new EntityContext())
{
using (var dbtransact = db.Database.BeginTransaction())
{
int itemstatus = 3;
TbItems item = CreateItemMethod(model, db, dbtransact, itemstatus);
return(GetSingle(item.Id));
}
}
}
public bool Create(ItemSingleModel model)
{
using (var db = new EntityContext())
{
using (var dbtransact = db.Database.BeginTransaction())
{
int itemstatus = 1;
TbItems item = CreateItemMethod(model, db, dbtransact, itemstatus);
return(true);
}
}
}
/// <summary>
/// For Customer Use Only
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Create(ItemsModel model)
{
using (var db = new EntityContext())
{
using (var dbtransact = db.Database.BeginTransaction())
{
int itemstatus = 1;
TbItems item = _item.CreateProduct(model, db, itemstatus);
dbtransact.Commit();
return(item.Id);
}
}
}
public ItemSingleModel CreateItemForDelivery(ItemSingleModel model)
{
using (var db = new EntityContext())
{
using (var dbtransact = db.Database.BeginTransaction())
{
int itemstatus = 3;
if (model.Status != null)
{
itemstatus = db.tbItemStatuses.FirstOrDefault(x => x.Status == model.Status).Id;
}
if (model.CustomerId == 0)
{
model.CustomerId = db.tbCustomers.FirstOrDefault(x => x.Phonenumber == model.CustomerPhonenumber).Id;
}
TbItems item = CreateItemMethod(model, db, dbtransact, itemstatus);
return(GetSingle(item.Id));
}
}
}
public int CreateByAdmin(ItemsModel model)
{
using (var db = new EntityContext())
{
using (var dbtransact = db.Database.BeginTransaction())
{
int itemstatus = 3;
if (model.CustomerId == 0)
{
model.CustomerId = db.tbCustomers.FirstOrDefault(c => c.Phonenumber == c.Phonenumber).Id;
}
TbItems item = _item.CreateProduct(model, db, itemstatus);
db.Entry(item).State = EntityState.Modified;
item.ReceiveDate = DateTime.Now.Date;
db.SaveChanges();
dbtransact.Commit();
return(item.Id);
}
}
}
