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