//Adding Record into Replica table
public void AddOldAMDetails(FormCollection _formcollectionobj)
{
var QuaterObj = _formcollectionobj.AllKeys.Where(i => i.Contains("_FC"));
bool IsActive = true;
int SalesForceCastID = 0;
//if (Convert.ToInt16(_formcollectionobj["DealStageId"]) == 4 && !string.IsNullOrEmpty(_formcollectionobj["OpportunityName"])
// /* && Convert.ToInt16(_formcollectionobj["ProjectId"]) != 0*/)
//{
// IsActive = false;
//}
//else
//{
// IsActive = true;
//}
Random rnd = new Random();
string rndmvalue = string.Empty;
for (int x = 0; x <= 15; x++)
{
long salesForceCastIDRndm = rnd.Next(1, 999999999);
var value = financetoolentities.OpportunityForecastBySales.Where(i => i.SalesForceGuid == salesForceCastIDRndm).ToList();
rndmvalue = Convert.ToString(salesForceCastIDRndm);
if (value.Count > 0)
{
continue;
}
else
{
break;
}
}
OpportunityLatestInsert = financetoolentities.Usp_InsertOpportunityLatest(Convert.ToInt16(_formcollectionobj["OpportunityID"]), _formcollectionobj["OpportunityName"], Convert.ToInt32(_formcollectionobj["DealStageId"]), Convert.ToInt32(_formcollectionobj["sowvalue"]), Convert.ToInt16(_formcollectionobj["AMId"]), Convert.ToInt16(_formcollectionobj["CustomerId"]), _formcollectionobj["ProgramName"], Convert.ToInt16(_formcollectionobj["ServiceLineId"]), Convert.ToInt16(_formcollectionobj["ProductGroupId"]), Convert.ToInt16(_formcollectionobj["DBBLDuId"]), decimal.Parse(_formcollectionobj["TCV"]), decimal.Parse(_formcollectionobj["acv"]), Convert.ToInt16(_formcollectionobj["sowvalue"]), Convert.ToDateTime(_formcollectionobj["BillingStratDate"]), _formcollectionobj["Note_Comment"], Session["UserName"].ToString(), System.DateTime.Now, Session["UserName"].ToString(), System.DateTime.Now, 0, IsActive,
long.Parse(rndmvalue), Convert.ToInt16(_formcollectionobj["DuId"]), Convert.ToInt16(_formcollectionobj["LobId"]),
Convert.ToDecimal(_formcollectionobj["SowStatusValue"]), Convert.ToInt16(Session["UserId"]), Convert.ToInt16(Session["RoleId"]), false, false, _formcollectionobj["OpportunityCategory"]);
List <Quater> QuaterList = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
foreach (var dbquater in QuaterList)
{
foreach (var Quarter in QuaterObj)
{
if (Quarter == dbquater.QuaterName + "_FC")
{
OpportunityForecastBySale opportunityForecastBySale = new OpportunityForecastBySale();
opportunityForecastBySale.QuaterID = dbquater.QuaterID;
opportunityForecastBySale.forecastvaluebysales = string.IsNullOrEmpty(_formcollectionobj[Quarter].ToString()) == true ? 0 : decimal.Parse(_formcollectionobj[Quarter]);
opportunityForecastBySale.SalesForceGuid = long.Parse(rndmvalue);
opportunityForecastBySale.Createdby = Session["UserName"].ToString();
opportunityForecastBySale.Createddate = System.DateTime.Now;
opportunityForecastBySale.Modifiedby = Session["UserName"].ToString();
opportunityForecastBySale.ModifiedDate = System.DateTime.Now;
financetoolentities.OpportunityForecastBySales.Add(opportunityForecastBySale);
opportunityForecastBySaleInsert = financetoolentities.SaveChanges();
SalesForceCastID = opportunityForecastBySale.SalesForceCastID;
}
}
}
}
public string Create([Bind(Exclude = "ProjectID")] FinaceTool.Models.ProjectTemp projecttemp)
{
string msg;
if (projecttemp.OpportunityName != 0 && projecttemp.SOWStatus != 0)
{
Project project = new Project();
project.Createddate = System.DateTime.Now;
project.IsActive = true;
project.SowStatusID = projecttemp.SOWStatus;
project.OpportunityID = projecttemp.OpportunityName;
project.Createdby = Session["UserName"].ToString();
project.Modifiedby = Session["UserName"].ToString();
project.ProjectName = projecttemp.ProjectName;
project.poavilable = projecttemp.poavilable;
project.pobalance = projecttemp.pobalance;
project.Note = projecttemp.Note;
project.ProjectCode = projecttemp.ProjectCode;
db.Projects.Add(project);
db.SaveChanges();
int i = db.Usp_Update_Opportunity_IsMapped(projecttemp.OpportunityName);
// GetOpportunityNames();
msg = "Saved Successfully";
}
else
{
msg = "Opportunity Name Should provide to create a Project";
}
return(msg);
}
public string Create([Bind(Exclude = "ServiceLineID")] ServiceLine serviceLine)
{
string msg;
if (ModelState.IsValid)
{
serviceLine.Createdby = Session["UserName"].ToString();
serviceLine.Modifiedby = Session["UserName"].ToString();
db.ServiceLines.Add(serviceLine);
db.SaveChanges();
}
msg = "Saved Successfully";
return(msg);
}
public string Create([Bind(Exclude = "CustomerID")] customer customerec)
{
string msg;
if (ModelState.IsValid)
{
customerec.Createdby = Session["UserName"].ToString();
customerec.Modifiedby = Session["UserName"].ToString();
db.customers.Add(customerec);
db.SaveChanges();
}
msg = "Saved Successfully";
return(msg);
}
public string Create([Bind(Exclude = "ProductGroupID")] ProductGroup productrec)
{
string msg;
if (ModelState.IsValid)
{
productrec.Createdby = Session["UserName"].ToString();
productrec.Modifiedby = Session["UserName"].ToString();
db.ProductGroups.Add(productrec);
db.SaveChanges();
}
msg = "Saved Successfully";
return(msg);
}
public string Create([Bind(Exclude = "RoleID")] Role rolerec)
{
string msg;
if (ModelState.IsValid)
{
rolerec.Createdby = Session["UserName"].ToString();
rolerec.Modifiedby = Session["UserName"].ToString();
db.Roles.Add(rolerec);
db.SaveChanges();
}
msg = "Role added Successfully";
return(msg);
}
public string Create([Bind(Exclude = "SDUID")] FinaceTool.Models.SDUTemp sdurec)
{
string msg;
SDU sdu = new SDU();
if (sdurec.LOBName != 0)
{
sdu.LOBID = sdurec.LOBName;
sdu.Createdby = Session["UserName"].ToString();
sdu.Modifiedby = Session["UserName"].ToString();
db.SDUs.Add(sdu);
db.SaveChanges();
}
msg = "SDU added Successfully";
return(msg);
}
public ActionResult PostCustomerRecord(customer customerrec)
{
FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities();
FinanceToolEntities2.customers.Add(customerrec);
FinanceToolEntities2.SaveChanges();
return(View());
}
public ActionResult AddRole(Role role)
{
FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities();
FinanceToolEntities2.Roles.Add(role);
FinanceToolEntities2.SaveChanges();
return(View("GetRole"));
}
public ActionResult AddLOB(LOB lob)
{
FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities();
lob.Createddate = System.DateTime.Now;
FinanceToolEntities2.LOBs.Add(lob);
FinanceToolEntities2.SaveChanges();
return(View("GetLOB"));
}
public ActionResult AddCustomer(customer customerrec)
{
FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities();
customerrec.Createddate = System.DateTime.Now;
FinanceToolEntities2.customers.Add(customerrec);
FinanceToolEntities2.SaveChanges();
return(View("AddCustomer"));
}
public ActionResult AddSDU(SDU sdu)
{
if (ModelState.IsValid)
{
sdu.Createddate = System.DateTime.Now;
FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities();
FinanceToolEntities2.SDUs.Add(sdu);
FinanceToolEntities2.SaveChanges();
}
return(View("GetSDU"));
}
public string Create([Bind(Exclude = "UserID")] FinaceTool.Models.UserTemp userrec)
{
string rolename = Session["RoleName"].ToString();
string msg;
User user = new User();
if (userrec.RoleName != 0)
{
user.RoleID = userrec.RoleName;
user.Createdby = rolename;
user.Modifiedby = rolename;
user.Createddate = System.DateTime.Now;
user.Password = userrec.Password;
user.ISActive = userrec.ISActive;
db.Users.Add(user);
db.SaveChanges();
}
msg = "Saved Successfully";
return(msg);
}
public string Create([Bind(Exclude = "DUID")] FinaceTool.Models.DUTemp dutemp)
{
string msg;
if (dutemp.AMName != 0 && dutemp.SDUName != 0)
{
DU Dbdu = new DU();
Dbdu.AMID = dutemp.AMName;
Dbdu.SDUID = dutemp.SDUName;
Dbdu.DUName = dutemp.DUName;
Dbdu.DUHeadID = Convert.ToInt16(dutemp.DUHeadName);
Dbdu.Createdby = Session["UserName"].ToString();
Dbdu.Modifiedby = Session["UserName"].ToString();
Dbdu.Createddate = System.DateTime.Now;
Dbdu.IsActive = true;
db.DUs.Add(Dbdu);
db.SaveChanges();
}
msg = "Saved Successfully";
return(msg);
}
public ActionResult UpdateDUHData(FormCollection formcollection)
{
var UiFCQuaterobj = formcollection.AllKeys.Where(i => i.Contains("_FC"));
var UiActQuaterobj = formcollection.AllKeys.Where(i => i.Contains("_AC"));
int ProjectId = Convert.ToInt32(formcollection["ProjectID"]);
string projectname = string.IsNullOrEmpty(formcollection["hdnProjectName"]) ? formcollection["ProjectName"] : formcollection["hdnProjectName"];
string OpportunityName = string.IsNullOrEmpty(formcollection["hdnOpportunityName"]) ? formcollection["OpportunityName"] : formcollection["hdnOpportunityName"];
int OpportunityId = Convert.ToInt16(formcollection["OpportunityID"]);
int DealStageID = 0;
decimal? TCV;
decimal? ACV;
DateTime?BillingStratDate;
string Note = string.Empty;
string CreatedBy = string.Empty;
int SalesForceCastID = 0;
bool? IsActive = true;
long? SalesForceGuid;
decimal? SowStatusValue;
bool? IsMapped;
string OpportunityCategory = string.Empty;
if (!string.IsNullOrEmpty(formcollection["OpportunityID"].ToString()))
{
var opportunityresult = financetoolentities.Opportunities.Where(i => i.OpportunityID == OpportunityId && i.IsUpdated == false).SingleOrDefault();
var opportunitylatestresult = financetoolentities.Opportunity_Latest
.SingleOrDefault(b => b.OpportunityID == OpportunityId && b.IsUpdated == false);
if (opportunityresult != null)
{
financetoolentities.Usp_UpdateOpportunity(opportunityresult.OpportunityID);
TCV = opportunityresult.TCV;
ACV = opportunityresult.acv;
BillingStratDate = opportunityresult.BillingStratDate;
Note = opportunityresult.Note;
CreatedBy = opportunityresult.Createdby;
SalesForceCastID = opportunityresult.SalesForceCastID;
SalesForceGuid = opportunityresult.SalesForceGuid;
SowStatusValue = opportunityresult.SowStatusValue;
IsMapped = opportunityresult.IsMapped;
OpportunityCategory = opportunityresult.OpportunityCategory;
if (projectname != "Please Select Project" && !string.IsNullOrEmpty(OpportunityId.ToString()))
{
// IsActive = false;
DealStageID = 4;
IsMapped = true;
}
else
{
// IsActive = true;
DealStageID = Convert.ToInt16(formcollection["dealstageId"]);
IsMapped = false;
}
}
else
{
financetoolentities.Usp_UpdateOpportunityLatest(opportunitylatestresult.OpportunityID);
TCV = opportunitylatestresult.TCV;
ACV = opportunitylatestresult.acv;
BillingStratDate = opportunitylatestresult.BillingStratDate;
Note = opportunitylatestresult.Note;
CreatedBy = opportunitylatestresult.Createdby;
SalesForceCastID = opportunitylatestresult.SalesForceCastID;
SalesForceGuid = opportunitylatestresult.SalesForceGuid;
SowStatusValue = opportunitylatestresult.SowStatusValue;
IsMapped = opportunitylatestresult.IsMapped;
OpportunityCategory = opportunitylatestresult.OpportunityCategory;
if (projectname != "Please Select Project" && !string.IsNullOrEmpty(OpportunityId.ToString()))
{
//IsActive = false;
DealStageID = 4;
IsMapped = true;
}
else
{
// IsActive = true;
DealStageID = Convert.ToInt16(formcollection["dealstageId"]);
IsMapped = false;
}
}
financetoolentities.Usp_InsertOpportunityLatest(Convert.ToInt16(formcollection["OpportunityID"]), OpportunityName,
DealStageID, Convert.ToInt16(formcollection["SowStatus"]), Convert.ToInt16(formcollection["AMID"]),
Convert.ToInt16(formcollection["selectedcustomerId"]), formcollection["ProgramName"], Convert.ToInt16(formcollection["ServiceLineID"]),
Convert.ToInt16(formcollection["ProductGroupID"]), Convert.ToInt16(formcollection["DBBLDUID"]), TCV,
ACV, Convert.ToInt16(formcollection["SowStatus"]), BillingStratDate,
Note, CreatedBy, System.DateTime.Now, Session["UserName"].ToString(), System.DateTime.Now, SalesForceCastID,
IsActive, SalesForceGuid, Convert.ToInt16(formcollection["DUID"]), Convert.ToInt16(formcollection["LOBID"]),
SowStatusValue, Convert.ToInt16(Session["UserId"]), Convert.ToInt16(Session["RoleId"]), IsMapped, false,
OpportunityCategory);
financetoolentities.SaveChanges();
}
var myACTQuaterList = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList();
var myFCQuaterList = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
foreach (var quarters in myACTQuaterList)
{
var actresult = financetoolentities.ProjectActualByDUHs
.Where(i => i.OpportunityID == OpportunityId && i.QuaterID == quarters.QuaterID).Where(i => i.IsNew == true).SingleOrDefault();
if (actresult != null)
{
if (quarters.QuaterID == actresult.QuaterID && !string.IsNullOrEmpty(formcollection[quarters.QuaterName + "_AC"]))
{
//making old records as o
actresult.IsNew = false;
financetoolentities.SaveChanges();
//Added new records
ProjectActualByDUH _projactobj = new ProjectActualByDUH();
_projactobj.Createdby = Session["UserName"].ToString();
_projactobj.actualvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_AC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_AC"]);
_projactobj.OpportunityID = OpportunityId;
_projactobj.Createddate = System.DateTime.Now;
_projactobj.Modifiedby = Session["UserName"].ToString();
_projactobj.ModifiedDate = System.DateTime.Now;
_projactobj.QuaterID = quarters.QuaterID;
_projactobj.IsNew = true;
financetoolentities.ProjectActualByDUHs.Add(_projactobj);
financetoolentities.SaveChanges();
}
}
else
{
ProjectActualByDUH _projactobj = new ProjectActualByDUH();
_projactobj.Createdby = Session["UserName"].ToString();
_projactobj.actualvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_AC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_AC"]);
_projactobj.OpportunityID = OpportunityId;
_projactobj.Createddate = System.DateTime.Now;
_projactobj.Modifiedby = Session["UserName"].ToString();
_projactobj.ModifiedDate = System.DateTime.Now;
_projactobj.QuaterID = quarters.QuaterID;
_projactobj.IsNew = true;
financetoolentities.ProjectActualByDUHs.Add(_projactobj);
financetoolentities.SaveChanges();
}
}
foreach (var quarters in myFCQuaterList)
{
var fcresult = financetoolentities.ProjectForecastByDUHs
.Where(i => i.OpportunityID == OpportunityId && i.QuaterID == quarters.QuaterID).Where(i => i.IsNew == true).SingleOrDefault();
if (fcresult != null)
{
if (quarters.QuaterID == fcresult.QuaterID && !string.IsNullOrEmpty(formcollection[quarters.QuaterName + "_FC"].ToString()))
{
//Old forecast values are becoming null
fcresult.IsNew = false;
financetoolentities.SaveChanges();
//Adding new records
ProjectForecastByDUH _projfcobj = new ProjectForecastByDUH();
_projfcobj.Createdby = Session["UserName"].ToString();
_projfcobj.forecastvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_FC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_FC"]);
_projfcobj.OpportunityID = OpportunityId;
_projfcobj.Createddate = System.DateTime.Now;
_projfcobj.Modifiedby = Session["UserName"].ToString();
_projfcobj.ModifiedDate = System.DateTime.Now;
_projfcobj.QuaterID = quarters.QuaterID;
_projfcobj.IsNew = true;
financetoolentities.ProjectForecastByDUHs.Add(_projfcobj);
financetoolentities.SaveChanges();
}
}
else
{
ProjectForecastByDUH _projfcobj = new ProjectForecastByDUH();
_projfcobj.Createdby = Session["UserName"].ToString();
_projfcobj.forecastvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_FC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_FC"]);
_projfcobj.OpportunityID = OpportunityId;
_projfcobj.Createddate = System.DateTime.Now;
_projfcobj.Modifiedby = Session["UserName"].ToString();
_projfcobj.ModifiedDate = System.DateTime.Now;
_projfcobj.QuaterID = quarters.QuaterID;
_projfcobj.IsNew = true;
financetoolentities.ProjectForecastByDUHs.Add(_projfcobj);
financetoolentities.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
