public ActionResult AddBudget(SearchModel search) { ViewBag.Terms = Terms(false, false, false); ViewBag.Services = Services(null, false); BudgetModel budgget = new BudgetModel(); budgget.CompanyId = search.CompanyId; budgget.CompanyName = search.CompanyName; budgget.AX = search.AX; budgget.IsActive = search.IsActive; budgget.DisplayName = search.DisplayName; budgget.ContactPerson = search.ContactPerson; budgget.CompanyHandle = search.CompanyHandle; //Session["CompanyId"] = budgget.CompanyId; //Session["CompanyName"] = budgget.CompanyName; //Session["Ax"] = budgget.AX; //Session["IsActive"] = budgget.IsActive; //Session["DisplayName"] = budgget.DisplayName; //Session["ContactPerson"] = budgget.ContactPerson; //Session["CompanyHandle"] = budgget.CompanyHandle; return View(budgget); }
public ActionResult AddBudget(BudgetModel budget) { ViewBag.Terms = Terms(false, false, false); ViewBag.Services = Services(null, false); try { //if (ModelState.IsValid) //{ budget.CompanyId = (int?)Session["CompanyId"]; budget.CompanyName = (string)Session["CompanyName"]; budget.AX = (string)Session["Ax"]; budget.IsActive = (bool)Session["IsActive"]; budget.DisplayName = (string)Session["DisplayName"]; budget.ContactPerson = (string)Session["ContactPerson"]; budget.CompanyHandle = (string)Session["CompanyHandle"]; budget.Type = "NEW"; if (budget.Terms == "Recurring") { budget.IsRecurring = true; budget.IsRequireNoticeToCharge = false; } else if (budget.Terms == "NonRecurring") { budget.IsRecurring = false; budget.IsRequireNoticeToCharge = false; } else { budget.IsRecurring = true; budget.IsRequireNoticeToCharge = true; } BusinessLayer.SaveBudget(budget); // ModelState.Clear(); ViewBag.Success = "Budget saved successfully.."; //return View(); return RedirectToAction("GetBudget", "Home", new { budget.CompanyId, budget.CompanyName, budget.AX, budget.DisplayName, budget.ContactPerson, budget.CompanyHandle }); //} } catch (Exception ex) { ModelState.AddModelError("", ex.Message); } return View(budget); }
public static IEnumerable<BudgetModel> SearchCompany(SearchModel search) { List<BudgetModel> list = new List<BudgetModel>(); using (SqlConnection dbCon = ConnectToDb(DBConnString)) { SqlCommand cmdGetCompany = new SqlCommand(); cmdGetCompany.Connection = dbCon; cmdGetCompany.CommandType = System.Data.CommandType.StoredProcedure; //cmdGetCompany.CommandText = "usp_GetCompanyDetails"; cmdGetCompany.CommandText = "usp_companySearchv3"; SqlParameter paramCompanyId = new SqlParameter("companyID", search.CompanyId); SqlParameter paramCompanyName = new SqlParameter("companyName", search.CompanyName); //SqlParameter paramAreacode = new SqlParameter("areaCode", search.AreaCodes); //SqlParameter paramAgreement = new SqlParameter("agreement", search.AgreementNumber); SqlParameter paramAx = new SqlParameter("ax", search.AX); SqlParameter paramInsertion = new SqlParameter("insertionOrderId", search.InsertionOrderId); cmdGetCompany.Parameters.Add(paramCompanyId); cmdGetCompany.Parameters.Add(paramCompanyName); //cmdGetCompany.Parameters.Add(paramAreacode); // cmdGetCompany.Parameters.Add(paramAgreement); cmdGetCompany.Parameters.Add(paramAx); cmdGetCompany.Parameters.Add(paramInsertion); DataTable dtResults = new DataTable(); SqlDataReader drResults = cmdGetCompany.ExecuteReader(); dtResults.Load(drResults); foreach (DataRow row in dtResults.Rows) { int? cid = 0; if (!string.IsNullOrEmpty(row["CompanyID"].ToString())) { cid = Convert.ToInt32(row["CompanyID"]); } BudgetModel s = new BudgetModel { // CompanyId = row[""], CompanyId = cid, CompanyName = row["companyName"].ToString(), AX = row["AbNumber"].ToString(), InsertionOrderId = row["insertionOrderId"].ToString(), DisplayName = row["displayName"].ToString(), CompanyHandle = row["companyHandle"].ToString(), ContactPerson = row["contactPerson"].ToString() //AgreementNumber = row["agreementNumber"].ToString(), // AreaCodes = row["Area Code"].ToString() }; list.Add(s); } return list; } }
public static List<BudgetModel> GetBudget(string companyid) { List<BudgetModel> list = new List<BudgetModel>(); using (SqlConnection dbCon = ConnectToDb(DBConnString)) { SqlCommand cmdGetCompany = new SqlCommand(); cmdGetCompany.Connection = dbCon; cmdGetCompany.CommandType = System.Data.CommandType.StoredProcedure; cmdGetCompany.CommandText = "usp_GetCompanyBudget"; SqlParameter paramCompanyId = new SqlParameter("companyID", companyid); cmdGetCompany.Parameters.Add(paramCompanyId); DataTable dtResults = new DataTable(); SqlDataReader drResults = cmdGetCompany.ExecuteReader(); dtResults.Load(drResults); foreach (DataRow row in dtResults.Rows) { int? cid = null; int? sid = null; int? dcharge = null; DateTime? sdate = null; DateTime? edate = null; decimal? tbudget = null; decimal? rbudget = null; decimal? uAmount = null; bool recurring = false; bool notice = false; if (!string.IsNullOrEmpty(row["CompanyID"].ToString())) { cid = Convert.ToInt32(row["CompanyID"]); } if (!string.IsNullOrEmpty(row["ServiceID"].ToString())) { sid = Convert.ToInt32(row["ServiceID"]); } if (!string.IsNullOrEmpty(row["minDaysToCharge"].ToString())) { dcharge = Convert.ToInt32(row["minDaysToCharge"]); } if (!string.IsNullOrEmpty(row["Budget Start Date"].ToString())) { sdate = Convert.ToDateTime(row["Budget Start Date"]).Date; } if (!string.IsNullOrEmpty(row["Budget End Date"].ToString())) { edate = Convert.ToDateTime(row["Budget End Date"]).Date; } if (!string.IsNullOrEmpty(row["Total Budget"].ToString())) { tbudget = Convert.ToDecimal(row["Total Budget"]); } if (!string.IsNullOrEmpty(row["Remaining Budget"].ToString())) { rbudget = Convert.ToDecimal(row["Remaining Budget"]); } if (!string.IsNullOrEmpty(row["Uncharged Amount"].ToString())) { uAmount = Convert.ToDecimal(row["Uncharged Amount"]); } if (!string.IsNullOrEmpty(row["IsReccurring"].ToString())) { recurring = Convert.ToBoolean(row["IsReccurring"]); } if (!string.IsNullOrEmpty(row["IsRequireNoticeToCharge"].ToString())) { notice = Convert.ToBoolean(row["IsRequireNoticeToCharge"]); } BudgetModel s = new BudgetModel { CompanyId = cid, CompanyName = row["Company Name"].ToString(), AX = row["AX Number"].ToString(), InsertionOrderId = row["Budget Insertion ID"].ToString(), AgreementNumber = row["agreementNumber"].ToString(), AreaCodes = row["Area Code"].ToString(), StartDate = sdate, EndDate = edate, TotalBudget = tbudget, RemainingBudget = rbudget, UnchargedAmount = uAmount, ServiceId = sid, MinDaysToCharge = dcharge, IsRecurring = recurring, IsRequireNoticeToCharge = notice }; list.Add(s); } return list; } }
public static bool SaveBudget(BudgetModel budget) { using (SqlConnection dbCon = ConnectToDb(DBConnString)) { SqlCommand cmdSaveBudget = new SqlCommand(); cmdSaveBudget.Connection = dbCon; cmdSaveBudget.CommandType = System.Data.CommandType.StoredProcedure; cmdSaveBudget.CommandText = "usp_SaveBudget"; SqlParameter paramCompanyId = new SqlParameter("companyID", budget.CompanyId); //SqlParameter paramCompanyName = new SqlParameter("companyName", budget.CompanyName); //SqlParameter paramCompanyHandle = new SqlParameter("companyHandle", budget.CompanyHandle); // SqlParameter paramActive = new SqlParameter("isActive", budget.IsActive); SqlParameter paramTotalBudget = new SqlParameter("totalBudget", budget.TotalBudget); SqlParameter paramRemainingBudget = new SqlParameter("remainingBudget", budget.RemainingBudget); SqlParameter paramBudgetAction = new SqlParameter("budgetAction", budget.BudgetAction); SqlParameter paramRecurring = new SqlParameter("isRecurring", budget.IsRecurring); SqlParameter paramRequireNoticeToCharge = new SqlParameter("isRequireNoticeToCharge", budget.IsRequireNoticeToCharge); SqlParameter paramAgreementNumber = new SqlParameter("agreementNumber", budget.AgreementNumber); SqlParameter paramMinCharge = new SqlParameter("minDaysToCharge", budget.MinDaysToCharge); SqlParameter paramServices = new SqlParameter("service", budget.Services); SqlParameter paramType = new SqlParameter("type", budget.Type); cmdSaveBudget.Parameters.Add(paramCompanyId); //cmdSaveBudget.Parameters.Add(paramCompanyName); //cmdSaveBudget.Parameters.Add(paramCompanyHandle); //cmdSaveBudget.Parameters.Add(paramActive); cmdSaveBudget.Parameters.Add(paramTotalBudget); cmdSaveBudget.Parameters.Add(paramRemainingBudget); cmdSaveBudget.Parameters.Add(paramBudgetAction); cmdSaveBudget.Parameters.Add(paramRecurring); cmdSaveBudget.Parameters.Add(paramRequireNoticeToCharge); cmdSaveBudget.Parameters.Add(paramAgreementNumber); cmdSaveBudget.Parameters.Add(paramMinCharge); cmdSaveBudget.Parameters.Add(paramServices); cmdSaveBudget.Parameters.Add(paramType); SqlDataReader dr = cmdSaveBudget.ExecuteReader(); if (dr.Read()) { ret = dr.GetBoolean(0); } } return ret; }
public ActionResult EditBudget(decimal? TotalBudget, bool IsRecurring, bool IsRequireNoticeToCharge, int? serviceId, string agnumber, int? minDaysToCharge) { BudgetModel budget = new BudgetModel(); budget.TotalBudget = TotalBudget; budget.IsRecurring = IsRecurring; budget.IsRequireNoticeToCharge = IsRequireNoticeToCharge; budget.ServiceId = serviceId; budget.MinDaysToCharge = minDaysToCharge; budget.AgreementNumber = agnumber; ViewBag.Terms = Terms(budget.IsRecurring, budget.IsRequireNoticeToCharge, true); ViewBag.Services = Services(budget.ServiceId, true); budget.CompanyId = (int?)Session["CompanyId"]; budget.CompanyName = (string)Session["CompanyName"]; budget.AX = (string)Session["Ax"]; budget.IsActive = (bool)Session["IsActive"]; budget.DisplayName = (string)Session["DisplayName"]; budget.ContactPerson = (string)Session["ContactPerson"]; budget.CompanyHandle = (string)Session["CompanyHandle"]; return View(budget); }
public static bool SaveBudget(BudgetModel budget) { budget.RemainingBudget = budget.TotalBudget; return DataLayer.SaveBudget(budget); }