protected void BtnDelete_Click(object sender, EventArgs e) { try { int DeleteId = 0; if (ViewState["EditID"] != null) { DeleteId = Convert.ToInt32(ViewState["EditID"]); } if (DeleteId != 0) { Entity_SL.StockLocationID = DeleteId; Entity_SL.UserId = Convert.ToInt32(Session["UserID"]); Entity_SL.LoginDate = DateTime.Now; Entity_SL.IsDeleted = true; int iDelete = Obj_SL.DeleteRecord(ref Entity_SL, out StrError); if (iDelete != 0) { obj_Comm.ShowPopUpMsg("Record Deleted Successfully..!", this.Page); MakeEmptyForm(); } } Entity_SL = null; obj_Comm = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { int UpdateRow = 0; try { if (ViewState["EditID"] != null) { Entity_SL.StockLocationID = Convert.ToInt32(ViewState["EditID"]); } Entity_SL.Location = TxtCostCentre.Text.Trim(); Entity_SL.SiteId = Convert.ToInt32(ddlSite.SelectedValue); Entity_SL.TowerId = Convert.ToInt32(ddlTower.SelectedValue); Entity_SL.CompanyId = 0; Entity_SL.UserId = Convert.ToInt32(Session["UserId"]); Entity_SL.LoginDate = DateTime.Now; UpdateRow = Obj_SL.UpdateRecord(ref Entity_SL, out StrError); if (UpdateRow != 0) { obj_Comm.ShowPopUpMsg("Record Updated Successfully", this.Page); MakeEmptyForm(); Entity_SL = null; obj_Comm = null; } } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> PutCostCentre(int id, CostCentre costCentre) { if (id != costCentre.Id) { return(BadRequest()); } _context.Entry(costCentre).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CostCentreExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <CostCentre> > PostCostCentre(CostCentre costCentre) { _context.CostCentres.Add(costCentre); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCostCentre", new { id = costCentre.Id }, costCentre)); }
private void PopulateOPCostCentre() { DataTable dtOpCC = new DataTable(); dtOpCC = FlatTypeBL.GetOpCostCentre(); DataRow dr = null; dr = dtOpCC.NewRow(); dr["CostCentreId"] = 0; dr["CostCentreName"] = "None"; dr["Typewise"] = false; dtOpCC.Rows.InsertAt(dr, 0); if (dtOpCC.Rows.Count > 0) { CostCentre.DataSource = dtOpCC; CostCentre.PopulateColumns(); CostCentre.DisplayMember = "CostCentreName"; CostCentre.ValueMember = "CostCentreId"; CostCentre.Columns["CostCentreId"].Visible = false; CostCentre.Columns["Typewise"].Visible = false; CostCentre.ShowFooter = false; CostCentre.ShowHeader = false; } cboCostCentre.EditValue = 0; }
public bool SaveCostCentre(CostCentreModel model) { try { if (model != null) { CostCentre costCentre = new CostCentre { costcentrename = model.costcentrename, remark = model.remark, isActive = true, }; tRSEntities4.CostCentres.Add(costCentre); tRSEntities4.SaveChanges(); return(true); } else { return(false); } } catch (Exception e) { throw e; } }
public ActionResult DeleteConfirmed(int id) { CostCentre costCentre = db.CostCentres.Find(id); db.CostCentres.Remove(costCentre); db.SaveChanges(); return(RedirectToAction("Index")); }
public HttpResponseMessage UpdateCostCentre(HttpRequestMessage request, [FromBody] CostCentre costCentreModel) { return(GetHttpResponse(request, () => { var costCentre = _MPROPEXService.UpdateCostCentre(costCentreModel); return request.CreateResponse <CostCentre>(HttpStatusCode.OK, costCentre); })); }
public void GivenNullValue_ThenTheCostCentreShouldBeGreater() { var costCentre1 = new CostCentre() { Tier1 = "1" }; var result = costCentre1.CompareTo(null) > 0; Assert.That(result, Is.True); }
public int InsertRecord(ref CostCentre Entity_call, out string strError) { int iInsert = 0; strError = string.Empty; try { SqlParameter pAction = new SqlParameter(CostCentre._Action, SqlDbType.BigInt); SqlParameter pLocation = new SqlParameter(CostCentre._Location, SqlDbType.NVarChar); SqlParameter pSiteId = new SqlParameter(CostCentre._SiteId, SqlDbType.BigInt); SqlParameter pTowerId = new SqlParameter(CostCentre._TowerId, SqlDbType.BigInt); SqlParameter pCreatedBy = new SqlParameter(CostCentre._UserId, SqlDbType.BigInt); SqlParameter PCreatedDate = new SqlParameter(CostCentre._LoginDate, SqlDbType.DateTime); SqlParameter pIsDeleted = new SqlParameter(CostCentre._IsDeleted, SqlDbType.Bit); pAction.Value = 1; pLocation.Value = Entity_call.Location; pSiteId.Value = Entity_call.SiteId; pTowerId.Value = Entity_call.TowerId; pCreatedBy.Value = Entity_call.UserId; PCreatedDate.Value = Entity_call.LoginDate; pIsDeleted.Value = Entity_call.IsDeleted; SqlParameter[] param = new SqlParameter[] { pAction, pLocation, pSiteId, pTowerId, pCreatedBy, PCreatedDate, pIsDeleted }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, CostCentre.SP_CostCentre, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); strError = ex.Message; } finally { Close(); } return(iInsert); }
public static CostCentre[] GetChildren(DataTable dt, string query) { DataRow[] foundRows = dt.Select(query); CostCentre[] children = new CostCentre[foundRows.Length]; for (int i = 0; i < foundRows.Length; i++) { CostCentre cc = CostCentreDB.Load(foundRows[i]); cc.Children = GetChildren(dt, "parent_id = " + cc.CostCentreID.ToString()); children[i] = cc; } return children; }
//GET public ActionResult Create() { //mock up. todo create and call the WS to get all cost centres var c = new CostCentre(); c.CostCentreId = "101"; c.Name = "Centro1"; ViewBag.costcentre = new List <CostCentre>() { c }; return(View()); }
public HttpResponseMessage GetCostCentre(HttpRequestMessage request, int costCentreId) { return(GetHttpResponse(request, () => { HttpResponseMessage response = null; CostCentre costCentre = _MPROPEXService.GetCostCentre(costCentreId); // notice no need to create a seperate model object since CostCentre entity will do just fine response = request.CreateResponse <CostCentre>(HttpStatusCode.OK, costCentre); return response; })); }
// GET: CostCentres/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CostCentre costCentre = db.CostCentres.Find(id); if (costCentre == null) { return(HttpNotFound()); } return(View(costCentre)); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } CostCentre = await _context.CostCentres.FirstOrDefaultAsync(m => m.Id == id); if (CostCentre == null) { return(NotFound()); } return(Page()); }
public int DeleteRecord(ref CostCentre EntityCall, out string StrError) { int iDelete = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(CostCentre._Action, SqlDbType.BigInt); SqlParameter pStockLocationId = new SqlParameter(CostCentre._StockLocationID, SqlDbType.BigInt); SqlParameter pDeletedBy = new SqlParameter(CostCentre._UserId, SqlDbType.BigInt); SqlParameter pDeletedDate = new SqlParameter(CostCentre._LoginDate, SqlDbType.DateTime); SqlParameter pIsDeleted = new SqlParameter(CostCentre._IsDeleted, SqlDbType.Bit); pAction.Value = 3; pStockLocationId.Value = EntityCall.StockLocationID; pDeletedBy.Value = EntityCall.UserId; pDeletedDate.Value = EntityCall.LoginDate; pIsDeleted.Value = EntityCall.IsDeleted; SqlParameter[] param = new SqlParameter[] { pAction, pStockLocationId, pDeletedBy, pDeletedDate, pIsDeleted }; Open(CONNECTION_STRING); BeginTransaction(); iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, CostCentre.SP_CostCentre, param); if (iDelete > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iDelete); }
public ActionResult Create([Bind(Include = "Code,CCName,Enbld")] CostCentre costCentre) { if (ModelState.IsValid) { Person userperson = db.People.SingleOrDefault(p => p.ID == 0); costCentre.Creator = userperson; costCentre.Created = DateTime.Now; costCentre.Modifier = userperson; costCentre.Modified = DateTime.Now; db.CostCentres.Add(costCentre); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(costCentre)); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } CostCentre = await _context.CostCentres.FindAsync(id); if (CostCentre != null) { _context.CostCentres.Remove(CostCentre); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
private bool ChildrenContains(CostCentre thisNode, int parentID) { foreach (CostCentre cc in thisNode.Children) { if (cc.CostCentreID == parentID) { return(true); } bool cc2 = ChildrenContains(cc, parentID); if (cc2) { return(true); } } return(false); }
protected override OpResult _Store(CostCentre _obj) { if (_obj == null) { return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "CostCentre object cannot be created as it is null")); } if (Exists(_obj)) { ExecuteNonQuery(GetQuery_UpdateQuery(_obj)); return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj)); } ExecuteNonQuery(GetQuery_InsertQuery(_obj)); _obj.FromDb = true; return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj)); }
private CostCentre GetRoot(CostCentre[] tree, int costCentreID) { foreach (CostCentre cc in tree) { if (cc.CostCentreID == costCentreID) { return(cc); } CostCentre cc2 = GetRoot(cc.Children, costCentreID); if (cc2 != null) { return(cc2); } } return(null); }
public ActionResult Edit([Bind(Include = "Code,CCName,Enbld")] CostCentre costCentre) { if (ModelState.IsValid) { CostCentre ccInDB = db.CostCentres.Single(c => c.Code == costCentre.Code); ccInDB.CCName = costCentre.CCName; ccInDB.Enbld = costCentre.Enbld; Person userperson = db.People.SingleOrDefault(p => p.ID == 0); ccInDB.Modifier = userperson; ccInDB.Modified = DateTime.Now; //db.Entry(costCentre).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(costCentre)); }
public static bool Matches(this CostCentre costCentre, BcrOptions options) { if (!HasOption(options.Tier1) && !HasOption(options.Tier2) && !HasOption(options.Tier3) && !HasOption(options.Tier4) && !HasOption(options.CostCentre)) { return(true); } var matchesTier1 = HasOption(options.Tier1) && Matches(options.Tier1, costCentre.Tier1); var matchesTier2 = HasOption(options.Tier2) && Matches(options.Tier2, costCentre.Tier2); var matchesTier3 = HasOption(options.Tier3) && Matches(options.Tier3, costCentre.Tier3); var matchesTier4 = HasOption(options.Tier4) && Matches(options.Tier4, costCentre.Tier4); var matchesCostCentre = HasOption(options.CostCentre) && Matches(options.CostCentre, costCentre.Code); return(matchesTier1 || matchesTier2 || matchesTier3 || matchesTier4 || matchesCostCentre); }
public AccountOpResponse() { financialInfo = new FinancialInfoModel(); costCentre = new CostCentre(); eventLogger = new EventLogger(); creditAssesOperation = new CreditAssesOperation(); tempCreditCtrl = new TempCreditCtrlModel(); upToDateBal = new UpToDateBal(); productDiscount = new ProductDiscount(); PaymentTxn = new PaymentTxn(); costCentres = new List <CostCentre>(); WebSecDepRemarks = new List <RemarkHistory>(); creditLimitHistories = new List <CreditLimitHistory>(); financilInfoItems = new List <FinancilInfoItemsList>(); eventLoggers = new List <EventLogger>(); productDiscounts = new List <ProductDiscount>(); onlineTransactions = new List <OnlineTransaction>(); PaymentTxns = new List <PaymentTxn>(); BillingItems = new List <BillingItem>(); }
protected void BtnSave_Click(object sender, EventArgs e) { int InsertRow = 0; try { DS = Obj_SL.ChkDuplicate(TxtCostCentre.Text.Trim(), out StrError); if (DS.Tables[0].Rows.Count > 0) { obj_Comm.ShowPopUpMsg("Cost Location Name Already Exist..!", this.Page); TxtCostCentre.Focus(); } else { Entity_SL.Location = TxtCostCentre.Text.Trim(); Entity_SL.SiteId = Convert.ToInt32(ddlSite.SelectedValue); Entity_SL.TowerId = Convert.ToInt32(ddlTower.SelectedValue); Entity_SL.CompanyId = 0; Entity_SL.UserId = Convert.ToInt32(Session["UserId"]); Entity_SL.LoginDate = DateTime.Now; Entity_SL.IsDeleted = false; InsertRow = Obj_SL.InsertRecord(ref Entity_SL, out StrError); if (InsertRow != 0) { obj_Comm.ShowPopUpMsg("Record Saved Successfully", this.Page); MakeEmptyForm(); Entity_SL = null; obj_Comm = null; } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public Staff(int staff_id, int person_id, string login, string pwd, int staff_position_id, int field_id, int costcentre_id, bool is_contractor, string tfn, string provider_number, bool is_fired, bool is_commission, decimal commission_percent, bool is_stakeholder, bool is_master_admin, bool is_admin, bool is_principal, bool is_provider, bool is_external, DateTime staff_date_added, DateTime start_date, DateTime end_date, string comment, int num_days_to_display_on_booking_screen, bool show_header_on_booking_screen, int bk_screen_field_id, bool bk_screen_show_key, bool enable_daily_reminder_sms, bool enable_daily_reminder_email, bool hide_booking_notes) { this.staff_id = staff_id; this.person = new Person(person_id); this.login = login; this.pwd = pwd; this.staffPosition = new StaffPosition(staff_position_id); this.field = new IDandDescr(field_id); this.costCentre = new CostCentre(costcentre_id); this.is_contractor = is_contractor; this.tfn = tfn; this.provider_number = provider_number; this.is_fired = is_fired; this.is_commission = is_commission; this.commission_percent = commission_percent; this.is_stakeholder = is_stakeholder; this.is_master_admin = is_master_admin; this.is_admin = is_admin; this.is_principal = is_principal; this.is_provider = is_provider; this.is_external = is_external; this.staff_date_added = staff_date_added; this.start_date = start_date; this.end_date = end_date; this.comment = comment; this.num_days_to_display_on_booking_screen = num_days_to_display_on_booking_screen; this.show_header_on_booking_screen = show_header_on_booking_screen; this.bk_screen_field = bk_screen_field_id == -1 ? null : new IDandDescr(bk_screen_field_id); this.bk_screen_show_key = bk_screen_show_key; this.enable_daily_reminder_sms = enable_daily_reminder_sms; this.enable_daily_reminder_email = enable_daily_reminder_email; this.hide_booking_notes = hide_booking_notes; }
protected void GrdCostCentre_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label lblId = (Label)GrdCostCentre.Rows[e.RowIndex].FindControl("lblId"); DropDownList ddlParent = (DropDownList)GrdCostCentre.Rows[e.RowIndex].FindControl("ddlParent"); TextBox txtDescr = (TextBox)GrdCostCentre.Rows[e.RowIndex].FindControl("txtDescr"); // make sure we are not parent up the line of parent_id CostCentre[] tree = CostCentreDB.GetTree(); CostCentre thisNode = GetRoot(tree, Convert.ToInt32(lblId.Text)); if (ChildrenContains(thisNode, Convert.ToInt32(ddlParent.SelectedValue))) { lblErrorMessage.Visible = true; lblErrorMessage.Text = "Can not add this parent because this is already a child"; return; } CostCentreDB.Update(Convert.ToInt32(lblId.Text), txtDescr.Text, Convert.ToInt32(ddlParent.SelectedValue)); GrdCostCentre.EditIndex = -1; FillGrid(); }
public HttpResponseMessage DeleteCostCentre(HttpRequestMessage request, [FromBody] int costCentreId) { return(GetHttpResponse(request, () => { HttpResponseMessage response = null; // not that calling the WCF service here will authenticate access to the data CostCentre costCentre = _MPROPEXService.GetCostCentre(costCentreId); if (costCentre != null) { _MPROPEXService.DeleteCostCentre(costCentreId); response = request.CreateResponse(HttpStatusCode.OK); } else { response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No costCentre found under that ID."); } return response; })); }
private CostCentre GetRoot(CostCentre[] tree, int costCentreID) { foreach (CostCentre cc in tree) { if (cc.CostCentreID == costCentreID) return cc; CostCentre cc2 = GetRoot(cc.Children, costCentreID); if (cc2 != null) return cc2; } return null; }
public DashboardSummary CreateSummary( DashboardRequest request, SliceDataModel[] sliceData, ActivityGroup[] activities, CostCentre centre) { var configuration = Configurations[request.Section]; var uomLong = string.Empty; var showCo2 = false; var groupNodes = activities.Select(a => a.Node).ToArray(); var summary = new DashboardSummary { costCentre = centre.Name, activityGroup = (request.ActivityGroupId == null) ? configuration.DisplayName : activities[0].Name, displayTotal = true }; var slices = sliceData .OrderBy(s => s.OrderId) .Select(s => { var slice = new SliceModel { activityGroupId = s.ActivityGroupId, color = s.Color, costCode = s.CostCode, description = s.Description, title = s.Title, sliceId = CreateSliceId(s.ActivityGroupId, s.CostCode), }; var noUnits = (string.IsNullOrEmpty(s.UomShort)) || (string.IsNullOrEmpty(s.UomLong)); if (configuration.ShowCo2 || noUnits) { showCo2 = true; slice.co2label = Constants.Constants.Co2LabelShort; slice.amount = GetTotal( TotalEmissions, request.StartDate, request.EndDate, s.ActivityGroupNode, s.CentreNode, groupNodes) / 1000; } if (configuration.ShowCo2 && !noUnits) { slice.uom = s.UomShort; slice.units = GetTotal( TotalUnits, request.StartDate, request.EndDate, s.ActivityGroupNode, s.CentreNode, groupNodes); } if (!configuration.ShowCo2 && !noUnits) { slice.co2label = s.UomShort; uomLong = s.UomLong; slice.amount = GetTotal( TotalUnits, request.StartDate, request.EndDate, s.ActivityGroupNode, s.CentreNode, groupNodes); } return(slice); }).ToArray(); decimal lastYearTotal; decimal totalAmount; if (showCo2) { totalAmount = GetTotal( TotalEmissions, request.StartDate, request.EndDate, null, centre.Node, groupNodes) / 1000; lastYearTotal = GetTotal( TotalEmissions, request.StartDate.AddYears(-1), request.EndDate.AddYears(-1), null, centre.Node, groupNodes) / 1000; } else { totalAmount = GetTotal( TotalUnits, request.StartDate, request.EndDate, null, centre.Node, groupNodes); lastYearTotal = GetTotal( TotalUnits, request.StartDate.AddYears(-1), request.EndDate.AddYears(-1), null, centre.Node, groupNodes); } var yoy = (lastYearTotal == 0) ? 0 : ((totalAmount - lastYearTotal) / lastYearTotal) * 100; var currencies = GetCurrencies( request.StartDate, request.EndDate, groupNodes, centre.Node); summary.co2label = (showCo2) ? Constants.Constants.Co2LabelLong : uomLong; summary.currencies = currencies; summary.slices = slices; summary.total = totalAmount; summary.yoy = yoy; return(summary); }
private bool ChildrenContains(CostCentre thisNode, int parentID) { foreach (CostCentre cc in thisNode.Children) { if (cc.CostCentreID == parentID) return true; bool cc2 = ChildrenContains(cc, parentID); if (cc2) return true; } return false; }
private DbUpdateStatement GetQuery_UpdateQuery(CostCentre _obj) { return(DbMgr.CreateUpdateClause("CostCentres", GetFields(_obj), "CostCentreID", _obj.CostCentreID)); }
private DbInsertStatement GetQuery_InsertQuery(CostCentre _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("CostCentres", fields)); }
public void AddToCostCentres(CostCentre costCentre) { base.AddObject("CostCentres", costCentre); }
public static CostCentre CreateCostCentre(long ID, global::System.Guid tid, string name, long createdById, long modifiedById, global::System.DateTimeOffset created, global::System.DateTimeOffset modified) { CostCentre costCentre = new CostCentre(); costCentre.Id = ID; costCentre.Tid = tid; costCentre.Name = name; costCentre.CreatedById = createdById; costCentre.ModifiedById = modifiedById; costCentre.Created = created; costCentre.Modified = modified; return costCentre; }
private ArrayList Flatten(CostCentre[] children, string parent_descr, string parent_id, int level) { ArrayList list = new ArrayList(); foreach (CostCentre cc in children) { Hashtable h = new Hashtable(); h["costcentre_id"] = cc.CostCentreID; h["descr"] = cc.Descr; h["parent_id"] = parent_id; h["parent_descr"] = parent_descr; h["level"] = level; list.Add(h); CostCentre[] kids = cc.Children; ArrayList kidslist = Flatten(kids, cc.Descr, cc.CostCentreID.ToString(), level + 1); list.AddRange(kidslist); } return list; }