/// <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"));
}
}
}
//// GET: /Inventory/WarehousePOReturn/CreateWarehousePOReturnDetails
public JsonResult CreateWarehousePOReturnDetails(WarehousePODetailsViewModel WarehousePOReturnData, List <ProductWarehousePOVM> productList)
{
// return null;
var data = _aManager.CreateWarehousePOReturnDetails(WarehousePOReturnData, productList);
return(Json(new { success = data.Status, data }, JsonRequestBehavior.AllowGet));
}
public ResponseModel CreateWarehousePOReturnDetails(WarehousePODetailsViewModel WarehousePOReturnData, List <ProductWarehousePOVM> productList)
{
// using (var transaction = _db.Database.BeginTransaction())
// {
// try
// {
// DateTime aDate = DateTime.Now;
// InvWarehousePOInvoiceMaster aWarehousePoInvoiceMaster = new InvWarehousePOInvoiceMaster()
// {
// WarehousePOInvoiceMasterId = WarehousePOReturnData.WarehousePOInvoiceMasterId,
// Original_WarehousePOMasterId = WarehousePOReturnData.WarehousePOMasterId,
// // WarehousePOInvoiceNo = WarehousePOReturnData.WarehousePOInvoiceNo,
// WarehouseId = WarehousePOReturnData.WarehouseId,
// SupplierId = WarehousePOReturnData.SupplierId,
// UniqueId = WarehousePOReturnData.UniqueId,
// POReference = WarehousePOReturnData.POReference,
// Status = 0,
// IsActive = true,
// IsDeleted = false,
// IsEdited = false,
// IsReturned = false,
// CreatedDate = aDate,
// };
// if (WarehousePOReturnData.WarehousePOMasterId == 0)
// {
// // _db.InvWarehousePOMasters.Add(aWarehousePoMaster);
// _db.SaveChanges();
// foreach (var aData in productList)
// {
// InvWarehousePOInvoiceDetail aWarehousePoInvoiceDetails = new InvWarehousePOInvoiceDetail()
// {
// WarehousePOInvoiceMasterId = WarehousePOReturnData.WarehousePOInvoiceMasterId,
// Original_WarehousePODetailsId = aData.WarehousePODetailsId,
// ProductId = aData.ProductId,
// ProductQuantity = aData.OrderedQuantity,
// IsActive = true,
// IsDeleted = false,
// IsEdited = false,
// IsReturned = false,
// CreatedDate = aDate,
// };
// //_db.InvWarehousePODetails.Add(aWarehousePoDetails);
// _db.SaveChanges();
// InvWarehousePOItemReceived aWarehousePoItemReceived = new InvWarehousePOItemReceived()
// {
// WarehousePOMasterId = aWarehousePoMaster.WarehousePOMasterId,
// WarehousePODetailsId = aWarehousePoDetails.WarehousePODetailsId,
// ItemReceivedQuantity = 0,
// };
// _db.InvWarehousePOItemReceiveds.Add(aWarehousePoItemReceived);
// _db.SaveChanges();
// }
// _db.SaveChanges();
// transaction.Commit();
// return _aModel.Respons(true, "New WarehousePO Successfully Saved");
// }
// else if (WarehousePOReturnData.WarehousePOMasterId > 0)
// {
// _db.InvWarehousePOMasters.Attach(aWarehousePoMaster);
// _db.Entry(aWarehousePoMaster).State = EntityState.Modified;
// _db.SaveChanges();
// //var invPoDetails = _db.InvWarehousePODetails.Find(x.WarehousePODetailsId);
// ////var invPoDetails = (from d in _db.InvWarehousePODetails
// //// where d.WarehousePOMasterId == aWarehousePoMaster.WarehousePOMasterId
// //// select d).ToList();
// //invPoDetails.IsActive = false;
// //invPoDetails.ModifiedDate = aDate;
// foreach (var aData in productList)
// {
// InvWarehousePODetail aWarehousePoDetails = new InvWarehousePODetail()
// {
// WarehousePOMasterId = aWarehousePoMaster.WarehousePOMasterId,
// WarehousePODetailsId = aData.WarehousePODetailsId,
// ProductId = aData.ProductId,
// ProductQuantity = aData.OrderedQuantity,
// CreatedDate = aDate
// };
// _db.InvWarehousePODetails.Add(aWarehousePoDetails);
// _db.Entry(aWarehousePoDetails).State = EntityState.Modified;
// _db.SaveChanges();
// /////////////////////////////////////////Below Code Create Bugs,Causes there are no effect changing of Warehouse PO Create/Edit after View/just view.Also we didn't send any value from client to server and used Transection for safety,but transection is failed to update any value and as usually it is rolling back and wihout Attachihg/Adding in any of these 3(three) table.
// // InvWarehousePOItemReceived aWarehousePoItemReceived = new InvWarehousePOItemReceived()
// // {
// // WarehousePOMasterId = aWarehousePoMaster.WarehousePOMasterId,
// // WarehousePODetailsId = aWarehousePoDetails.WarehousePODetailsId,
// // WarehousePOItemReceivedId = aData.WarehousePOItemReceivedId,
// // ItemReceivedQuantity = 0,
// // };
// // _db.InvWarehousePOItemReceiveds.Add(aWarehousePoItemReceived);
// // _db.Entry(aWarehousePoItemReceived).State = EntityState.Modified;
// // _db.SaveChanges();
// }
// transaction.Commit();
// return _aModel.Respons(true, "Warehouse PO Successfully Updated");
// }
// _db.SaveChanges();
// transaction.Commit();
// return _aModel.Respons(true, "Sorry Warehouse PO Update Failed");
// }
// catch (Exception ex)
// {
// transaction.Rollback();
// return _aModel.Respons(true, "Sorry Some Error Happned");
// }
// }
return(null);
}
//// POST: /Inventory/WarehousePO/CreateWarehousePODetails
public JsonResult CreateWarehousePODetails(WarehousePODetailsViewModel WarehousePOData, List <ProductWarehousePOVM> productList)
{
var data = _aManager.CreateWarehousePODetails(WarehousePOData, productList);
return(Json(data, JsonRequestBehavior.AllowGet));
}
