protected void grdFeesTerm_UpdateRow(object sender, GridViewUpdateEventArgs e)
{
int monthID = Convert.ToInt32(grdFeesTerm.DataKeys[e.RowIndex].Value.ToString());
int feeCategoryID = Convert.ToInt32(drpFeesCategory.SelectedValue);
var dt = TMSFeesTerm.GetFeesTermbyMonthIDAndFeeCategoryID(feeCategoryID,monthID).Tables[0];
GridViewRow row = grdFeesTerm.Rows[e.RowIndex];
if (dt.Rows.Count>0) //Update existing
{
TMSFeesTerm objFeesTerm = TMSFeesTerm.Get(Convert.ToInt64(dt.Rows[0]["FeesTermID"]));
objFeesTerm.FeesTerm = ((TextBox)row.FindControl("txtFeesTerm")).Text;
objFeesTerm.Update();
}
else //Insert new
{
TMSFeesTerm objFeesTerm = new TMSFeesTerm();
objFeesTerm.Month = monthID;
objFeesTerm.FeeCategoryID = feeCategoryID;
objFeesTerm.FeesTerm = ((TextBox)row.FindControl("txtFeesTerm")).Text;
objFeesTerm.Insert();
}
grdFeesTerm.EditIndex = -1;
BindFeesTerm();
}
protected void grdFeesTerm_UpdateRow(object sender, GridViewUpdateEventArgs e)
{
int monthID = Convert.ToInt32(grdFeesTerm.DataKeys[e.RowIndex].Value.ToString());
int feeCategoryID = Convert.ToInt32(drpFeesCategory.SelectedValue);
var dt = TMSFeesTerm.GetFeesTermbyMonthIDAndFeeCategoryID(feeCategoryID, monthID).Tables[0];
GridViewRow row = grdFeesTerm.Rows[e.RowIndex];
if (dt.Rows.Count > 0) //Update existing
{
TMSFeesTerm objFeesTerm = TMSFeesTerm.Get(Convert.ToInt64(dt.Rows[0]["FeesTermID"]));
objFeesTerm.FeesTerm = ((TextBox)row.FindControl("txtFeesTerm")).Text;
objFeesTerm.Update();
}
else //Insert new
{
TMSFeesTerm objFeesTerm = new TMSFeesTerm();
objFeesTerm.Month = monthID;
objFeesTerm.FeeCategoryID = feeCategoryID;
objFeesTerm.FeesTerm = ((TextBox)row.FindControl("txtFeesTerm")).Text;
objFeesTerm.Insert();
}
grdFeesTerm.EditIndex = -1;
BindFeesTerm();
}
