public IHttpActionResult ImpressionDetailsListForLicense(ImpressionDetails ImpressionDetails)
{
//IList<ImpressionDetails> _ImpressionDetails = _AddendumServices.GetImpressionDetails(ImpressionDetails).ToList();
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("ProductId", SqlDbType.VarChar, 50);
if (ImpressionDetails.ProductId == 0)
{
parameters[0].Value = System.Data.SqlTypes.SqlInt32.Null;
}
else
{
parameters[0].Value = ImpressionDetails.ProductId;
}
parameters[1] = new SqlParameter("LicenseId", SqlDbType.VarChar, 50);
if (ImpressionDetails.LicenseId == 0)
{
parameters[1].Value = System.Data.SqlTypes.SqlInt32.Null;
}
else
{
parameters[1].Value = ImpressionDetails.LicenseId;
}
parameters[2] = new SqlParameter("ContractId", SqlDbType.VarChar, 50);
if (ImpressionDetails.ContractId == 0)
{
parameters[2].Value = System.Data.SqlTypes.SqlInt32.Null;
}
else
{
parameters[2].Value = 0;
}
var _ImpressionDetailsList = _dbContext.ExecuteStoredProcedureListNewData <ImpressionDetailsListModel>("Proc_ImpressionDetailsList_get", parameters).ToList();
var data = (from Impression in _ImpressionDetailsList
select new
{
ISBN = Impression.ISBN,
ImpressionDate = Impression.ImpressionDate,
QunatityPrinted = Impression.QunatityPrinted,
BalanceQty = Impression.BalanceQty,
AddendumId = Impression.AddendumId,
//------------------------------------------------
Licenseprintquantity = _ProductLicense.Table.Where(a => a.Deactivate == "N" && a.Id == ImpressionDetails.LicenseId).Select(a => a.printquantity).FirstOrDefault(),
LicenseAddendumQuantity = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId).Select(a => a.AddendumQuantity).ToList(),
BalanceQuantityCarryForward = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId).OrderByDescending(a => a.EntryDate).Select(a => a.BalanceQuantityCarryForward).FirstOrDefault(),
LicenseAddendumQuantity1 = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId && a.BalanceQuantityCarryForward == "N").OrderByDescending(a => a.EntryDate).Select(a => a.AddendumQuantity).FirstOrDefault(),
CarryForwardAddendunId = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId && a.BalanceQuantityCarryForward == "N").OrderByDescending(a => a.EntryDate).Select(a => a.Id).FirstOrDefault()
//------------------------------------------------
}).ToList();
return(Json(SerializeObj.SerializeObject(data)));
}
public IList <ImpressionDetails> GetImpressionDetails(ImpressionDetails ImpressionDetails)
{
if (ImpressionDetails.ContractId == null || ImpressionDetails.ContractId == 0)
{
return(_ImpressionDetailsRepository.Table.Where(x => x.ProductId == ImpressionDetails.ProductId && (ImpressionDetails.LicenseId > 0 ? x.LicenseId : 0) == (ImpressionDetails.LicenseId > 0 ? ImpressionDetails.LicenseId : 0) && x.Deactivate == "N").ToList());
}
else
{
return(_ImpressionDetailsRepository.Table.Where(x => x.ProductId == ImpressionDetails.ProductId && (ImpressionDetails.ContractId > 0 ? x.ContractId : 0) == (ImpressionDetails.ContractId > 0 ? ImpressionDetails.ContractId : 0) && x.Deactivate == "N").ToList());
}
}
public IHttpActionResult ImpressionDetails(ImpressionDetails ImpressionDetails)
{
IList <ImpressionDetails> _ImpressionDetails = _AddendumServices.GetImpressionDetails(ImpressionDetails).ToList();
var data = (from Impression in _ImpressionDetails
select new
{
ImpressionDate = Impression.ImpressionDate.toDDMMYYYY(),
QunatityPrinted = Impression.QunatityPrinted,
//ExpiryDate = Addendum.ExpiryDate == null ? null : Convert.ToDateTime(Addendum.ExpiryDate).toDDMMYYYY()
BalanceQty = Impression.BalanceQty,
AddendumId = Impression.AddendumId,
//------------------------------------------------
Licenseprintquantity = _ProductLicense.Table.Where(a => a.Deactivate == "N" && a.Id == ImpressionDetails.LicenseId).Select(a => a.printquantity).FirstOrDefault(),
LicenseAddendumQuantity = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId).Select(a => a.AddendumQuantity).ToList(),
BalanceQuantityCarryForward = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId).OrderByDescending(a => a.EntryDate).Select(a => a.BalanceQuantityCarryForward).FirstOrDefault(),
LicenseAddendumQuantity1 = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId && a.BalanceQuantityCarryForward == "N").OrderByDescending(a => a.EntryDate).Select(a => a.AddendumQuantity).FirstOrDefault(),
CarryForwardAddendunId = _AddendumDetails.Table.Where(a => a.Deactivate == "N" && a.LicenseId == ImpressionDetails.LicenseId && a.BalanceQuantityCarryForward == "N").OrderByDescending(a => a.EntryDate).Select(a => a.Id).FirstOrDefault()
//------------------------------------------------
}).ToList();
return(Json(SerializeObj.SerializeObject(data)));
}
public void ImsertImpressionDetails(ImpressionDetails ImpressionDetails)
{
_ImpressionDetailsRepository.Insert(ImpressionDetails);
}
public IHttpActionResult InsertImpressionEntry(ImpressionDetails ImpressionDetails)
{
try
{
ImpressionDetails mobj_ImpressionDetails = new ImpressionDetails();
if (ImpressionDetails.AddendumId > 0)
{
AddendumDetails _AddendumDetails = new AddendumDetails();
_AddendumDetails.Id = ImpressionDetails.AddendumId.GetValueOrDefault();
AddendumDetails mobj_AddendumDetails = _AddendumServices.GetAddendumDetailsById(_AddendumDetails);
mobj_AddendumDetails.NoOfImpressions = mobj_AddendumDetails.NoOfImpressions - 1;
if (mobj_AddendumDetails.NoOfImpressions < 0)
{
return(Json("No. of impression are finished"));
}
mobj_AddendumDetails.BalanceQuantity = ImpressionDetails.BalanceQty - ImpressionDetails.QunatityPrinted;
if (mobj_AddendumDetails.BalanceQuantity < 0)
{
return(Json("No. of print are exceed"));
}
_AddendumServices.UpdateAddendumDetails(mobj_AddendumDetails);
ACS.Core.Domain.Product.ProductLicense _ProductLicense = new ACS.Core.Domain.Product.ProductLicense();
_ProductLicense.Id = ImpressionDetails.LicenseId.GetValueOrDefault();
ACS.Core.Domain.Product.ProductLicense mobj_ProductLicense = _ProductLicenseService.GetProductLicenseById(_ProductLicense);
mobj_ProductLicense.balanceqty = ImpressionDetails.BalanceQty - ImpressionDetails.QunatityPrinted;
_ProductLicenseService.UpdateProductLicense(mobj_ProductLicense);
}
else if (ImpressionDetails.LicenseId > 0)
{
ACS.Core.Domain.Product.ProductLicense _ProductLicense = new ACS.Core.Domain.Product.ProductLicense();
_ProductLicense.Id = ImpressionDetails.LicenseId.GetValueOrDefault();
ACS.Core.Domain.Product.ProductLicense mobj_ProductLicense = _ProductLicenseService.GetProductLicenseById(_ProductLicense);
mobj_ProductLicense.noofimpressions = mobj_ProductLicense.noofimpressions - 1;
if (mobj_ProductLicense.noofimpressions < 0)
{
return(Json("No. of impression are finished"));
}
mobj_ProductLicense.balanceqty = ImpressionDetails.BalanceQty - ImpressionDetails.QunatityPrinted;
if (mobj_ProductLicense.balanceqty < 0)
{
return(Json("No. of print are exceed"));
}
_ProductLicenseService.UpdateProductLicense(mobj_ProductLicense);
}
mobj_ImpressionDetails.ProductId = ImpressionDetails.ProductId;
mobj_ImpressionDetails.LicenseId = ImpressionDetails.LicenseId;
mobj_ImpressionDetails.AddendumId = ImpressionDetails.AddendumId;
mobj_ImpressionDetails.ContractId = ImpressionDetails.ContractId;
mobj_ImpressionDetails.ImpressionNo = ImpressionDetails.ImpressionNo;
mobj_ImpressionDetails.ImpressionDate = ImpressionDetails.ImpressionDate;
mobj_ImpressionDetails.QunatityPrinted = ImpressionDetails.QunatityPrinted;
mobj_ImpressionDetails.BalanceQty = ImpressionDetails.BalanceQty - ImpressionDetails.QunatityPrinted < 0 ? null : ImpressionDetails.BalanceQty - ImpressionDetails.QunatityPrinted;
mobj_ImpressionDetails.Deactivate = "N";
mobj_ImpressionDetails.EnteredBy = ImpressionDetails.EnteredBy;
mobj_ImpressionDetails.EntryDate = DateTime.Now;
mobj_ImpressionDetails.ModifiedBy = null;
mobj_ImpressionDetails.ModifiedDate = null;
mobj_ImpressionDetails.DeactivateBy = null;
mobj_ImpressionDetails.DeactivateDate = null;
_AddendumServices.ImsertImpressionDetails(mobj_ImpressionDetails);
return(Json("OK"));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
