public JsonResult submitchanges(objsubmit obj)
{
if (obj.update != null)
{
foreach (var item in obj.update)
{
if (item.Sysid == 0)
{
Configure_RateCard row = new Configure_RateCard();
row.FisYear = item.FisYear;
row.FisMonth = item.FisMonth;
row.MonthlyProjectLaborRate = item.MonthlyProjectLaborRate;
row.MidOrg = item.MidOrg;
db.Configure_RateCard.Add(row);
db.SaveChanges();
}
else
{
Configure_RateCard row = db.Configure_RateCard.Single(x => x.Sysid == item.Sysid);
row.FisYear = item.FisYear;
row.FisMonth = item.FisMonth;
row.MonthlyProjectLaborRate = item.MonthlyProjectLaborRate;
row.MidOrg = item.MidOrg;
db.SaveChanges();
}
}
}
if (obj.delete != null)
{
foreach (var item in obj.delete)
{
if (item.Sysid != 0)
{
Configure_RateCard row = db.Configure_RateCard.Single(x => x.Sysid == item.Sysid);
db.Configure_RateCard.Remove(row);
db.SaveChanges();
}
}
}
return(Json("data has been updated successfully", JsonRequestBehavior.AllowGet));
}
public JsonResult submitchanges(objsubmit obj)
{
if (obj.update != null)
{
foreach (var item in obj.update)
{
if (item.Sysid == 0)
{
Master_ProjectChargeBack row = new Master_ProjectChargeBack();
row.MidOrg = item.MidOrg;
row.Site = item.Site;
row.ProjectCharging = item.ProjectCharging;
db.Master_ProjectChargeBack.Add(row);
db.SaveChanges();
}
else
{
Master_ProjectChargeBack row = db.Master_ProjectChargeBack.Single(x => x.Sysid == item.Sysid);
row.MidOrg = item.MidOrg;
row.Site = item.Site;
row.ProjectCharging = item.ProjectCharging;
db.SaveChanges();
}
}
}
if (obj.delete != null)
{
foreach (var item in obj.delete)
{
if (item.Sysid != 0)
{
Master_ProjectChargeBack row = db.Master_ProjectChargeBack.Single(x => x.Sysid == item.Sysid);
db.Master_ProjectChargeBack.Remove(row);
db.SaveChanges();
}
}
}
return(Json("data has been updated successfully", JsonRequestBehavior.AllowGet));
}
public JsonResult submitchanges(objsubmit obj)
{
if (obj.update != null)
{
foreach (var item in obj.update)
{
if (item.Sysid == 0)
{
Master_AOPProject row = new Master_AOPProject();
row.Name = item.Name;
db.Master_AOPProject.Add(row);
db.SaveChanges();
}
else
{
Master_AOPProject row = db.Master_AOPProject.Single(x => x.Sysid == item.Sysid);
row.Name = item.Name;
db.SaveChanges();
}
}
}
if (obj.delete != null)
{
foreach (var item in obj.delete)
{
if (item.Sysid != 0)
{
Master_AOPProject row = db.Master_AOPProject.Single(x => x.Sysid == item.Sysid);
db.Master_AOPProject.Remove(row);
db.SaveChanges();
}
}
}
return(Json("data has been updated successfully", JsonRequestBehavior.AllowGet));
}
public JsonResult submitchanges(objsubmit obj)
{
string userID = Convert.ToString(Session["userid"]);
if (obj.update != null)
{
var projectdata = obj.update;
var subquery = projectdata.Select(y => new { ProjectNumber = y.ProjectNumber, ProjectName = y.ProjectNumber }).ToList();
var query = subquery.GroupBy(x => x.ProjectNumber)
.Where(g => g.Count() > 1)
.Select(y => new { Element = y.Key, Counter = y.Count() })
.ToList();
if (projectdata.Select(x => x.ProjectNumber).Distinct().Count() != projectdata.Count)
{
string strDuplicateString = "";
foreach (var item in query)
{
strDuplicateString = strDuplicateString + "," + item.Element;
}
return(Json(new { Message = strDuplicateString.Substring(1) + " - Project number already used, please enter different project number", responseCode = 404 }, JsonRequestBehavior.AllowGet));
}
else
{
foreach (var item in obj.update)
{
if (item.ProjectID == 0)
{
Configure_Project row = new Configure_Project();
row.ProjectName = item.ProjectName;
row.ProjectNumber = item.ProjectNumber;
row.PMNetworkID = item.PMNetworkID;
row.PMName = GetUserFromLdap(item.PMNetworkID);
row.ProjectCategory = item.ProjectCategory;
row.Status = item.Status;
row.WBSElement = item.WBSElement;
row.CapitalExpenditureWBS = item.CapitalExpenditureWBS;
row.GPSProjectNumber = item.GPSProjectNumber;
row.Program = item.Program;
row.BusinessUnit = item.BusinessUnit;
row.PeriodBurdenExpense = item.PeriodBurdenExpense;
row.SettlementCostCenter = item.SettlementCostCenter;
row.SettlementCostCenterName = item.SettlementCostCenterName;
row.SettlemnetSummary = item.SettlemnetSummary;
row.EndingBusinessUnit = item.EndingBusinessUnit;
row.FundingSource = item.FundingSource;
row.SourceCard = item.SourceCard;
row.InPLAN = item.InPLAN;
row.Function = item.Function;
row.CapitalGRPType = item.CapitalGRPType;
row.Funded = item.Funded;
row.PercentFunded = item.PercentFunded;
row.PCTPropabiltyFunded = item.PCTPropabiltyFunded;
row.CreatedBy = userID;
row.CreatedOn = DateTime.Now.Date;
db.Configure_Project.Add(row);
db.SaveChanges();
}
else
{
Configure_Project row = db.Configure_Project.Single(x => x.ProjectID == item.ProjectID);
row.ProjectName = item.ProjectName;
row.ProjectNumber = item.ProjectNumber;
row.PMNetworkID = item.PMNetworkID;
row.PMName = GetUserFromLdap(item.PMNetworkID);
row.ProjectCategory = item.ProjectCategory;
row.Status = item.Status;
row.WBSElement = item.WBSElement;
row.CapitalExpenditureWBS = item.CapitalExpenditureWBS;
row.GPSProjectNumber = item.GPSProjectNumber;
row.Program = item.Program;
row.BusinessUnit = item.BusinessUnit;
row.PeriodBurdenExpense = item.PeriodBurdenExpense;
row.SettlementCostCenter = item.SettlementCostCenter;
row.SettlementCostCenterName = item.SettlementCostCenterName;
row.SettlemnetSummary = item.SettlemnetSummary;
row.EndingBusinessUnit = item.EndingBusinessUnit;
row.FundingSource = item.FundingSource;
row.SourceCard = item.SourceCard;
row.InPLAN = item.InPLAN;
row.Function = item.Function;
row.CapitalGRPType = item.CapitalGRPType;
row.Funded = item.Funded;
row.PercentFunded = item.PercentFunded;
row.PCTPropabiltyFunded = item.PCTPropabiltyFunded;
row.CreatedBy = item.CreatedBy;
row.CreatedOn = item.CreatedOn;
row.ModifiedBy = userID;
row.ModifiedOn = DateTime.Now.Date;
db.SaveChanges();
}
}
}
}
if (obj.delete != null)
{
foreach (var item in obj.delete)
{
db.SP_DeleteProjectData(item.ProjectID);
}
}
return(Json(new { Message = " data has been updated successfully", responseCode = 200 }, JsonRequestBehavior.AllowGet));
}
