public async Task <ServiceResponce <List <GetSubscriptionHeadDto> > > AddSubscriptionHead(AddSubscriptionHeadDto newsubscriptionhead)
{
ServiceResponce <List <GetSubscriptionHeadDto> > serviceResponse = new ServiceResponce <List <GetSubscriptionHeadDto> >();
if (await ValidateSubscriptionExists(newsubscriptionhead.CompanyId) == false)
{
SubscriptionHead subscriptionhead = _mapper.Map <SubscriptionHead>(newsubscriptionhead);
subscriptionhead.StartDate = DateTime.Now.Date;
subscriptionhead.IsActive = true;
subscriptionhead.CreatedOn = DateTime.Now;
await _dataContext.SubscriptionHeads.AddAsync(subscriptionhead);
await _dataContext.SaveChangesAsync();
List <SubscriptionDetail> SubscriptionDetaillist = newsubscriptionhead.AddSubscriptionDetailDtoList.Select(c => _mapper.Map <SubscriptionDetail>(c)).ToList();
//foreach(SubscriptionDetail detail in SubscriptionDetaillist )
//{
// detail.SubscriptionHeadId = subscriptionhead.SubscriptionHeadId;
// detail.CompanyId = newsubscriptionhead.CompanyId;
// detail.CurrencyCode = newsubscriptionhead.CurrencyCode;
// detail.Total = detail.CalculatedAppAmount + detail.CalculatedGSTAmount;
// detail.IsActive = true;
// detail.CreatedOn = DateTime.Now;
//}
SubscriptionDetaillist.ForEach(detail =>
{
detail.SubscriptionHeadId = subscriptionhead.SubscriptionHeadId;
detail.CompanyId = newsubscriptionhead.CompanyId;
detail.CurrencyCode = newsubscriptionhead.CurrencyCode;
detail.Total = detail.CalculatedAppAmount + detail.CalculatedGSTAmount;
detail.IsActive = true;
detail.CreatedOn = DateTime.Now;
});
decimal TotalAppAmount = SubscriptionDetaillist.Sum(x => x.CalculatedAppAmount);
decimal TotalAppGstAmount = SubscriptionDetaillist.Sum(x => x.CalculatedGSTAmount);
SubscriptionHead subscriptionhead1 = await _dataContext.SubscriptionHeads.FirstOrDefaultAsync(c => c.SubscriptionHeadId == subscriptionhead.SubscriptionHeadId && c.IsActive == true);
subscriptionhead1.TotalAppAmount = TotalAppAmount;
subscriptionhead1.TotalAppGstAmount = TotalAppGstAmount;
await _dataContext.SubscriptionDetails.AddRangeAsync(SubscriptionDetaillist);
_dataContext.SubscriptionHeads.Update(subscriptionhead1);
await _dataContext.SaveChangesAsync();
serviceResponse.Data = await _dataContext.SubscriptionHeads.Where(x => x.IsActive == true).Select(c => _mapper.Map <GetSubscriptionHeadDto>(c)).ToListAsync();
}
else
{
serviceResponse.Success = false;
serviceResponse.Message = "Already Exists";
}
return(serviceResponse);
}
public async Task <bool> ValidateSubscriptionExists(int CompanyId)
{
bool status = false;
SubscriptionHead subscriptionhead = await _dataContext.SubscriptionHeads.FirstOrDefaultAsync(c => c.CompanyId == CompanyId && c.IsActive == true);
if (subscriptionhead != null)
{
status = true;
}
return(status);
}
public async Task <ServiceResponce <GetSubscriptionHeadDto> > GetSubscriptionHead(int ID)
{
ServiceResponce <GetSubscriptionHeadDto> serviceResponce = new ServiceResponce <GetSubscriptionHeadDto>();
SubscriptionHead subscriptionhead = await _dataContext.SubscriptionHeads.FirstOrDefaultAsync(c => c.SubscriptionHeadId == ID && c.IsActive == true);
if (subscriptionhead != null)
{
serviceResponce.Data = _mapper.Map <GetSubscriptionHeadDto>(subscriptionhead);
}
else
{
serviceResponce.Success = false;
serviceResponce.Message = "No Record Found";
}
return(serviceResponce);
}
public async Task <ServiceResponce <List <GetSubscriptionHeadDto> > > DeleteSubscriptionHead(int ID)
{
ServiceResponce <List <GetSubscriptionHeadDto> > serviceResponce = new ServiceResponce <List <GetSubscriptionHeadDto> >();
try
{
SubscriptionHead subscriptionhead = await _dataContext.SubscriptionHeads.FirstAsync(c => c.SubscriptionHeadId == ID);
subscriptionhead.IsActive = false;
subscriptionhead.LastModifiedon = DateTime.Now;
_dataContext.SubscriptionHeads.Update(subscriptionhead);
await _dataContext.SaveChangesAsync();
serviceResponce.Data = await(_dataContext.SubscriptionHeads.Where(x => x.IsActive == true).Select(c => _mapper.Map <GetSubscriptionHeadDto>(c))).ToListAsync();
}
catch (Exception e)
{
serviceResponce.Success = false;
serviceResponce.Message = e.Message;
}
return(serviceResponce);
}
public async Task <ServiceResponce <GetSubscriptionHeadDto> > UpdateSubscriptionHead(UpdatedSubscriptionHeadDto updatedSubscriptionHead)
{
ServiceResponce <GetSubscriptionHeadDto> serviceResponce = new ServiceResponce <GetSubscriptionHeadDto>();
try
{
SubscriptionHead subscriptionhead = await _dataContext.SubscriptionHeads.OrderByDescending(c => c.SubscriptionHeadId).FirstOrDefaultAsync(c => c.SubscriptionHeadId == updatedSubscriptionHead.SubscriptionHeadId && c.IsActive == true);
if (subscriptionhead.StartDate.ToString("yyyyMMdd") != DateTime.Now.ToString("yyyyMMdd"))
{
subscriptionhead.EndDate = DateTime.Now.AddDays(-1).Date;
}
else
{
//subscriptionhead.FullName = updatedSubscriptionHead.FullName;
//subscriptionhead.Email = updatedSubscriptionHead.Email;
subscriptionhead.IsActive = false;
//subscriptionhead.AppRate = updatedSubscriptionHead.AppRate;
//subscriptionhead.AppGst = updatedSubscriptionHead.AppGst;
}
subscriptionhead.LastModifiedBy = updatedSubscriptionHead.LastModifiedBy;
subscriptionhead.LastModifiedon = DateTime.Now;
_dataContext.SubscriptionHeads.Update(subscriptionhead);
await _dataContext.SaveChangesAsync();
///add new start
//if (subscriptionhead.StartDate.ToString("yyyyMMdd") != DateTime.Now.ToString("yyyyMMdd"))
//{
AddSubscriptionHeadDto newsubscriptionhead = new AddSubscriptionHeadDto();
newsubscriptionhead.CompanyId = subscriptionhead.CompanyId;
newsubscriptionhead.CurrencyCode = subscriptionhead.CurrencyCode;
newsubscriptionhead.FullName = updatedSubscriptionHead.FullName;
newsubscriptionhead.Email = updatedSubscriptionHead.Email;
newsubscriptionhead.PlatformCount = updatedSubscriptionHead.PlatformCount;
newsubscriptionhead.TotalPlatformAmount = updatedSubscriptionHead.TotalPlatformAmount;
newsubscriptionhead.TotalPlatformGstAmount = updatedSubscriptionHead.TotalPlatformGstAmount;
newsubscriptionhead.CreatedBy = updatedSubscriptionHead.LastModifiedBy;
//await AddSubscriptionHead(newsubscriptionhead);
SubscriptionHead subscriptionheadnew = _mapper.Map <SubscriptionHead>(newsubscriptionhead);
subscriptionheadnew.StartDate = DateTime.Now.Date;
subscriptionheadnew.IsActive = true;
subscriptionheadnew.CreatedOn = DateTime.Now;
await _dataContext.SubscriptionHeads.AddAsync(subscriptionheadnew);
await _dataContext.SaveChangesAsync();
List <SubscriptionDetail> SubscriptionDetaillist = updatedSubscriptionHead.AddSubscriptionDetailDtoList.Select(c => _mapper.Map <SubscriptionDetail>(c)).ToList();
SubscriptionDetaillist.ForEach(detail =>
{
detail.SubscriptionHeadId = subscriptionheadnew.SubscriptionHeadId;
detail.CompanyId = subscriptionheadnew.CompanyId;
detail.CurrencyCode = subscriptionheadnew.CurrencyCode;
detail.Total = detail.CalculatedAppAmount + detail.CalculatedGSTAmount;
detail.IsActive = true;
detail.CreatedOn = DateTime.Now;
});
decimal TotalAppAmount = SubscriptionDetaillist.Sum(x => x.CalculatedAppAmount);
decimal TotalAppGstAmount = SubscriptionDetaillist.Sum(x => x.CalculatedGSTAmount);
SubscriptionHead subscriptionhead1 = await _dataContext.SubscriptionHeads.FirstOrDefaultAsync(c => c.SubscriptionHeadId == subscriptionheadnew.SubscriptionHeadId && c.IsActive == true);
subscriptionhead1.TotalAppAmount = TotalAppAmount;
subscriptionhead1.TotalAppGstAmount = TotalAppGstAmount;
await _dataContext.SubscriptionDetails.AddRangeAsync(SubscriptionDetaillist);
_dataContext.SubscriptionHeads.Update(subscriptionhead1);
await _dataContext.SaveChangesAsync();
serviceResponce.Data = _mapper.Map <GetSubscriptionHeadDto>(subscriptionhead1);
//}
//else
//{
// ///add new end
// serviceResponce.Data = _mapper.Map<GetSubscriptionHeadDto>(subscriptionhead);
//}
}
catch (Exception e)
{
serviceResponce.Success = false;
serviceResponce.Message = e.Message;
}
return(serviceResponce);
}