/// <summary>
/// ///Clock frock
/// </summary>
/// <param name="WarehousePOData"></param>
/// <param name="productList"></param>
/// <returns></returns>
public ResponseModel CreateWarehousePODetails(WarehousePODetailsViewModel WarehousePOData, List <ProductWarehousePOVM> productList)
{
using (var transaction = _db.Database.BeginTransaction())
{
try
{
DateTime aDate = DateTime.Now;
InvWarehousePOMaster aWarehousePoMaster = new InvWarehousePOMaster()
{
// WarehouseId = WarehousePOData.WarehouseId,
WarehousePOMasterId = WarehousePOData.WarehousePOMasterId,
WarehouseId = 1, //////////In UI there is no Warehouse Id so initialy warehouse id =1 sending to database
SupplierId = WarehousePOData.SupplierId,
UniqueId = WarehousePOData.UniqueId,
POReference = WarehousePOData.POReference,
Status = 0,
IsActive = true,
IsDeleted = false,
IsEdited = false,
IsReturned = false,
CreatedDate = aDate,
};
if (WarehousePOData.WarehousePOMasterId == 0)
{
_db.InvWarehousePOMasters.Add(aWarehousePoMaster);
_db.SaveChanges();
foreach (var aData in productList)
{
InvWarehousePOInvoiceDetail aWarehousePoInvoiceDetails = new InvWarehousePOInvoiceDetail()
{
WarehousePOInvoiceDetailsId = aData.WarehousePOInvoiceDetailsId,
Original_WarehousePODetailsId = aData.WarehousePODetailsId,
ProductId = aData.ProductId,
ProductQuantity = aData.OrderedQuantity,
IsActive = true,
IsDeleted = false,
IsEdited = false,
IsReturned = false,
CreatedDate = aDate,
};
_db.InvWarehousePOInvoiceDetails.Add(aWarehousePoInvoiceDetails);
_db.SaveChanges();
}
_db.SaveChanges();
transaction.Commit();
return(_aModel.Respons(true, "Warehouse PO successfully returned"));
}
_db.SaveChanges();
transaction.Commit();
return(_aModel.Respons(true, "Sorry Warehouse PO returned Failed"));
}
catch (Exception ex)
{
transaction.Rollback();
return(_aModel.Respons(true, "Sorry Some Error Happned"));
}
}
}
public ResponseModel ChangeStatusValue(InvWarehousePOMaster aObj)
{
using (var transaction = _db.Database.BeginTransaction())
{
try
{
if (aObj.Status != null)
{
DateTime aDate = DateTime.Now;
InvWarehousePOMaster invWarehousePoMaster = _db.InvWarehousePOMasters.Find(aObj.WarehousePOMasterId);
invWarehousePoMaster.ModifiedDate = aDate;
invWarehousePoMaster.Status = aObj.Status;
_db.InvWarehousePOMasters.Attach(invWarehousePoMaster);
_db.Entry(invWarehousePoMaster).State = EntityState.Modified;
_db.SaveChanges();
if (aObj.Status == 2)
{
transaction.Commit();
return(_aModel.Respons(true, "Approved All Successfully"));
}
else if (aObj.Status == 3)
{
var data = (from m in _db.InvWarehousePOMasters
join d in _db.InvWarehousePODetails on m.WarehousePOMasterId equals d.WarehousePOMasterId
where m.WarehousePOMasterId == aObj.WarehousePOMasterId
select
new
{
m.WarehouseId,
d.ProductId,
d.ProductQuantity,
}).ToList();
foreach (var p in data)
{
InvWarehouseStock aStock = new InvWarehouseStock()
{
ProductId = p.ProductId,
WarehouseId = p.WarehouseId,
InOut = 2,
WarehouseStockQuantity = p.ProductQuantity,
CreatedDate = DateTime.Now
};
_db.InvWarehouseStocks.Add(aStock);
_db.SaveChanges();
}
transaction.Commit();
return(_aModel.Respons(true, "Sent Successfully"));
}
else if (aObj.Status == 4)
{
InvWarehousePOInvoiceMaster aWarehousePoInvoiceMaster = new InvWarehousePOInvoiceMaster()
{
Original_WarehousePOMasterId = invWarehousePoMaster.WarehousePOMasterId,
WarehousePOInvoiceNo = (_invoiceNo.GetNewInvoiceNo()),
WarehouseId = invWarehousePoMaster.WarehouseId,
Status = 0,
IsActive = true,
IsEdited = false,
IsDeleted = false,
IsReturned = false,
CreatedDate = aDate
};
_db.InvWarehousePOInvoiceMasters.Add(aWarehousePoInvoiceMaster);
_db.SaveChanges();
var data = (from m in _db.InvWarehousePOMasters
join d in _db.InvWarehousePODetails on m.WarehousePOMasterId equals d.WarehousePOMasterId
where m.WarehousePOMasterId == aObj.WarehousePOMasterId
select
new
{
m.WarehouseId,
d.WarehousePODetailsId, ///// added 04-05-2017
d.ProductId,
d.ProductQuantity,
}).ToList();
foreach (var p in data)
{
///// added 04-05-2017
InvWarehousePOInvoiceDetail invWarehousePoInvoiceDetail = new InvWarehousePOInvoiceDetail()
{
WarehousePOInvoiceMasterId = aWarehousePoInvoiceMaster.WarehousePOInvoiceMasterId,
Original_WarehousePODetailsId = p.WarehousePODetailsId,
ProductId = p.ProductId,
ProductQuantity = p.ProductQuantity,
Status = 0,
IsActive = true,
IsEdited = false,
IsDeleted = false,
IsReturned = false,
CreatedDate = aDate
};
_db.InvWarehousePOInvoiceDetails.Add(invWarehousePoInvoiceDetail);
_db.SaveChanges();
InvWarehouseStock aStock = new InvWarehouseStock()
{
ProductId = p.ProductId,
WarehouseId = p.WarehouseId,
InOut = 1,
WarehouseStockQuantity = p.ProductQuantity,
CreatedDate = DateTime.Now
};
_db.InvWarehouseStocks.Add(aStock);
_db.SaveChanges();
}
transaction.Commit();
return(_aModel.Respons(true, "Received Successfully"));
}
}
transaction.Commit();
return(_aModel.Respons(false, "Failed to Update Status"));
}
catch (Exception e)
{
transaction.Rollback();
return(_aModel.Respons(false, "Sorry! Some Error Happned"));
}
}
}
