internal Budget(int franchiseId, DateTime asOfDate)
{
AsOfDate = asOfDate.Date;
FranchiseId = franchiseId;
var monthRatioFactor = (decimal)asOfDate.Day / DateTime.DaysInMonth(AsOfDate.Year, AsOfDate.Month);
DailySales = new BudgetDetails();
DailyJobs = new BudgetDetails();
DailyCloseRate = new BudgetDetails();
DailyAverageTicket = new BudgetDetails();
DailyHomeGuard = new BudgetDetails();
DailyBio = new BudgetDetails();
DailyRecalls = new BudgetDetails {
UnderBudgetIsGood = true
};
DailyPayroll = new BudgetDetails {
UnderBudgetIsGood = true
};
MonthlyCloseRate = new BudgetDetails();
MonthlyAverageTicket = new BudgetDetails();
MonthlySales = new MTDBudgetDetails(monthRatioFactor);
MonthlyJobs = new MTDBudgetDetails(monthRatioFactor);
MonthlyHomeGuard = new MTDBudgetDetails(monthRatioFactor);
MonthlyBio = new MTDBudgetDetails(monthRatioFactor);
MonthlyRecalls = new MTDBudgetDetails(monthRatioFactor)
{
UnderBudgetIsGood = true
};
MonthlyPayroll = new BudgetDetails {
UnderBudgetIsGood = true
};
}
public ActionResult CreateBudget()
{
BudgetDetails budgetDetailsViewModel = new BudgetDetails
{
Categories = GetAvailableBudgetCategory(budgetRepository)
};
return(View("CreateBudget", budgetDetailsViewModel));
}
public Budget GetById(int id)
{
try
{
Service1SoapClient client = service.GetClient();
object[] argumentos = new object[1];
argumentos[0] = id;
var data = client.DTcallProcedure("TECHNICAL.PKG_PRESUPUESTO.SP_PRESUPUESTO_POR_ID", argumentos).Any1;
DataSet dataSet = ConvertUtils.XmlToDataSet(data.InnerXml);
if (dataSet.Tables.Count > 0)
{
// Cabecera
DataRow row = dataSet.Tables[0].Rows[0];
Budget budget = new Budget
{
Id = Convert.ToInt32(row.ItemArray[0].ToString()),
CustomerId = row.ItemArray[1].ToString(),
Total = Convert.ToInt32(row.ItemArray[2].ToString()),
Date = Convert.ToDateTime(row.ItemArray[3]),
CustomerName = row.ItemArray[4].ToString(),
CustomerEmail = row.ItemArray[5].ToString(),
};
// Detalles
object[] argumentosD = new object[1];
argumentos[0] = budget.Id;
var dataD = client.DTcallProcedure("TECHNICAL.PKG_PRESUPUESTO.SP_PRESUPUESTO_DETALLES", argumentos).Any1;
DataSet dataSetD = ConvertUtils.XmlToDataSet(dataD.InnerXml);
List <BudgetDetails> details = new List <BudgetDetails>();
foreach (DataRow item in dataSetD.Tables[0].Rows)
{
BudgetDetails detail = new BudgetDetails();
detail.Id = int.Parse(item.ItemArray[0].ToString());
detail.ProductId = int.Parse(item.ItemArray[1].ToString());
detail.Description = item.ItemArray[2].ToString();
detail.Quantity = int.Parse(item.ItemArray[3].ToString());
detail.Price = item.ItemArray[4].ToString();
detail.Total = int.Parse(item.ItemArray[5].ToString());
details.Add(detail);
}
budget.Details = details;
return(budget);
}
return(new Budget());
}
catch (System.Exception e)
{
Console.WriteLine("Error " + e);
return(new Budget());
}
}
/// <summary>
/// To add the Budget to the application
/// </summary>
/// <returns>True if success else false</returns>
public bool AddBudget(BudgetDetails createBudgetData)
{
object[] objAddBudgetParameters = new object[9];
objAddBudgetParameters[0] = createBudgetData.BudgetName;
objAddBudgetParameters[1] = createBudgetData.BudgetDescription;
objAddBudgetParameters[2] = createBudgetData.MinimumAmount;
objAddBudgetParameters[3] = createBudgetData.MaximumAmount;
objAddBudgetParameters[4] = createBudgetData.StartDate;
objAddBudgetParameters[5] = createBudgetData.EndDate;
objAddBudgetParameters[6] = createBudgetData.CreatedBy;
objAddBudgetParameters[7] = createBudgetData.Category;
objAddBudgetParameters[8] = userSession.CompanyId;
return(DataLibrary.ExecuteQuery(ref objAddBudgetParameters, "bspCreateBudget") == -1 ? true : false);
}
public ActionResult CreateBudget(BudgetDetails budgetDetailsViewModel, string selectedCategory)
{
if (ModelState.IsValid)
{
using (budgetRepository)
{
string[] dateRange;
if (budgetDetailsViewModel.BudgetPeriod.Contains('-'))
{
dateRange = budgetDetailsViewModel.BudgetPeriod.Split('-');
}
else
{
dateRange = new string[] { budgetDetailsViewModel.BudgetPeriod, budgetDetailsViewModel.BudgetPeriod };
}
BudgetEntity.BudgetDetails createBudgetData = new BudgetEntity.BudgetDetails
{
BudgetName = budgetDetailsViewModel.BudgetName,
BudgetDescription = budgetDetailsViewModel.BudgetDescription,
MinimumAmount = budgetDetailsViewModel.MinimumAmountAllocated,
MaximumAmount = budgetDetailsViewModel.MaximumAmountAllocated,
StartDate = Convert.ToDateTime(dateRange[0].TrimEnd()),
EndDate = Convert.ToDateTime(dateRange[1].TrimStart()),
CreatedBy = SessionUserId,
Category = selectedCategory
};
if (budgetRepository.AddBudget(createBudgetData))
{
return(RedirectToAction("CreateBudget"));
}
else
{
ModelState.AddModelError("", "Error in creating budget. Try again!");
}
}
}
else
{
ModelState.AddModelError("", "The submitted form contain errors. Please correct them and submit again!");
}
budgetDetailsViewModel.Categories = GetAvailableBudgetCategory(budgetRepository);
return(View("CreateBudget", budgetDetailsViewModel));
}
[Route("api/Budget/ShowBudgetDetails")] //used to view budget details in screen 1
public HttpResponseMessage ShowBudgetDetails(BudgetDetails Pdobj)
{
try
{
Daccess = new DA();
var result = Daccess.bindShowBudgetDetails(Pdobj);
if (result == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No Datafound"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "No data found"));
}
}
public BudgetDetails GetListOfCostCodeAfterTransferBudgetDetails(long?LocationId, long?UserId, int?pageIndex, int?numberOfRows, string sortColumnName, string sortOrderBy, long?locationId, string textSearch, string statusType)
{
try
{
var db = new workorderEMSEntities();
var objBudgetDetails = new BudgetDetails();
int pageindex = Convert.ToInt32(pageIndex) - 1;
int pageSize = Convert.ToInt32(numberOfRows);
var Results = new List <BudgetForLocationModel>();
var obj = new BudgetForLocationModel();
var DataGrid = db.spGetBudgetCostCodeMapping(LocationId).Select(a => new BudgetForLocationModel()
{
CostCode = a.CLM_CCD_CostCode,
AssignedAmount = a.BCM_BudgetAmount,
Description = a.CCD_Description,
AssignedPercent = a.BCM_BudgetPercent,
RemainingAmount = a.BCM_BalanceAmount,
Year = a.BCM_BudgetYear,
BudgetAmount = a.BLM_BudgetAmount,
BCM_Id = a.BCM_Id,
CLM_Id = a.CLM_Id,
BudgetStatus = "O",
BudgetSource = a.BCM_BudgetSource
}).ToList();
Results = DataGrid.Where(a => a.BudgetSource != "BUDGETED" && a.BudgetSource != null).ToList();
int totRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totRecords / (float)numberOfRows);
//Results = Results.OrderByDescending(s => s.CostCode);
objBudgetDetails.pageindex = pageindex;
objBudgetDetails.total = totalPages;
objBudgetDetails.records = totRecords;
objBudgetDetails.rows = Results.ToList();
return(objBudgetDetails);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public BudgetDetails GetListBudgetDetails(long? LocationId, long? UserId, int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, long? locationId, string textSearch, string statusType)", "Exception While Getting List of Cost Code.", null);
throw;
}
}
public Budget(BudgetDetails bd)
: this(bd.ID, bd.Name, bd.StartDate, (double) bd.StartAmount)
{
}
public static bool Update(Budget b)
{
BudgetDetails bd = new BudgetDetails(b);
return SiteProvider.Accounts.UpdateBudget(bd);
}
public static bool Insert(Budget b)
{
BudgetDetails bd = new BudgetDetails(b);
int id = SiteProvider.Accounts.InsertBudget(bd);
if (id < 0)
return false;
b.ID = id;
return true;
}
