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)); }