protected void btnSave_Click(object sender, EventArgs e) { MoneyRanges objMoneyRanges = new MoneyRanges(); objMoneyRanges.MoneyRangeDesc = txtMoneyRangeDesc.Text; objMoneyRanges.Status = 1; if (!string.IsNullOrEmpty(hfMoneyRangeID.Value.ToString())) { objMoneyRanges.UpdatedBy = UserAuthentication.GetUserId(this.Page); objMoneyRanges.UpdatedDate = DateTime.Now; objMoneyRanges.MoneyRangeID = Convert.ToInt32(hfMoneyRangeID.Value); objMoneyRanges.MoneyRangeDesc = txtMoneyRangeDesc.Text; MoneyRangesBO.UpdateMoneyRanges(objMoneyRanges); } else { objMoneyRanges.CreatedBy = UserAuthentication.GetUserId(this.Page); objMoneyRanges.CreatedDate = DateTime.Now; MoneyRangesBO.InsertMoneyRanges(objMoneyRanges); } txtMoneyRangeDesc.Text = string.Empty; hfMoneyRangeID.Value = string.Empty; loadMoneyRange(); }
public int InsertMoneyRanges(MoneyRanges objMoneyRanges) { objMoneyRanges.MoneyRangeID = 1; BeginTransaction(); try { objMoneyRanges.MoneyRangeID = Insert(objMoneyRanges); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objMoneyRanges.MoneyRangeID = -1; } return objMoneyRanges.MoneyRangeID; }
protected void gvMoneyRange_RowCommand(object sender, GridViewCommandEventArgs e) { hfMoneyRangeID.Value = e.CommandArgument.ToString(); MoneyRanges objMoneyRanges = new MoneyRanges(); if (e.CommandName.Equals("cmdEdit")) { objMoneyRanges = MoneyRangesBO.GetMoneyRanges(Convert.ToInt32(e.CommandArgument)); txtMoneyRangeDesc.Text = objMoneyRanges.MoneyRangeDesc; } else if (e.CommandName.Equals("cmdDelete")) { int MoneyRangeID = Convert.ToInt32(e.CommandArgument); objMoneyRanges.MoneyRangeID = MoneyRangeID; objMoneyRanges.Status = 0; MoneyRangesBO.DeleteMoneyRanges(objMoneyRanges); loadMoneyRange(); } }
public int DeleteMoneyRanges(MoneyRanges objMoneyRanges) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "Status" }; rowsaffected = Update(objMoneyRanges, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public static int DeleteMoneyRanges(MoneyRanges objMoneyRanges) { return new MoneyRangesDAO().DeleteMoneyRanges(objMoneyRanges); }
public static int UpdateMoneyRanges(MoneyRanges objMoneyRanges) { return new MoneyRangesDAO().UpdateMoneyRanges(objMoneyRanges); }
public static MoneyRanges GetMoneyRanges(int MoneyRangeID) { MoneyRanges objMoneyRanges = new MoneyRanges(); return (MoneyRanges)(new MoneyRangesDAO().FillDTO(objMoneyRanges, "MoneyRangeID=" + MoneyRangeID)); }
public static int InsertMoneyRanges(MoneyRanges objMoneyRanges) { return new MoneyRangesDAO().InsertMoneyRanges(objMoneyRanges); }