public void InsertPublishingCompany(PublishingCompanyMaster _publishingCompany)
{
_publishingCompany.Deactivate = "N";
_publishingCompany.EnteredBy = 10;
_publishingCompany.EntryDate = DateTime.Now;
_publishingCompany.ModifiedBy = null;
_publishingCompany.ModifiedDate = null;
_publishingCompany.DeactivateBy = null;
_publishingCompany.DeactivateDate = null;
_publishingCompanyRepository.Insert(_publishingCompany);
}
public IHttpActionResult InsertPublishingCompany(PublishingCompanyMaster _publishingCompany)
{
string status = string.Empty;
try
{
status = _publishingCompanyService.DuplicityCheck(_publishingCompany);
if (status == "Y")
{
if (_publishingCompany.Id == 0)
{
_publishingCompanyService.InsertPublishingCompany(_publishingCompany);
}
else
{
PublishingCompanyMaster objPublishingCompany = _publishingCompanyService.GetPublishingCompanyById(_publishingCompany);
objPublishingCompany.CompanyName = _publishingCompany.CompanyName;
objPublishingCompany.ContactPerson = _publishingCompany.ContactPerson;
objPublishingCompany.Address = _publishingCompany.Address;
objPublishingCompany.Email = _publishingCompany.Email;
objPublishingCompany.Phone = _publishingCompany.Phone;
objPublishingCompany.Mobile = _publishingCompany.Mobile;
objPublishingCompany.Website = _publishingCompany.Website;
objPublishingCompany.CountryId = _publishingCompany.CountryId;
objPublishingCompany.OtherCountry = _publishingCompany.OtherCountry;
objPublishingCompany.Stateid = _publishingCompany.Stateid;
objPublishingCompany.OtherState = _publishingCompany.OtherState;
objPublishingCompany.Cityid = _publishingCompany.Cityid;
objPublishingCompany.OtherCity = _publishingCompany.OtherCity;
objPublishingCompany.ModifiedBy = _publishingCompany.EnteredBy;
objPublishingCompany.ModifiedDate = System.DateTime.Now;
_publishingCompanyService.UpdatePublishingCompany(objPublishingCompany);
}
status = _localizationService.GetResource("Master.API.Success.Message");
}
else
{
status = "Duplicate";
}
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
public string DuplicityCheck(PublishingCompanyMaster publishingCompanyMaster)
{
var dupes = _publishingCompanyRepository.Table.Where(x => x.CompanyName == publishingCompanyMaster.CompanyName && x.Cityid == publishingCompanyMaster.Cityid &&
x.Deactivate == "N" &&
(publishingCompanyMaster.Id != 0 ? x.Id : 0) != (publishingCompanyMaster.Id != 0 ? publishingCompanyMaster.Id : 1)).FirstOrDefault();
if (dupes != null)
{
return("N");
}
else
{
return("Y");
}
}
public IHttpActionResult GetImprintListByPublishingCompany(PublishingCompanyMaster PublishingCompany)
{
var ImprintList = (from I in _ImprintRepository.Table.Where(a => a.Deactivate == "N")
join pub in _PublishingCompanyRepository.Table.Where(a => a.Deactivate == "N")
on I.PublishingCompanyId equals pub.Id into pubGroup
from S in pubGroup.DefaultIfEmpty()
where I.PublishingCompanyId == PublishingCompany.Id
select new
{
Id = I.Id,
ImprintName = I.ImprintName,
PublishingCompanyCode = S.PublishingCompanyCode,
Deactivate = I.Deactivate,
}).Distinct().Where(a => a.Deactivate == "N" && a.PublishingCompanyCode != "PCM0002").OrderBy(o => o.ImprintName);
return(Json(ImprintList));
}
public IHttpActionResult PublishingCompanyDelete(PublishingCompanyMaster _publishingCompany)
{
string status = string.Empty;
try
{
PublishingCompanyMaster publishingCompany = _publishingCompanyService.GetPublishingCompanyById(_publishingCompany);
publishingCompany.Deactivate = "Y";
publishingCompany.ModifiedBy = _publishingCompany.EnteredBy;
publishingCompany.ModifiedDate = DateTime.Now;
_publishingCompanyService.UpdatePublishingCompany(publishingCompany);
status = "OK";
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
public PublishingCompanyMaster GetPublishingCompanyById(PublishingCompanyMaster publishingCompany)
{
return(_publishingCompanyRepository.Table.Where(i => i.Id == publishingCompany.Id).FirstOrDefault());
}
public void DeletePublishingCompany(PublishingCompanyMaster publishingCompany)
{
_publishingCompanyRepository.Delete(publishingCompany);
}
public void UpdatePublishingCompany(PublishingCompanyMaster publishingCompany)
{
_publishingCompanyRepository.Update(publishingCompany);
}
/// <summary>
/// create by Vishal Verma on 12/05/2016
/// Gets AllPub Center List By Publishing CompanyId
/// </summary>
/// <param name="showDeactivated">A value indicating whether to show hidden records</param>
/// <returns>PubCenter List</returns>
public virtual IList <PubCenterMaster> GetPubCenterByCompanyIdList(PublishingCompanyMaster PublishingCompany)
{
return(_PubCenterRepository.Table.Where(a => a.Deactivate == "N" && a.PublishingCompanyid == PublishingCompany.Id).OrderBy(c => c.CenterName).ToList());
}
public IHttpActionResult PublishingCompany(PublishingCompanyMaster _publishingCompany)
{
return(Json(_publishingCompanyService.GetPublishingCompanyById(_publishingCompany)));
}
public IHttpActionResult InsertPublishingCompany(PublishingCompanyMaster _publishingCompany)
{
string status = string.Empty;
try
{
status = _publishingCompanyService.DuplicityCheck(_publishingCompany);
if (status == "Y")
{
if (_publishingCompany.Id == 0)
{
IList <ApplicationSetUp> _mobjApplicationSetUpList = _mobjApplicationSetUpRepository.Table.Where(x => x.key == "PublishingCompanyCode" && x.Deactivate == "N").ToList();
var PublishingCompanySuggesation = _mobjApplicationSetUpList.Select(P => new
{
PublishingCompanyCodeValue = P.keyValue,
Id = P.Id
});
_publishingCompany.PublishingCompanyCode = "PCM" + PublishingCompanySuggesation.FirstOrDefault().PublishingCompanyCodeValue;
_publishingCompany.PublishingCompanyCode = _publishingCompany.PublishingCompanyCode.ToString().ToUpper();
_publishingCompanyService.InsertPublishingCompany(_publishingCompany);
ApplicationSetUp mobjApplicationSetUp = new ApplicationSetUp();
mobjApplicationSetUp.Id = PublishingCompanySuggesation.FirstOrDefault().Id;
ApplicationSetUp _ApplicationSetUpUpdate = _mobjApplicationSetUpService.GetApplicationSetUpById(mobjApplicationSetUp);
_ApplicationSetUpUpdate.Id = PublishingCompanySuggesation.FirstOrDefault().Id;
int Value = Int32.Parse(PublishingCompanySuggesation.FirstOrDefault().PublishingCompanyCodeValue) + 1;
_ApplicationSetUpUpdate.keyValue = Value.ToString().PadLeft(4, '0');
_ApplicationSetUpUpdate.ModifiedBy = _publishingCompany.EnteredBy;
_ApplicationSetUpUpdate.ModifiedDate = DateTime.Now;
_mobjApplicationSetUpService.UpdateApplication(_ApplicationSetUpUpdate);
}
else
{
PublishingCompanyMaster objPublishingCompany = _publishingCompanyService.GetPublishingCompanyById(_publishingCompany);
objPublishingCompany.CompanyName = _publishingCompany.CompanyName;
objPublishingCompany.ContactPerson = _publishingCompany.ContactPerson;
objPublishingCompany.Address = _publishingCompany.Address;
objPublishingCompany.Email = _publishingCompany.Email;
objPublishingCompany.Phone = _publishingCompany.Phone;
objPublishingCompany.Mobile = _publishingCompany.Mobile;
objPublishingCompany.Website = _publishingCompany.Website;
objPublishingCompany.CountryId = _publishingCompany.CountryId;
objPublishingCompany.OtherCountry = _publishingCompany.OtherCountry;
objPublishingCompany.Stateid = _publishingCompany.Stateid;
objPublishingCompany.OtherState = _publishingCompany.OtherState;
objPublishingCompany.Cityid = _publishingCompany.Cityid;
objPublishingCompany.OtherCity = _publishingCompany.OtherCity;
objPublishingCompany.Pincode = _publishingCompany.Pincode;
objPublishingCompany.ModifiedBy = _publishingCompany.EnteredBy;
objPublishingCompany.ModifiedDate = System.DateTime.Now;
_publishingCompanyService.UpdatePublishingCompany(objPublishingCompany);
}
status = _localizationService.GetResource("Master.API.Success.Message");
}
else
{
status = "Duplicate";
}
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
/// <summary>
/// Description :GetPublishingCompanyList
/// Function Name :GetPublishingCompanyList
/// OutPut parameter :Json Object
/// Create Date : 12 May 2016
/// Author Name : Vishal Verma
/// </summary>
/// <remarks>
///**************************** Modification History *************************************************************
/// Sr No: Date Modified by Tracker Description
///*****************************************************************************************************************
///*****************************************************************************************************************
///
///</remarks>
///
public IHttpActionResult PubCenterByCompanyIdList(PublishingCompanyMaster PublishingCompany)
{
return(Json(_CommonListService.GetPubCenterByCompanyIdList(PublishingCompany).ToList()));
}
