/// <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 ChangeStockValue(InvWarehousePOMaster aObj)
{
using (var transaction = _db.Database.BeginTransaction())
{
try
{
if (aObj.Status != null)
{
DateTime aDate = DateTime.Now;
if (aObj.Status == 2)
{
transaction.Commit();
return(_aModel.Respons(true, "Approved All Successfully"));
}
else if (aObj.Status == 3)
{
transaction.Commit();
return(_aModel.Respons(true, "Sent Successfully"));
}
else if (aObj.Status == 4)
{
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.OutletId,
d.ProductId,
d.ProductQuantity,
}).ToList();
foreach (var p in data)
{
InvOutletStock aStock = new InvOutletStock()
{
ProductId = p.ProductId,
////OutletId = p.OutletId,
InOut = 1,
OutletStockQuantity = p.ProductQuantity,
CreatedDate = DateTime.Now
};
_db.InvOutletStocks.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"));
}
}
}
public ResponseModel ChangeStatusValueInMasterOrDetail(InvWarehousePODetail aObj)
{
using (var transaction = _db.Database.BeginTransaction())
{
try
{
if ((aObj.Status != null) && (aObj.Status != 0) && (aObj.Status <= 10))
{
DateTime aDate = DateTime.Now;
InvWarehousePOMaster invWarehousePOReturnMaster = _db.InvWarehousePOMasters.Find(aObj.WarehousePOMasterId);
invWarehousePOReturnMaster.ModifiedDate = aDate;
invWarehousePOReturnMaster.Status = aObj.Status;
_db.InvWarehousePOMasters.Attach(invWarehousePOReturnMaster);
_db.Entry(invWarehousePOReturnMaster).State = EntityState.Modified;
_db.SaveChanges();
if (aObj.Status == 2)
{
transaction.Commit();
return(_aModel.Respons(true, " Successfully Approved a Single Product."));
}
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,
//// m.OutletId
}).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)
{
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,
/// m.OutletId
}).ToList();
foreach (var p in data)
{
InvOutletStock aStock = new InvOutletStock()
{
ProductId = p.ProductId,
////OutletId = p.OutletId,
InOut = 1,
OutletStockQuantity = p.ProductQuantity,
CreatedDate = DateTime.Now
};
_db.InvOutletStocks.Add(aStock);
_db.SaveChanges();
}
transaction.Commit();
return(_aModel.Respons(true, "Received Successfully."));
}
else if (aObj.Status == 10)
{
transaction.Commit();
return(_aModel.Respons(true, "Successfully Deleted."));
}
}
else if (aObj.Status > 10)
{
DateTime aDate = DateTime.Now;
InvWarehousePODetail InvWarehousePODetail = _db.InvWarehousePODetails.Find(aObj.WarehousePODetailsId);
InvWarehousePODetail.ModifiedDate = aDate;
InvWarehousePODetail.Status = aObj.Status;
_db.InvWarehousePODetails.Attach(InvWarehousePODetail);
_db.Entry(InvWarehousePODetail).State = EntityState.Modified;
_db.SaveChanges();
if (aObj.Status == 22)
{
transaction.Commit();
return(_aModel.Respons(true, " Successfully Approved a Single Product."));
}
else if (aObj.Status == 22)
{
transaction.Commit();
return(_aModel.Respons(true, " Successfully Approved All Product."));
}
else if (aObj.Status == 44)
{
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,
/// m.OutletId
}).ToList();
foreach (var p in data)
{
InvOutletStock aStock = new InvOutletStock()
{
ProductId = p.ProductId,
////OutletId = p.OutletId,
InOut = 1,
OutletStockQuantity = p.ProductQuantity,
CreatedDate = DateTime.Now
};
_db.InvOutletStocks.Add(aStock);
_db.SaveChanges();
}
transaction.Commit();
return(_aModel.Respons(true, "Received Successfully."));
}
else if (aObj.Status == 1010)
{
transaction.Commit();
return(_aModel.Respons(true, "Successfully Deleted A Product."));
}
}
transaction.Commit();
return(_aModel.Respons(false, "Failed to Update Status."));
}
catch (Exception e)
{
transaction.Rollback();
return(_aModel.Respons(false, "Sorry! Some Error Happned."));
}
}
}
/////////////GET: /Inventory/WarehousePOReturn/ChangeStatusValueInMasterTable
public JsonResult ChangeStatusValueInMasterTable(InvWarehousePOMaster aObj)
{
var data = _aManager.ChangeStatusValueInMasterTable(aObj);
return(Json(data, JsonRequestBehavior.AllowGet)); //To show message after operation must be write code " return Json(data , JsonRequestBehavior.AllowGet);" instid of return Json(new { data = data.Data }, JsonRequestBehavior.AllowGet);
}
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"));
}
}
}
////// GET: /Inventory/WarehousePO/ChangeStockValue
public JsonResult ChangeStockValue(InvWarehousePOMaster aObj)
{
var data = _aManager.ChangeStockValue(aObj);
return(Json(data, JsonRequestBehavior.AllowGet));
}
