public async Task <int> AddStrategyProposal(StrategyProposal StrategyProposal)
{
db.StrategyProposals.Add(StrategyProposal);
int result = await db.SaveChangesAsync();
return(result);
}
public async Task <string> UpdateStrategyProposal(StrategyProposal strategyproposal)
{
string mailSent = "";
string MailSubject = "Strategy Proposal";
string MailBody = "";
if (strategyproposal.Status == "Approved")
{
MailBody = "Project Strategy Proposal is Approved for <ProjectName>.";
}
if (strategyproposal.Status == "Rejected")
{
MailBody = "Project Strategy Proposal is Rejected for <ProjectName> by following reason <br/><br/>" + strategyproposal.Remarks;
}
StrategyProposal existingstrategyproposal = StrategyProposalRepository.GetStrategyProposals().SingleOrDefault(t => t.StrategyProposalId == strategyproposal.StrategyProposalId);
if (existingstrategyproposal == default(StrategyProposal))
{
return("strategyproposal doesn't exist");
}
int updatestrategyproposal = await StrategyProposalRepository.UpdateStrategyProposal(strategyproposal);
if (updatestrategyproposal > 0)
{
mailSent = Mail.SendMail(strategyproposal.ProjectId, strategyproposal.Status, MailSubject, MailBody);
}
return(updatestrategyproposal == 0 ? "Successfully updated StrategyProposal" : "Updation failed");
}
public IHttpActionResult UpdateStrategyProposal(StrategyProposal strategyproposal)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
Task.Run(async() => await _strategyproposal.UpdateStrategyProposal(strategyproposal));
return(Ok());
}
public async Task <int> DeleteStrategyProposal(int strategyproposalid)
{
StrategyProposal StrategyProposal = await FetchbyStrategyProposalId(strategyproposalid);
db.StrategyProposals.Remove(StrategyProposal);
int result = await db.SaveChangesAsync();
return(result);
}
public async Task <int> UpdateStrategyProposal(StrategyProposal StrategyProposal)
{
StrategyProposal existingStrategyProposal = await FetchbyStrategyProposalId(StrategyProposal.StrategyProposalId);
db.Entry(existingStrategyProposal).State = EntityState.Detached;
db.Entry(StrategyProposal).State = EntityState.Modified;
int result = await db.SaveChangesAsync();
return(result);
}
public ProjectStrategyProposalModel GetNewStrategyProposal(int projectid)
{
StrategyProposal strategyproposal = default(StrategyProposal);
Project project = ProjectRepository.Projects.SingleOrDefault(p => p.ProjectId == projectid);
Group group = GroupRepository.Groups.SingleOrDefault(g => g.GroupId == project.GroupId);
//promoterlist = PromoterRepository.GetPromoters().Where(p => p.ProjectID == projectid);
ProjectStrategyProposalModel ptmodel = new ProjectStrategyProposalModel(project, strategyproposal, group);
return(ptmodel);
}
public ProjectStrategyProposalModel(Project project, StrategyProposal strategyproposal, Group group)
{
ProjectId = project.ProjectId;
ProjectGroup = group.GroupName;
ProjectName = project.ProjectName;
ProjectLocation = project.PlantLocation;
ProjectCapacityAC = project.Capacity_AC;
ProjectCapacityDC = project.Capacity_DC;
ProjectTotalCost = project.TotalCost;
ProjectEquity = project.TotalEquity;
ProjectDebt = project.TotalDebt;
ProjectCreditRating = project.CreditCompRating;
ProjectIRR = project.IRR;
ProjectMinDSCR = project.MinDSCR;
ProjectAvgDSCR = project.AvgDSCR;
ProjectDiscom = project.Discom;
ProjectTarrif = project.Tariff;
ProjectSCOD = project.SCOD;
strategyProposal = strategyproposal;
}
public async Task <string> AddStrategyProposal(StrategyProposal strategyproposal)
{
string mailSent = "";
string MailSubject = "Strategy Proposal";
string MailBody = "";
strategyproposal.Status = "Created";
if (strategyproposal.Status == "Created")
{
MailBody = "Project Strategy Proposal is created for <ProjectName>. Please review and approve /suggest.";
}
int inserstrategyproposal = await StrategyProposalRepository.AddStrategyProposal(strategyproposal);
if (inserstrategyproposal > 0)
{
mailSent = Mail.SendMail(strategyproposal.ProjectId, strategyproposal.Status, MailSubject, MailBody);
}
return(inserstrategyproposal > 0 ? "Successfully added StrategyProposal" : "Insertion failed");
}
public async Task <StrategyProposal> FetchbyStrategyProposalId(int strategyproposalid)
{
StrategyProposal StrategyProposal = await db.StrategyProposals.FindAsync(strategyproposalid);
return(StrategyProposal);
}
