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