public IHttpActionResult getSubProductTypeList()
{
IList <ProductTypeMaster> subProductList = _CommonListService.GetSubProductType().ToList();
var subProductData = subProductList.Select(p => new
{
subProductId = p.Id,
subProductName = p.typeName,
productName = p.ProductTypeM.typeName
});
return(Json(SerializeObj.SerializeObject(new { subProductData = subProductData })));
//var leftList = (from emp in _ProductTypeMaster.Table.Where(a => a.Deactivate == "N")
// join d in _ProductMaster.Table.Where(a => a.Deactivate == "N")
// on emp.Id equals d.SubProductTypeId into output
// from j in output.DefaultIfEmpty()
// select new
// {
// id = emp.Id,
// typeName = emp.typeName,
// Flag = j.SubProductTypeId != null ? "1" : "0",
// TypeLavel = emp.typelevel,
// }).Distinct().Where(a => a.TypeLavel == 2);
//return Json(leftList);
}
public IHttpActionResult ContactDetailById(string Id)
{
// call ACS.Services function for fetching contact details
int ContactId = Convert.ToInt32(Id);
ACS.Core.Domain.Master.ExecutiveMaster Executive = _contactService.GetContactDetailById(ContactId);
return(Json(SerializeObj.SerializeObject(new { Executive.Id, Name = Executive.executiveName })));
}
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 IHttpActionResult GetAllISBNBagList(int productType)
{
var _list = _CommonListService.GetAllISBNBagList().Where(a => a.Blocked == null && a.ProductTypeid == productType).ToList();
var query = _list.Select(i => new
{
Id = i.Id,
ISBN = i.ISBN,
}).OrderBy(a => a.Id);
return(Json(SerializeObj.SerializeObject(new { query })));
}
public IHttpActionResult GetISBNList(ProductTypeMaster Ptype)
{
var _list = _CommonListService.GetAllISBNByProductTypeId(Ptype.Id).Where(a => a.Blocked == null).ToList();
var query = _list.Select(i => new
{
Id = i.Id,
ISBN = i.ISBN,
}).OrderBy(a => a.Id);
return(Json(SerializeObj.SerializeObject(new { query })));
}
/// <summary>
/// Description :SubDevision List By DevisionId
/// Function Name :SubDivisionListByDivisionId
/// OutPut parameter :DataSet
/// Create Date : 11 May 2016
/// Author Name : Vishal Verma
/// </summary>
/// <remarks>
///**************************** Modification History *************************************************************
/// Sr No: Date Modified by Tracker Description
///*****************************************************************************************************************
///*****************************************************************************************************************
///
///</remarks>
public IHttpActionResult SubDivisionListByDivisionId(DivisionMaster Division)
{
IList <DivisionMaster> _divisionList = _CommonListService.GetAllSubDivisionsbyDivisonId(Division).ToList();
var divisionData = _divisionList.Select(dl => new
{
SubDivisionId = dl.Id,
SubDivisionName = dl.divisionName
});
return(Json(SerializeObj.SerializeObject(new { divisionData = divisionData })));
}
public IHttpActionResult WebGetaCUrrencyByDefault()
{
CurrencyMaster _currency = _CurrencyMaster.Table.Where(a => a.Symbol == "INR" && a.Deactivate == "N").FirstOrDefault();
var _currencyList = new
{
CurrencyCode = _currency.Id
};
return(Json(SerializeObj.SerializeObject(new { _currencyList })));
}
public IHttpActionResult GetProductISBNList()
{
//var query1 = _CommonListService.GetProductISBNList().ToList().Select(i => new
//{
// Id = i.Id,
// ISBN = i.OUPISBN,
//}).OrderBy(a => a.Id);
var query = _dbContext.ExecuteStoredProcedureListNewData <ProductISBN>("Proc_GetProductISBNList_get").ToList();
return(Json(SerializeObj.SerializeObject(new { query })));
}
/// <summary>
/// Description :Series List by SubDivisionId
/// Function Name :Series List by SubDivisionId
/// OutPut parameter :DataSet
/// Create Date : 23 May 2016
/// Author Name : Vishal Verma
/// </summary>
/// <remarks>
///**************************** Modification History *************************************************************
/// Sr No: Date Modified by Tracker Description
///*****************************************************************************************************************
///*****************************************************************************************************************
///
///</remarks>
public IHttpActionResult SeriesListbyDivisionSubDivisionId(SeriesMaster Series)
{
IList <SeriesMaster> _SeriesList = _CommonListService.GetSeriesList(Series).Where(x => x.Deactivate == "N").ToList();
var SeriesData = _SeriesList.Select(sr => new
{
SeriesId = sr.Id,
Id = sr.Id,
SeriesName = sr.Seriesname
});
return(Json(SerializeObj.SerializeObject(new { SeriesData })));
}
public IHttpActionResult getAuthorList()
{
var query = _CommonListService.GetAllAuthor().ToList().Select(i => new
{
Id = i.Id,
FirstName = i.FirstName,
LastName = i.LastName
});
query = query.OrderBy(x => x.FirstName);
return(Json(SerializeObj.SerializeObject(new { query })));
}
public IHttpActionResult getSubProductTypeList()
{
IList <ProductTypeMaster> subProductList = _productTypeService.GetSubProductType().ToList();
var subProductData = subProductList.Select(p => new
{
subProductId = p.Id,
subProductName = p.typeName,
productName = p.ProductTypeM.typeName
});
return(Json(SerializeObj.SerializeObject(new { subProductData = subProductData })));
}
//
////Added by Saddam on 09/05/2016
//[HttpGet]
//public IHttpActionResult getAuthorList()
//{
// return Json(_CommonListService.GetAllAuthor().ToList());
//}
public IHttpActionResult AuthorSuggesationList(AuthorMaster AuthorMaster)
{
IList <AuthorMaster> _AuthorList = _CommonListService.GetAuthorSuggesationList(AuthorMaster).ToList();
var AuthorSuggesation = _AuthorList.Select(Au => new
{
AuthorId = Au.Id,
AuthorName = Au.FirstName + " " + Au.LastName,
AuthorCode = Au.AuthorCode,
AuthorSAPCode = Au.AuthorSAPCode,
});
return(Json(SerializeObj.SerializeObject(new { AuthorSuggesation })));
}
public IHttpActionResult SubServiceListByServiceId(string ServiceId)
{
if (ServiceId != "undefined" && ServiceId != "")
{
var query = _CommonListService.GetAllSubServiceListByServiceId(int.Parse(ServiceId)).ToList();
return(Json(SerializeObj.SerializeObject(new { query })));
}
else
{
ServiceId = "0";
var query = _CommonListService.GetAllSubServiceListByServiceId(int.Parse(ServiceId)).ToList();
return(Json(SerializeObj.SerializeObject(new { query })));
}
}
public IHttpActionResult WebGetProprietorById(ACS.Core.Domain.Master.CustomProduct Proprietor)
{
mobj_proprietorMaster = new ProprietorMaster();
mobj_proprietorMaster.Id = Proprietor.Id;
mobj_proprietorMaster = _CustomProductService.getcustomproductbyid(mobj_proprietorMaster);
Proprietor.Id = mobj_proprietorMaster.Id;
Proprietor.ProprietorISBN = mobj_proprietorMaster.ProprietorISBN;
Proprietor.ProprietorProduct = mobj_proprietorMaster.ProprietorProduct;
Proprietor.ProprietorEdition = mobj_proprietorMaster.ProprietorEdition;
Proprietor.ProprietorCopyrightYear = mobj_proprietorMaster.ProprietorCopyrightYear;
Proprietor.PublishingCompanyId = mobj_proprietorMaster.PublishingCompanyId;
Proprietor.ProprietorPubCenterId = mobj_proprietorMaster.ProprietorPubCenterId;
Proprietor.ProprietorImPrintId = mobj_proprietorMaster.ProprietorImPrintId;
Proprietor.AuthorId = mobj_proprietorMaster.ProprietorAuthorLink
.Where(x => x.Deactivate == "N")
.Select(x => x.AuthorId).FirstOrDefault().ToString();
Proprietor.AuthorIdList = mobj_proprietorMaster.ProprietorAuthorLink
.Where(x => x.Deactivate == "N")
.AsEnumerable()
.Select(x => x.AuthorId.ToString())
.ToArray();
Proprietor.AuthorId = string.Join(",", Proprietor.AuthorIdList);
// return Json(Proprietor);
IList <ProprietorAuthorLink> _ProprietorAuthorList = mobj_proprietorMaster.ProprietorAuthorLink.ToList();
var ProprietorAuthor = _ProprietorAuthorList.Select(pu => new
{
AuthorId = pu.AuthorId,
AuthorName = pu.ProprietorAuthorLinkAuthor.FirstName + " " + pu.ProprietorAuthorLinkAuthor.LastName,
});
return(Json(SerializeObj.SerializeObject(new { Proprietor, ProprietorAuthor })));
}
public IHttpActionResult WebGetExecutiveById(ExecutiveMaster Executive)
{
ACS.Core.Domain.Master.ExecutiveMaster _Executive = _ExecutiveService.GetExecutiveById(Executive.Id);
var reporting = _Executive.ExecutiveReportings.Where(i => i.Deactivate == "N").ToList().FirstOrDefault();
var divisionLinks = _Executive.ExecutiveDivisionLinks.Where(a => a.Deactivate == "N").ToList();
var query = new
{
Password = _encryptionService.DecryptText(_Executive.Password, _ExecutiveService.KeyValue("encriptionkey")),
Executivename = _Executive.executiveName,
Email = _Executive.Emailid,
Phone = _Executive.Phoneno,
Mobile = _Executive.Mobile,
DepartmentId = _Executive.DepartmentId,
Id = _Executive.Id,
Code = _Executive.executivecode
};
return(Json(SerializeObj.SerializeObject(new { query, reporting, divisionLinks })));
}
public IHttpActionResult getAddendumDetailsByLicenseId(int LicenseId)
{
IList <AddendumDetails> AddendumDetails1 = _AddendumServices.GetAddendumDetailsByLicenseId(LicenseId);
var AddendumDetails = (from Addendum in AddendumDetails1
select new
{
Id = Addendum.Id,
LicenseId = Addendum.LicenseId,
AddendumCode = Addendum.AddendumCode,
AddendumDate = Addendum.AddendumDate.toDDMMYYYY(),
AddendumQuantity = Addendum.AddendumQuantity,
ExpiryDate = Addendum.ExpiryDate == null? null : Convert.ToDateTime(Addendum.ExpiryDate).toDDMMYYYY(),
Addendum_Type = Addendum.AddendumType,
//AddendumFileName = Addendum.IAddendumFileDetails.FirstOrDefault().FileName,
//AddendumUploadFileName = Addendum.IAddendumFileDetails.FirstOrDefault().UploadFileName,
}).ToList();
return(Json(SerializeObj.SerializeObject(new { AddendumDetails })));
}
// function for fetching contact details basis on contactId
public IHttpActionResult ContactById(ACS.Core.Domain.Master.ExecutiveMaster Executive)
{
// call ACS.Services function for fetching contact details
ACS.Core.Domain.Master.ExecutiveMaster _contactData = _contactService.GetContactDetailById(Executive.Id);
return(Json(SerializeObj.SerializeObject(new
{
Id = _contactData.Id,
FirstName = _contactData.executiveName,
Email = _contactData.Emailid,
Password = _contactData.Password,
Mobile = _contactData.Mobile,
Phone = _contactData.Phoneno,
DeptId = _contactData.DepartmentId,
Proc_Trns_To = _contactData.ProcessTransferTo,
})));
}
public IHttpActionResult TopSearch(String Code)
{
OtherContractMaster OtherContract = _OtherContractMaster.Table.Where(a => a.othercontractcode == Code && a.Deactivate == "N").FirstOrDefault();
if (OtherContract != null)
{
var _OtherContract = new
{
othercontractcode = OtherContract.Id
};
return(Json(SerializeObj.SerializeObject(new { _OtherContract })));
}
else
{
string _OtherContract = string.Empty;
return(Json(SerializeObj.SerializeObject(new { _OtherContract })));
}
}
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 IHttpActionResult getImprint(int Id)
{
ImprintMaster _imprintMaster = _imprintService.GetImprintById(Id);
return(Json(SerializeObj.SerializeObject(new { _imprintMaster })));
}
public IHttpActionResult getTerriteryRights()
{
var query = _CommonListService.TerriteryRights().ToList();
return(Json(SerializeObj.SerializeObject(new { query })));
}
public IHttpActionResult getGeographical(int Id)
{
GeographicalMaster _geographicalMaster = _geographicalService.GetGeographicalById(Id);
return(Json(SerializeObj.SerializeObject(new { _geographicalMaster })));
}
public IHttpActionResult getAuthorTypeList()
{
var query = _CommonListService.GetAllAuthorTypeList().ToList();
return(Json(SerializeObj.SerializeObject(new { query })));
}
public IHttpActionResult OtherContractSerchView(Contract_Signed_By_Executive OtherContract)
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("OthercontractId", SqlDbType.VarChar, 50);
if (OtherContract.Id == null)
{
parameters[0].Value = System.Data.SqlTypes.SqlInt32.Null;
}
else
{
parameters[0].Value = OtherContract.Id;
}
var _GetOtherContractSearch = _dbContext.ExecuteStoredProcedureListNewData <Contract_Signed_By_Executive>("Proc_OtherContractList_get", parameters).ToList();
var OtherContractDivisionLink = (from OCDL in _OtherContractDivisionLink.Table.Where(a => a.Deactivate == "N")
join DM in _DivisionMaster.Table.Where(a => a.Deactivate == "N")
on OCDL.divisionid equals DM.Id
select new
{
divisionid = OCDL.divisionid,
divisionName = DM.divisionName,
othercontractid = OCDL.othercontractid
}
).Distinct().Where(a => a.othercontractid == OtherContract.Id).ToList();
OtherContractImageBank _ContractImageBank = _OtherContractImageBank.Table.Where(a => a.othercontractid == OtherContract.Id && a.Deactivate == "N").FirstOrDefault();
Contract_Signed_By_Executive OtherContractDocuments = new Contract_Signed_By_Executive();
var documents = _OtherContractDocuments.Table.Where(a => a.othercontractid == OtherContract.Id && a.Deactivate == "N").ToList();
OtherContractDocuments.DocumentIds = documents.Select(i => i.Id).ToArray();
OtherContractDocuments.Documentname = documents.Select(i => i.Documentname).ToArray();
foreach (var docs in documents)
{
OtherContractDocuments.documentfile = OtherContractDocuments.documentfile + docs.documentfile + ",";
}
OtherContractLink _OtherContractLintList = _OtherContractLink.Table.Where(a => a.othercontractid == OtherContract.Id && a.Deactivate == "N").FirstOrDefault();
Contract_Signed_By_Executive OtherContractDocuments2 = new Contract_Signed_By_Executive();
if (_OtherContractLintList != null)
{
var documents2 = _OtherContractLinkDocument.Table.Where(a => a.othercontractLinkid == _OtherContractLintList.Id && a.Deactivate == "N").ToList();
OtherContractDocuments2.DocumentlinkIds = documents2.Select(i => i.Id).ToArray();
OtherContractDocuments2.DocumentnameLink = documents2.Select(i => i.DocumentnameLink).ToArray();
foreach (var docs in documents2)
{
OtherContractDocuments2.documentfileLink = OtherContractDocuments2.documentfileLink + docs.documentfileLink + ",";
}
}
else
{
OtherContractDocuments2 = new Contract_Signed_By_Executive();
}
if (_ContractImageBank != null)
{
var ImageTypeOtherContact = (from VIBL in _VideoImageBank.Table.Where(a => a.Deactivate == "N" && a.Type == "I")
join CM in _CurrencyMaster.Table.Where(a => a.Deactivate == "N")
on VIBL.CurrencyId equals CM.Id
select new
{
Fullname = VIBL.Fullname,
Cost = VIBL.Cost,
Currency = CM.CurrencyName,
CurrencySymbol = CM.Symbol,
CurrencyId = VIBL.CurrencyId,
ImageBankId = VIBL.ImageBankId
}).Distinct().Where(a => a.ImageBankId == _ContractImageBank.Id).ToList();
var VideoTypeOtherContact = (from VIBL in _VideoImageBank.Table.Where(a => a.Deactivate == "N" && a.Type == "V")
join CM in _CurrencyMaster.Table.Where(a => a.Deactivate == "N")
on VIBL.CurrencyId equals CM.Id
select new
{
Fullname = VIBL.Fullname,
Cost = VIBL.Cost,
Currency = CM.CurrencyName,
CurrencySymbol = CM.Symbol,
CurrencyId = VIBL.CurrencyId,
ImageBankId = VIBL.ImageBankId
}
).Distinct().Where(a => a.ImageBankId == _ContractImageBank.Id).ToList();
return(Json(SerializeObj.SerializeObject(new { _GetOtherContractSearch, OtherContractDivisionLink, ImageTypeOtherContact, VideoTypeOtherContact, OtherContractDocuments, OtherContractDocuments2 })));
}
else
{
var ImageTypeOtherContact = new { };
var VideoTypeOtherContact = new { };
return(Json(SerializeObj.SerializeObject(new { _GetOtherContractSearch, OtherContractDivisionLink, ImageTypeOtherContact, VideoTypeOtherContact, OtherContractDocuments, OtherContractDocuments2 })));
}
// return Json(_GetOtherContractSearch);
}
public IHttpActionResult InsertAddendumDetails(ACS.Core.Domain.Product.AddendumDetails AddendumDetails)
{
int AddendumId = 0;
string status = string.Empty;
IList <AddendumRoyaltySlab> _IAddendumRoyaltySlab = new List <AddendumRoyaltySlab>();
ProductLicense License = _ProductLicenseService.GetProductLicenseById(AddendumDetails.LicenseId);
AddendumDetails.BalanceQuantity = AddendumDetails.AddendumQuantity;
if (License.printquantitytype == "Number")
{
if (AddendumDetails.BalanceQuantityCarryForward == "Y")
{
AddendumDetails.BalanceQuantity = AddendumDetails.BalanceQuantity + Convert.ToInt32(License.balanceqty);
}
}
foreach (AddendumRoyaltySlab RoyaltySlab in AddendumDetails.AddendumDetailsRoyalty)
{
// Author Details Set
AddendumRoyaltySlab _AddendumRoyaltySlab = new AddendumRoyaltySlab();
_AddendumRoyaltySlab.ProductSubTypeId = RoyaltySlab.ProductSubTypeId;
_AddendumRoyaltySlab.copiesfrom = RoyaltySlab.copiesfrom;
_AddendumRoyaltySlab.copiesto = RoyaltySlab.copiesto;
_AddendumRoyaltySlab.percentage = RoyaltySlab.percentage;
_AddendumRoyaltySlab.Deactivate = "N";
_AddendumRoyaltySlab.EnteredBy = AddendumDetails.EnteredBy;
_AddendumRoyaltySlab.EntryDate = DateTime.Now;
_AddendumRoyaltySlab.ModifiedBy = null;
_AddendumRoyaltySlab.ModifiedDate = null;
_AddendumRoyaltySlab.DeactivateBy = null;
_AddendumRoyaltySlab.DeactivateDate = null;
_IAddendumRoyaltySlab.Add(_AddendumRoyaltySlab);
}
ACS.Core.Domain.Product.AddendumDetails _AddendumDetails = new ACS.Core.Domain.Product.AddendumDetails();
_AddendumDetails.LicenseId = AddendumDetails.LicenseId;
_AddendumDetails.ProductId = AddendumDetails.ProductId;
_AddendumDetails.AddendumDate = AddendumDetails.AddendumDate;
_AddendumDetails.AddendumType = AddendumDetails.AddendumType;
//_AddendumDetails.Periodofagreement = AddendumDetails.Periodofagreement;
_AddendumDetails.ExpiryDate = AddendumDetails.ExpiryDate;
_AddendumDetails.FirstImpressionWithinDate = AddendumDetails.FirstImpressionWithinDate;
_AddendumDetails.NoOfImpressions = AddendumDetails.NoOfImpressions;
_AddendumDetails.BalanceQuantityCarryForward = AddendumDetails.BalanceQuantityCarryForward;
_AddendumDetails.AddendumQuantity = AddendumDetails.AddendumQuantity;
_AddendumDetails.BalanceQuantity = AddendumDetails.BalanceQuantity;
_AddendumDetails.RoyaltyTerms = AddendumDetails.RoyaltyTerms;
_AddendumDetails.Remarks = AddendumDetails.Remarks;
_AddendumDetails.AddendumDetailsRoyalty = _IAddendumRoyaltySlab;
_AddendumDetails.Deactivate = "N";
_AddendumDetails.EnteredBy = AddendumDetails.EnteredBy;
_AddendumDetails.EntryDate = DateTime.Now;
_AddendumDetails.ModifiedBy = null;
_AddendumDetails.ModifiedDate = null;
_AddendumDetails.DeactivateBy = null;
_AddendumDetails.DeactivateDate = null;
AddendumId = _AddendumServices.InsertAddendumDetails(_AddendumDetails);
if (AddendumId > 0 && License.printquantitytype == "Number")
{
License.balanceqty = _AddendumDetails.BalanceQuantity;
License.ModifiedBy = AddendumDetails.EnteredBy;
License.ModifiedDate = DateTime.Now;
_ProductLicenseService.UpdateProductLicenseMaster(License);
}
// Addendum Details Set
ACS.Core.Domain.Product.ProductLicenseAddendumLink _ProductLicenseAddendumLink = new ACS.Core.Domain.Product.ProductLicenseAddendumLink();
_ProductLicenseAddendumLink.AddendumId = AddendumId;
_ProductLicenseAddendumLink.ProductId = AddendumDetails.ProductId;
_ProductLicenseAddendumLink.LicenseId = AddendumDetails.LicenseId;
_ProductLicenseAddendumLink.Active = "Y";
_ProductLicenseAddendumLink.Deactivate = "N";
_ProductLicenseAddendumLink.EnteredBy = AddendumDetails.EnteredBy;
_ProductLicenseAddendumLink.EntryDate = DateTime.Now;
_ProductLicenseAddendumLink.ModifiedBy = null;
_ProductLicenseAddendumLink.ModifiedDate = null;
_ProductLicenseAddendumLink.DeactivateBy = null;
_ProductLicenseAddendumLink.DeactivateDate = null;
_ProductLicenseService.InsertMultipleProductLink(_ProductLicenseAddendumLink);
IList <AddendumFileDetails> _IAddendumFileDetails = new List <AddendumFileDetails>();
foreach (AddendumFileDetails FileDetails in AddendumDetails.IAddendumFileDetails)
{
// Author Details Set
AddendumFileDetails _AddendumFileDetails = new AddendumFileDetails();
_AddendumFileDetails.AddendumId = AddendumId;
_AddendumFileDetails.LicenseId = FileDetails.LicenseId;
_AddendumFileDetails.FileName = FileDetails.FileName;
_AddendumFileDetails.UploadFileName = FileDetails.UploadFileName;
_AddendumFileDetails.Deactivate = "N";
_AddendumFileDetails.EnteredBy = AddendumDetails.EnteredBy;
_AddendumFileDetails.EntryDate = DateTime.Now;
_AddendumFileDetails.ModifiedBy = null;
_AddendumFileDetails.ModifiedDate = null;
_AddendumFileDetails.DeactivateBy = null;
_AddendumFileDetails.DeactivateDate = null;
//_IAddendumFileDetails.Add(_AddendumFileDetails);
_AddendumServices.InsertAddendumFileDetails(_AddendumFileDetails);
}
status = "OK";
return(Json(SerializeObj.SerializeObject(new { status, AddendumId })));
//return Json("OK");
}
public IHttpActionResult WebGetaOtherContractById(OtherContractMaster OtherContract)
{
int ImageBankId = 0;
OtherContractMaster _OtherContract = _OtherContractService.GetOtherContractMasterById(OtherContract);
var OtherContractList = new
{
Id = _OtherContract.Id,
partyname = _OtherContract.partyname,
natureofserviceid = _OtherContract.natureofserviceid,
natureofsubserviceid = _OtherContract.natureofsubserviceid,
Address = _OtherContract.Address,
CountryId = _OtherContract.CountryId,
OtherCountry = _OtherContract.OtherCountry,
Stateid = _OtherContract.Stateid,
OtherState = _OtherContract.OtherState,
Cityid = _OtherContract.Cityid,
OtherCity = _OtherContract.OtherCity,
Pincode = _OtherContract.Pincode,
Mobile = _OtherContract.Mobile,
Email = _OtherContract.Email,
PANNo = _OtherContract.PANNo,
Requestdate = _OtherContract.Requestdate,
ProjectTitle = _OtherContract.ProjectTitle,
ProjectISBN = _OtherContract.ProjectISBN,
Contracttypeid = _OtherContract.Contracttypeid,
// ContractDate = _OtherContract.ContractDate,
// Periodofagreement = _OtherContract.Periodofagreement,
// Expirydate = _OtherContract.Expirydate,
Territoryrightsid = _OtherContract.Territoryrightsid,
Payment = _OtherContract.Payment,
paymentperiodid = _OtherContract.paymentperiodid,
NatureOfWork = _OtherContract.NatureOfWork,
// divisionid = _OtherContract.divisionid,
ContractSignedByExecutiveid = _OtherContract.ContractSignedByExecutiveid,
Remarks = _OtherContract.Remarks,
PaymentAmount = _OtherContract.PaymentAmount,
CurrencyMasterId = _OtherContract.CurrencyMasterId,
};
// var OtherContractDivisionLink = _OtherContractDivisionLink.Table.Where(a => a.othercontractid == _OtherContract.Id && a.Deactivate == "N").ToList();
var OtherContractDivisionLink = (from OCDL in _OtherContractDivisionLink.Table.Where(a => a.Deactivate == "N")
join DM in _DivisionMaster.Table.Where(a => a.Deactivate == "N")
on OCDL.divisionid equals DM.Id
select new
{
divisionid = OCDL.divisionid,
divisionName = DM.divisionName,
othercontractid = OCDL.othercontractid
}
).Distinct().Where(a => a.othercontractid == _OtherContract.Id).ToList();
OtherContractImageBank _ContractImageBank = _OtherContractImageBank.Table.Where(a => a.othercontractid == _OtherContract.Id && a.Deactivate == "N").FirstOrDefault();
if (_ContractImageBank != null)
{
ImageBankId = _ContractImageBank.Id;
}
IList <VideoImageBank> ImageTypeOtherContact = _VideoImageBank.Table.Where(a => a.Deactivate == "N" && a.ImageBankId == ImageBankId && a.Type == "I").ToList();
IList <VideoImageBank> VideoTypeOtherContact = _VideoImageBank.Table.Where(a => a.Deactivate == "N" && a.ImageBankId == ImageBankId && a.Type == "V").ToList();
if (_ContractImageBank != null)
{
var _ContractImageBankList = new
{
Id = _ContractImageBank.Id,
Printrunquantity = _ContractImageBank.Printrunquantity,
PrintRights = _ContractImageBank.PrintRights,
electronicrights = _ContractImageBank.electronicrights,
ebookrights = _ContractImageBank.ebookrights,
cost = _ContractImageBank.cost,
currencyid = _ContractImageBank.currencyid,
restriction = _ContractImageBank.restriction,
othercontractid = _ContractImageBank.othercontractid,
};
}
Contract_Signed_By_Executive OtherContractDocuments = new Contract_Signed_By_Executive();
var documents = _OtherContractDocuments.Table.Where(a => a.othercontractid == _OtherContract.Id && a.Deactivate == "N").ToList();
OtherContractDocuments.DocumentIds = documents.Select(i => i.Id).ToArray();
OtherContractDocuments.Documentname = documents.Select(i => i.Documentname).ToArray();
foreach (var docs in documents)
{
OtherContractDocuments.documentfile = OtherContractDocuments.documentfile + docs.documentfile + ",";
}
OtherContractLink _OtherContractLintList = _OtherContractLink.Table.Where(a => a.othercontractid == _OtherContract.Id && a.Deactivate == "N").FirstOrDefault();
Contract_Signed_By_Executive OtherContractDocuments2 = new Contract_Signed_By_Executive();
if (_OtherContractLintList != null)
{
var OtherConractlinkData = new
{
Contractstatus = _OtherContractLintList.Contractstatus,
Signed_Contract_Sent_Date = _OtherContractLintList.SignedContractSentDate,
Signed_Contract_received_Date = _OtherContractLintList.SignedContractReceived_Date,
Cancellation_Date = _OtherContractLintList.CancellationDate,
Cancellation_Reason = _OtherContractLintList.Cancellation_Reason,
PendingRemarks = _OtherContractLintList.Remarks
};
var documents2 = _OtherContractLinkDocument.Table.Where(a => a.othercontractLinkid == _OtherContractLintList.Id && a.Deactivate == "N").ToList();
OtherContractDocuments2.DocumentlinkIds = documents2.Select(i => i.Id).ToArray();
OtherContractDocuments2.DocumentnameLink = documents2.Select(i => i.DocumentnameLink).ToArray();
foreach (var docs in documents2)
{
OtherContractDocuments2.documentfileLink = OtherContractDocuments2.documentfileLink + docs.documentfileLink + ",";
}
}
return(Json(SerializeObj.SerializeObject(new { _OtherContract, _ContractImageBank, OtherContractDocuments, _OtherContractLintList, OtherContractDocuments2, OtherContractDivisionLink, ImageTypeOtherContact, VideoTypeOtherContact })));
}
public IHttpActionResult InsertOtherContract(Contract_Signed_By_Executive OtherContract)
{
string status = "";
int OtherContractIdId = 0;
string OtherContactCode = string.Empty;
try
{
//if (status == "Y")
//{
if (OtherContract.Id == 0)
{
IList <ApplicationSetUp> _ApplicationSetUpList = _ApplicationSetUp.Table.Where(x => x.key == "Other Contract" && x.Deactivate == "N").ToList();
var OtherContractSuggesation = _ApplicationSetUpList.Select(Au => new
{
OtherContractValue = Au.keyValue,
Id = Au.Id
});
IList <ContractType> _ContractTypeList = _ContractType.Table.Where(x => x.Id == OtherContract.Contracttypeid && x.Deactivate == "N").ToList();
var ContractType = _ContractTypeList.Select(CT => new
{
ContractName = CT.ContractName
});
OtherContractMaster _OtherContract = new OtherContractMaster();
string stringTokens = ContractType.FirstOrDefault().ContractName;
string strVlaue = string.Empty;
string[] words;
if (stringTokens.Contains("-"))
{
words = stringTokens.Split('-');
}
else
{
words = stringTokens.Split(' ');
}
foreach (string word in words)
{
strVlaue += word.FirstOrDefault();
}
_OtherContract.othercontractcode = "OC" + strVlaue.ToString() + OtherContractSuggesation.FirstOrDefault().OtherContractValue;
_OtherContract.othercontractcode = _OtherContract.othercontractcode.ToString().ToUpper();
OtherContactCode = _OtherContract.othercontractcode.ToString().ToUpper();
_OtherContract.partyname = OtherContract.partyname;
_OtherContract.natureofserviceid = OtherContract.natureofserviceid;
_OtherContract.natureofsubserviceid = OtherContract.natureofsubserviceid;
_OtherContract.Address = OtherContract.Address;
_OtherContract.CountryId = OtherContract.CountryId;
_OtherContract.OtherCountry = OtherContract.OtherCountry;
_OtherContract.Stateid = OtherContract.Stateid;
_OtherContract.OtherState = OtherContract.OtherState;
_OtherContract.Cityid = OtherContract.Cityid;
_OtherContract.OtherCity = OtherContract.OtherCity;
_OtherContract.Pincode = OtherContract.Pincode;
_OtherContract.Mobile = OtherContract.Mobile;
_OtherContract.Email = OtherContract.Email;
_OtherContract.PANNo = OtherContract.PANNo;
_OtherContract.Requestdate = OtherContract.Requestdate;
_OtherContract.ProjectTitle = OtherContract.ProjectTitle;
_OtherContract.ProjectISBN = OtherContract.ProjectISBN;
_OtherContract.Contracttypeid = OtherContract.Contracttypeid;
// _OtherContract.ContractDate = OtherContract.ContractDate;
// _OtherContract.Periodofagreement = OtherContract.Periodofagreement;
// _OtherContract.Expirydate = OtherContract.Expirydate;
_OtherContract.Territoryrightsid = OtherContract.Territoryrightsid;
_OtherContract.Payment = OtherContract.Payment;
_OtherContract.paymentperiodid = OtherContract.paymentperiodid;
_OtherContract.NatureOfWork = OtherContract.NatureOfWork;
// _OtherContract.divisionid = OtherContract.divisionid;
_OtherContract.ContractSignedByExecutiveid = OtherContract.ContractSignedByExecutiveid;
_OtherContract.Remarks = OtherContract.Remarks;
_OtherContract.EnteredBy = OtherContract.EnteredBy;
_OtherContract.PaymentAmount = OtherContract.PaymentAmount;
_OtherContract.CurrencyMasterId = OtherContract.CurrencyMasterId;
OtherContractIdId = _OtherContractService.InsertOtherContract(_OtherContract);
if (OtherContractIdId != 0)
{
OtherContractDivisionLink DivisionLink = new OtherContractDivisionLink();
int k = 0;
foreach (var item in OtherContract.Division)
{
DivisionLink.othercontractid = OtherContractIdId;
DivisionLink.divisionid = item;
DivisionLink.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractDivisionLink(DivisionLink);
k++;
}
OtherContractDocuments _OtherContractDoc = new OtherContractDocuments();
string[] docurl = OtherContract.documentfile.Split(',');
int i = 0;
foreach (string doc in OtherContract.Documentname)
{
OtherContractDocuments Link = new OtherContractDocuments();
Link.othercontractid = OtherContractIdId;
Link.Documentname = doc;
Link.documentfile = docurl[i];
Link.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractDocumentsLinking(Link);
i++;
}
if (OtherContract.ForImageBank == "1")
{
/* Added by dheeraj Kumar sharma */
OtherContractImageBank _OtherContractImageBank = new OtherContractImageBank();
IList <VideoImageBank> ImageBankList = new List <VideoImageBank>();
if (OtherContract.VideoImageBank.Count > 0)
{
foreach (var obj in OtherContract.VideoImageBank)
{
VideoImageBank obj_VideoImageBank = new VideoImageBank();
obj_VideoImageBank.Type = obj.Type;
obj_VideoImageBank.ShortName = obj.ShortName;
obj_VideoImageBank.Fullname = obj.Fullname;
obj_VideoImageBank.CurrencyId = obj.CurrencyId;
obj_VideoImageBank.Cost = obj.Cost;
obj_VideoImageBank.Deactivate = "N";
obj_VideoImageBank.EnteredBy = OtherContract.EnteredBy;
obj_VideoImageBank.EntryDate = DateTime.Now;
ImageBankList.Add(obj_VideoImageBank);
}
}
_OtherContractImageBank.VideoImageBank = ImageBankList;
/*End by dheeraj*/
_OtherContractImageBank.Printrunquantity = OtherContract.Printrunquantity;
_OtherContractImageBank.PrintRights = OtherContract.PrintRights;
_OtherContractImageBank.electronicrights = OtherContract.electronicrights;
_OtherContractImageBank.ebookrights = OtherContract.ebookrights;
_OtherContractImageBank.cost = OtherContract.cost;
_OtherContractImageBank.currencyid = OtherContract.currencyid;
_OtherContractImageBank.restriction = OtherContract.restriction;
_OtherContractImageBank.othercontractid = OtherContractIdId;
_OtherContractImageBank.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractImageBank(_OtherContractImageBank);
}
}
OtherContractLink _OtherContractLink1 = new OtherContractLink();
_OtherContractLink1.Contractstatus = null;
_OtherContractLink1.SignedContractSentDate = null;
_OtherContractLink1.SignedContractReceived_Date = null;
_OtherContractLink1.CancellationDate = null;
_OtherContractLink1.Cancellation_Reason = null;
_OtherContractLink1.othercontractid = OtherContractIdId;
_OtherContractLink1.Status = "Pending";
_OtherContractLink1.EnteredBy = OtherContract.EnteredBy;
_OtherContractLink1.Remarks = OtherContract.PendingRemarks;
int OtherContractLinkIdId = _OtherContractService.InsertOtherContractLink(_OtherContractLink1);
ApplicationSetUp Mobj_ApplicationSetUp = new ApplicationSetUp();
Mobj_ApplicationSetUp.Id = OtherContractSuggesation.FirstOrDefault().Id;
ApplicationSetUp _ApplicationSetUpUpdate = _ApplicationSetUpService.GetApplicationSetUpById(Mobj_ApplicationSetUp);
_ApplicationSetUpUpdate.Id = OtherContractSuggesation.FirstOrDefault().Id;
int Value = Int32.Parse(OtherContractSuggesation.FirstOrDefault().OtherContractValue) + 1;
_ApplicationSetUpUpdate.keyValue = Value.ToString().PadLeft(4, '0');
_ApplicationSetUpUpdate.ModifiedBy = OtherContract.EnteredBy;
_ApplicationSetUpUpdate.ModifiedDate = DateTime.Now;
_ApplicationSetUpService.UpdateApplication(_ApplicationSetUpUpdate);
}
else
{
if (OtherContract.UpdateRight == "rt" || OtherContract.UpdateRight == "fc")
{
OtherContractLink mobj_OtherContractLink = _OtherContractLink.Table.Where(i => i.othercontractid == OtherContract.Id && i.Deactivate == "N").FirstOrDefault();
if (mobj_OtherContractLink != null)
{
mobj_OtherContractLink.Contractstatus = OtherContract.Contractstatus;
mobj_OtherContractLink.SignedContractSentDate = OtherContract.SignedContractSentDate;
mobj_OtherContractLink.SignedContractReceived_Date = OtherContract.SignedContractReceived_Date;
mobj_OtherContractLink.CancellationDate = OtherContract.CancellationDate;
mobj_OtherContractLink.Cancellation_Reason = OtherContract.Cancellation_Reason;
mobj_OtherContractLink.othercontractid = OtherContract.Id;
mobj_OtherContractLink.ModifiedBy = OtherContract.EnteredBy;
mobj_OtherContractLink.Status = OtherContract.Contractstatus;
mobj_OtherContractLink.Remarks = OtherContract.PendingRemarks;
mobj_OtherContractLink.AgreementDate = OtherContract.AgreementDate;
mobj_OtherContractLink.Effectivedate = OtherContract.Effectivedate;
//mobj_OtherContractLink.Contractperiodinmonth = OtherContract.Contractperiodinmonth;
mobj_OtherContractLink.Expirydate = OtherContract.Expirydate;
_OtherContractService.UpdateOtherContractLink(mobj_OtherContractLink);
OtherContractLinkDocument _OtherContractDocLink = new OtherContractLinkDocument();
string[] docurl1 = OtherContract.documentfileLink.Split(',');
int i = 0;
foreach (string doc in OtherContract.DocumentnameLink)
{
OtherContractLinkDocument Link = new OtherContractLinkDocument();
Link.othercontractLinkid = mobj_OtherContractLink.Id;
Link.DocumentnameLink = doc;
Link.documentfileLink = docurl1[i];
Link.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractDocumentsLinkingLink(Link);
i++;
}
}
}
else if (OtherContract.UpdateRight == "ad" || OtherContract.UpdateRight == "sa")
{
OtherContractMaster mobj_OtherDocument = _OtherContractService.GetOtherContractMasterId(OtherContract.Id);
mobj_OtherDocument.partyname = OtherContract.partyname;
mobj_OtherDocument.natureofserviceid = OtherContract.natureofserviceid;
mobj_OtherDocument.natureofsubserviceid = OtherContract.natureofsubserviceid;
mobj_OtherDocument.Address = OtherContract.Address;
mobj_OtherDocument.CountryId = OtherContract.CountryId;
mobj_OtherDocument.OtherCountry = OtherContract.OtherCountry;
mobj_OtherDocument.Stateid = OtherContract.Stateid;
mobj_OtherDocument.OtherState = OtherContract.OtherState;
mobj_OtherDocument.Cityid = OtherContract.Cityid;
mobj_OtherDocument.OtherCity = OtherContract.OtherCity;
mobj_OtherDocument.Pincode = OtherContract.Pincode;
mobj_OtherDocument.Mobile = OtherContract.Mobile;
mobj_OtherDocument.Email = OtherContract.Email;
mobj_OtherDocument.PANNo = OtherContract.PANNo;
mobj_OtherDocument.Requestdate = OtherContract.Requestdate;
mobj_OtherDocument.ProjectTitle = OtherContract.ProjectTitle;
mobj_OtherDocument.ProjectISBN = OtherContract.ProjectISBN;
mobj_OtherDocument.Contracttypeid = OtherContract.Contracttypeid;
// mobj_OtherDocument.ContractDate = OtherContract.ContractDate;
// mobj_OtherDocument.Periodofagreement = OtherContract.Periodofagreement;
// mobj_OtherDocument.Expirydate = OtherContract.Expirydate;
mobj_OtherDocument.Territoryrightsid = OtherContract.Territoryrightsid;
mobj_OtherDocument.Payment = OtherContract.Payment;
mobj_OtherDocument.paymentperiodid = OtherContract.paymentperiodid;
mobj_OtherDocument.NatureOfWork = OtherContract.NatureOfWork;
// mobj_OtherDocument.divisionid = OtherContract.divisionid;
mobj_OtherDocument.ContractSignedByExecutiveid = OtherContract.ContractSignedByExecutiveid;
mobj_OtherDocument.Remarks = OtherContract.Remarks;
mobj_OtherDocument.ModifiedBy = OtherContract.EnteredBy;
mobj_OtherDocument.PaymentAmount = OtherContract.PaymentAmount;
mobj_OtherDocument.CurrencyMasterId = OtherContract.CurrencyMasterId;
_OtherContractService.UpdateOtherContractMaster(mobj_OtherDocument);
_OtherContractService.DeleteOtherContractDivisionLink(OtherContract.Id, OtherContract.EnteredBy);
OtherContractDivisionLink DivisionLink = new OtherContractDivisionLink();
int k = 0;
foreach (var item in OtherContract.Division)
{
DivisionLink.othercontractid = OtherContract.Id;
DivisionLink.divisionid = item;
DivisionLink.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractDivisionLink(DivisionLink);
k++;
}
OtherContractImageBank mobj_OtherContractImageBank = _OtherContractImageBank.Table.Where(i => i.othercontractid == OtherContract.Id && i.Deactivate == "N").FirstOrDefault();
if (mobj_OtherContractImageBank != null)
{
_OtherContractService.DeleteVideoImageBankLink(mobj_OtherContractImageBank.Id, OtherContract.EnteredBy);
if (OtherContract.VideoImageBank.Count > 0)
{
int m = 0;
foreach (var obj in OtherContract.VideoImageBank)
{
VideoImageBank obj_VideoImageBank = new VideoImageBank();
obj_VideoImageBank.Type = obj.Type;
obj_VideoImageBank.ShortName = obj.ShortName;
obj_VideoImageBank.Fullname = obj.Fullname;
obj_VideoImageBank.CurrencyId = obj.CurrencyId;
obj_VideoImageBank.Cost = obj.Cost;
obj_VideoImageBank.ImageBankId = mobj_OtherContractImageBank.Id;
obj_VideoImageBank.EnteredBy = OtherContract.EnteredBy;
obj_VideoImageBank.EntryDate = DateTime.Now;
obj_VideoImageBank.Deactivate = "N";
_OtherContractService.InsertVideoImageBankLink(obj_VideoImageBank);
m++;
}
}
mobj_OtherContractImageBank.Printrunquantity = OtherContract.Printrunquantity;
mobj_OtherContractImageBank.PrintRights = OtherContract.PrintRights;
mobj_OtherContractImageBank.electronicrights = OtherContract.electronicrights;
mobj_OtherContractImageBank.ebookrights = OtherContract.ebookrights;
mobj_OtherContractImageBank.cost = OtherContract.cost;
mobj_OtherContractImageBank.currencyid = OtherContract.currencyid;
mobj_OtherContractImageBank.restriction = OtherContract.restriction;
mobj_OtherContractImageBank.othercontractid = OtherContract.Id;
mobj_OtherContractImageBank.ModifiedBy = OtherContract.EnteredBy;
_OtherContractService.UpdateOtherContractImageBank(mobj_OtherContractImageBank);
}
else if (OtherContract.ForImageBank == "1")
{
//OtherContractImageBank _OtherConImageBank = new OtherContractImageBank();
//_OtherConImageBank.Printrunquantity = OtherContract.Printrunquantity;
//_OtherConImageBank.PrintRights = OtherContract.PrintRights;
//_OtherConImageBank.electronicrights = OtherContract.electronicrights;
//_OtherConImageBank.ebookrights = OtherContract.ebookrights;
//_OtherConImageBank.cost = OtherContract.cost;
//_OtherConImageBank.currencyid = OtherContract.currencyid;
//_OtherConImageBank.restriction = OtherContract.restriction;
//_OtherConImageBank.othercontractid = OtherContract.Id;
//_OtherConImageBank.EnteredBy = OtherContract.EnteredBy;
//_OtherContractService.InsertOtherContractImageBank(_OtherConImageBank);
OtherContractImageBank _OtherConImageBank = new OtherContractImageBank();
IList <VideoImageBank> ImageBankList = new List <VideoImageBank>();
if (OtherContract.VideoImageBank.Count > 0)
{
foreach (var obj in OtherContract.VideoImageBank)
{
VideoImageBank obj_VideoImageBank = new VideoImageBank();
obj_VideoImageBank.Type = obj.Type;
obj_VideoImageBank.ShortName = obj.ShortName;
obj_VideoImageBank.Fullname = obj.Fullname;
obj_VideoImageBank.CurrencyId = obj.CurrencyId;
obj_VideoImageBank.Cost = obj.Cost;
obj_VideoImageBank.Deactivate = "N";
obj_VideoImageBank.EnteredBy = OtherContract.EnteredBy;
obj_VideoImageBank.EntryDate = DateTime.Now;
ImageBankList.Add(obj_VideoImageBank);
}
}
_OtherConImageBank.VideoImageBank = ImageBankList;
/*End by dheeraj*/
_OtherConImageBank.Printrunquantity = OtherContract.Printrunquantity;
_OtherConImageBank.PrintRights = OtherContract.PrintRights;
_OtherConImageBank.electronicrights = OtherContract.electronicrights;
_OtherConImageBank.ebookrights = OtherContract.ebookrights;
_OtherConImageBank.cost = OtherContract.cost;
_OtherConImageBank.currencyid = OtherContract.currencyid;
_OtherConImageBank.restriction = OtherContract.restriction;
_OtherConImageBank.othercontractid = OtherContract.Id;
_OtherConImageBank.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractImageBank(_OtherConImageBank);
}
OtherContractDocuments _OtherContractDoc = new OtherContractDocuments();
string[] docurl = OtherContract.documentfile.Split(',');
int j = 0;
foreach (string doc in OtherContract.Documentname)
{
OtherContractDocuments Link = new OtherContractDocuments();
Link.othercontractid = OtherContract.Id;
Link.Documentname = doc;
Link.documentfile = docurl[j];
Link.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractDocumentsLinking(Link);
j++;
}
OtherContractLink mobj_OtherContractLink = _OtherContractLink.Table.Where(i => i.othercontractid == OtherContract.Id && i.Deactivate == "N").FirstOrDefault();
if (mobj_OtherContractLink != null)
{
mobj_OtherContractLink.Contractstatus = OtherContract.Contractstatus;
mobj_OtherContractLink.SignedContractSentDate = OtherContract.SignedContractSentDate;
mobj_OtherContractLink.SignedContractReceived_Date = OtherContract.SignedContractReceived_Date;
mobj_OtherContractLink.CancellationDate = OtherContract.CancellationDate;
mobj_OtherContractLink.Cancellation_Reason = OtherContract.Cancellation_Reason;
mobj_OtherContractLink.othercontractid = OtherContract.Id;
mobj_OtherContractLink.ModifiedBy = OtherContract.EnteredBy;
mobj_OtherContractLink.Status = OtherContract.Contractstatus;
mobj_OtherContractLink.Remarks = OtherContract.PendingRemarks;
mobj_OtherContractLink.AgreementDate = OtherContract.AgreementDate;
mobj_OtherContractLink.Effectivedate = OtherContract.Effectivedate;
//mobj_OtherContractLink.Contractperiodinmonth = OtherContract.Contractperiodinmonth;
mobj_OtherContractLink.Expirydate = OtherContract.Expirydate;
_OtherContractService.UpdateOtherContractLink(mobj_OtherContractLink);
OtherContractLinkDocument _OtherContractDocLink = new OtherContractLinkDocument();
string[] docurl1 = OtherContract.documentfileLink.Split(',');
int i = 0;
foreach (string doc in OtherContract.DocumentnameLink)
{
OtherContractLinkDocument Link = new OtherContractLinkDocument();
Link.othercontractLinkid = mobj_OtherContractLink.Id;
Link.DocumentnameLink = doc;
Link.documentfileLink = docurl1[i];
Link.EnteredBy = OtherContract.EnteredBy;
_OtherContractService.InsertOtherContractDocumentsLinkingLink(Link);
i++;
}
}
}
//-------------------------------------------
OtherContractIdId = OtherContract.Id;
OtherContactCode = _OtherContractMaster.Table.Where(a => a.Id == OtherContract.Id).Select(b => b.othercontractcode).SingleOrDefault();
}
status = _localizationService.GetResource("Master.API.Success.Message");
}
catch (ACSException ex)
{
status = ex.ToString();
}
catch (Exception ex)
{
status = ex.ToString();
}
return(Json(SerializeObj.SerializeObject(new { status, OtherContactCode, OtherContractIdId })));
}
public IHttpActionResult getSubsidiaryRights(int Id)
{
SubsidiaryRightsMaster _SubsidiaryRightsMaster = _subsidiaryRightsService.GetSubsidiaryRightsById(Id);
return(Json(SerializeObj.SerializeObject(new { _SubsidiaryRightsMaster })));
}
public IHttpActionResult getAddendumDetailsByAddendumId(ACS.Core.Domain.Product.AddendumDetails AddendumDetails)
{
ACS.Core.Domain.Product.AddendumDetails AddendumDetails1 = _AddendumServices.GetAddendumDetailsById(AddendumDetails);
return(Json(SerializeObj.SerializeObject(new { AddendumDetails1 })));
}
public IHttpActionResult UpdateAddendumDetails(ACS.Core.Domain.Product.AddendumDetails AddendumDetails)
{
string status = string.Empty;
if (AddendumDetails.Id > 0)
{
ACS.Core.Domain.Product.AddendumDetails mobj_AddendumDetails = _AddendumServices.GetAddendumDetailsById(AddendumDetails);
List <AddendumRoyaltySlab> _IOldAddendumDetailsRoyalty = mobj_AddendumDetails.AddendumDetailsRoyalty.ToList();
List <AddendumFileDetails> _IOldAddendumFileDetails = mobj_AddendumDetails.IAddendumFileDetails.ToList();
foreach (AddendumRoyaltySlab Royality in _IOldAddendumDetailsRoyalty)
{
_AddendumServices.DeleteAddendumRoyaltySlab(Royality);
}
foreach (AddendumFileDetails FileDetails in _IOldAddendumFileDetails)
{
_AddendumServices.DeleteAddendumFileDetails(FileDetails);
}
IList <AddendumRoyaltySlab> _IAddendumRoyaltySlab = new List <AddendumRoyaltySlab>();
foreach (AddendumRoyaltySlab RoyaltySlab in AddendumDetails.AddendumDetailsRoyalty)
{
// Author Details Set
AddendumRoyaltySlab _AddendumRoyaltySlab = new AddendumRoyaltySlab();
_AddendumRoyaltySlab.ProductSubTypeId = RoyaltySlab.ProductSubTypeId;
_AddendumRoyaltySlab.copiesfrom = RoyaltySlab.copiesfrom;
_AddendumRoyaltySlab.copiesto = RoyaltySlab.copiesto;
_AddendumRoyaltySlab.percentage = RoyaltySlab.percentage;
_AddendumRoyaltySlab.Deactivate = "N";
_AddendumRoyaltySlab.EnteredBy = AddendumDetails.EnteredBy;
_AddendumRoyaltySlab.EntryDate = DateTime.Now;
_AddendumRoyaltySlab.ModifiedBy = null;
_AddendumRoyaltySlab.ModifiedDate = null;
_AddendumRoyaltySlab.DeactivateBy = null;
_AddendumRoyaltySlab.DeactivateDate = null;
_IAddendumRoyaltySlab.Add(_AddendumRoyaltySlab);
}
IList <AddendumFileDetails> _IAddendumFileDetails = new List <AddendumFileDetails>();
foreach (AddendumFileDetails FileDetails in AddendumDetails.IAddendumFileDetails)
{
// Author Details Set
AddendumFileDetails _AddendumFileDetails = new AddendumFileDetails();
_AddendumFileDetails.AddendumId = FileDetails.AddendumId;
_AddendumFileDetails.LicenseId = FileDetails.LicenseId;
_AddendumFileDetails.FileName = FileDetails.FileName;
_AddendumFileDetails.UploadFileName = FileDetails.UploadFileName;
_AddendumFileDetails.Deactivate = "N";
_AddendumFileDetails.EnteredBy = AddendumDetails.EnteredBy;
_AddendumFileDetails.EntryDate = DateTime.Now;
_AddendumFileDetails.ModifiedBy = null;
_AddendumFileDetails.ModifiedDate = null;
_AddendumFileDetails.DeactivateBy = null;
_AddendumFileDetails.DeactivateDate = null;
_IAddendumFileDetails.Add(_AddendumFileDetails);
}
ACS.Core.Domain.Product.AddendumDetails _AddendumDetails = new ACS.Core.Domain.Product.AddendumDetails();
mobj_AddendumDetails.AddendumDate = AddendumDetails.AddendumDate;
mobj_AddendumDetails.AddendumType = AddendumDetails.AddendumType;
//mobj_AddendumDetails.Periodofagreement = AddendumDetails.Periodofagreement;
mobj_AddendumDetails.ExpiryDate = AddendumDetails.ExpiryDate;
mobj_AddendumDetails.FirstImpressionWithinDate = AddendumDetails.FirstImpressionWithinDate;
mobj_AddendumDetails.NoOfImpressions = AddendumDetails.NoOfImpressions;
mobj_AddendumDetails.BalanceQuantityCarryForward = AddendumDetails.BalanceQuantityCarryForward;
mobj_AddendumDetails.AddendumQuantity = AddendumDetails.AddendumQuantity;
mobj_AddendumDetails.RoyaltyTerms = AddendumDetails.RoyaltyTerms;
mobj_AddendumDetails.Remarks = AddendumDetails.Remarks;
mobj_AddendumDetails.AddendumDetailsRoyalty = _IAddendumRoyaltySlab;
mobj_AddendumDetails.IAddendumFileDetails = _IAddendumFileDetails;
mobj_AddendumDetails.ModifiedBy = AddendumDetails.EnteredBy;
mobj_AddendumDetails.ModifiedDate = DateTime.Now;
_AddendumServices.UpdateAddendumDetails(_AddendumDetails);
}
status = "OK";
return(Json(SerializeObj.SerializeObject(new { status })));
//return Json("OK");
}