//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 ActionResult AddAMDetails(FormCollection _formcollectionobj)
{
var QuaterObj = _formcollectionobj.AllKeys.Where(i => i.Contains("txt"));
int SalesForceCastID = 0;
Opportunity _Opportunityobj = new Opportunity();
_Opportunityobj.DealStageID = Convert.ToInt32(_formcollectionobj["DealStageId"]);
_Opportunityobj.Createddate = System.DateTime.Now;
_Opportunityobj.acv = decimal.Parse(_formcollectionobj["acv"]);
_Opportunityobj.AMID = Convert.ToInt16(_formcollectionobj["AMId"]);
_Opportunityobj.DBBLDUID = string.IsNullOrEmpty(_formcollectionobj["DBBLDuId"]) == true ? 0 : Convert.ToInt16(_formcollectionobj["DBBLDuId"]);
_Opportunityobj.BillingStratDate = Convert.ToDateTime(_formcollectionobj["BillingStratDate"]);
_Opportunityobj.OpportunityID = Convert.ToInt16(_formcollectionobj["OpportunityID"]);
_Opportunityobj.OpportunityName = _formcollectionobj["OpportunityName"];
_Opportunityobj.ProductGroupID = Convert.ToInt16(_formcollectionobj["ProductGroupId"]);
_Opportunityobj.ProgramName = _formcollectionobj["ProgramName"];
_Opportunityobj.CustomerID = Convert.ToInt16(_formcollectionobj["CustomerId"]);
_Opportunityobj.ServiceLineID = Convert.ToInt16(_formcollectionobj["ServiceLineId"]);
_Opportunityobj.sowvalue = Convert.ToInt16(_formcollectionobj["SowStatusId"]);
_Opportunityobj.TCV = decimal.Parse(_formcollectionobj["TCV"]);
_Opportunityobj.Note = _formcollectionobj["Note_Comment"];
_Opportunityobj.Createdby = Session["UserName"].ToString();
_Opportunityobj.Createddate = System.DateTime.Now;
_Opportunityobj.Modifiedby = Session["UserName"].ToString();
_Opportunityobj.ModifiedDate = System.DateTime.Now;
_Opportunityobj.SowStatusValue = decimal.Parse(_formcollectionobj["SowStatusValue"]);
_Opportunityobj.OpportunityCategory = _formcollectionobj["OpportunityCategory"];
//if (Convert.ToInt16(_formcollectionobj["DealStageId"]) == 4 && !string.IsNullOrEmpty(_formcollectionobj["OpportunityName"])
// /*&& Convert.ToInt16(_formcollectionobj["ProjectId"]) != 0*/)
//{
_Opportunityobj.IsActive = true;
// }
//else
//{
// _Opportunityobj.IsActive = true;
//}
//if(Convert.ToInt16(_formcollectionobj["ProjectId"]) != 0)
//{
// _Opportunityobj.IsMapped = true;
//}
//else
//{
// _Opportunityobj.IsMapped = false;
//}
_Opportunityobj.IsMapped = false;
_Opportunityobj.DUID = Convert.ToInt16(_formcollectionobj["DuId"]);
_Opportunityobj.LobId = Convert.ToInt16(_formcollectionobj["LobId"]);
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.SalesForceCastID == salesForceCastIDRndm).ToList();
rndmvalue = Convert.ToString(salesForceCastIDRndm);
if (value.Count > 0)
{
continue;
}
else
{
break;
}
}
List <Quater> QuaterList = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
foreach (var dbquater in QuaterList)
{
foreach (var Quarter in QuaterObj)
{
if (Quarter.Remove(0, 3).ToString() == dbquater.QuaterName + "_FC ($K)")
{
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);
financetoolentities.SaveChanges();
SalesForceCastID = opportunityForecastBySale.SalesForceCastID;
}
}
}
_Opportunityobj.SalesForceGuid = long.Parse(rndmvalue);
_Opportunityobj.SalesForceCastID = Convert.ToInt16(SalesForceCastID);
financetoolentities.Opportunities.Add(_Opportunityobj);
financetoolentities.SaveChanges();
return(View("DisplayAmDetails", Display()));
}
