public static TMSFeesTerm Get(System.Int64 feesTermID)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSFeesTerm instance;
instance = new TMSFeesTerm();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFeesTerm_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, feesTermID);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSFeesTerm ID:" + feesTermID.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
private void BindFeesTerm()
{
var dtFeesTerm = TMSFeesTerm.GetFeesTermbyFeeCategoryID(Convert.ToInt32(drpFeesCategory.SelectedValue)).Tables[0];
DataTable dt = new DataTable();
dt.Columns.Add("MonthID");
dt.Columns.Add("Month");
dt.Columns.Add("FeesTerm");
for (int i = 1; i < 13; i++)
{
DataRow dr = dt.NewRow();
dr["MonthID"] = i;
dr["Month"] = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(i);
var dv = new DataView(dtFeesTerm)
{
RowFilter = "Month=" + i
};
dr["FeesTerm"] = dv.ToTable().Rows.Count > 0 ? dv.ToTable().Rows[0]["FeesTerm"] : "";
dt.Rows.Add(dr);
dt.AcceptChanges();
}
grdFeesTerm.DataSource = dt;
grdFeesTerm.DataBind();
}
public static TMSFeesTerm[] Search(System.Int64?feesTermID, System.Int32?feeCategoryID, System.Int32?month, System.String feesTerm)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFeesTerm_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, feesTermID, feeCategoryID, month, feesTerm);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSFeesTerm.MapFrom(ds));
}
protected void drpNewFeeCategoryName_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList drpNewFeeCategoryName = (DropDownList)sender;
GridViewRow row = (GridViewRow)drpNewFeeCategoryName.NamingContainer;
DropDownList drpNewFeeHeadName = ((DropDownList)row.FindControl("drpNewFeeHeadName"));
drpNewFeeHeadName.DataSource = TMSFeesHeadMaster.Search(null, Convert.ToInt32(drpNewFeeCategoryName.SelectedValue), null, null, null);
drpNewFeeHeadName.DataTextField = "FeeHeadName";
drpNewFeeHeadName.DataValueField = "FeeHeadID";
drpNewFeeHeadName.DataBind();
drpNewFeeHeadName.Items.Insert(0, "Select");
DropDownList drpNewFeeTerm = ((DropDownList)row.FindControl("drpNewFeeTerm"));
drpNewFeeTerm.DataSource = TMSFeesTerm.Search(null, Convert.ToInt32(drpNewFeeCategoryName.SelectedValue), null, null);
drpNewFeeTerm.DataTextField = "FeesTerm";
drpNewFeeTerm.DataValueField = "FeesTermID";
drpNewFeeTerm.DataBind();
drpNewFeeTerm.Items.Insert(0, "Select");
}
public static TMSFeesTerm[] MapFrom(DataSet ds)
{
List <TMSFeesTerm> objects;
// Initialise Collection.
objects = new List <TMSFeesTerm>();
// Validation.
if (ds == null)
{
throw new ApplicationException("Cannot map to dataset null.");
}
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
{
return(objects.ToArray());
}
if (ds.Tables[TABLE_NAME] == null)
{
throw new ApplicationException("Cannot find table [dbo].[TMS_FeesTerm] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_FeesTerm] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSFeesTerm instance = new TMSFeesTerm();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
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();
}
public static TMSFeesTerm[] Search(TMSFeesTerm searchObject)
{
return(Search(searchObject.FeesTermID, searchObject.FeeCategoryID, searchObject.Month, searchObject.FeesTerm));
}
public static void Update(TMSFeesTerm tMSFeesTerm, DbTransaction transaction)
{
tMSFeesTerm.Update(transaction);
}
public static void Update(TMSFeesTerm tMSFeesTerm)
{
tMSFeesTerm.Update();
}
public static void Update(TMSFeesTerm tMSFeesTerm, DbTransaction transaction)
{
tMSFeesTerm.Update(transaction);
}
public static void Update(TMSFeesTerm tMSFeesTerm)
{
tMSFeesTerm.Update();
}
public static TMSFeesTerm[] Search(TMSFeesTerm searchObject)
{
return Search ( searchObject.FeesTermID, searchObject.FeeCategoryID, searchObject.Month, searchObject.FeesTerm);
}
public static TMSFeesTerm[] MapFrom(DataSet ds)
{
List<TMSFeesTerm> objects;
// Initialise Collection.
objects = new List<TMSFeesTerm>();
// Validation.
if (ds == null)
throw new ApplicationException("Cannot map to dataset null.");
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
return objects.ToArray();
if (ds.Tables[TABLE_NAME] == null)
throw new ApplicationException("Cannot find table [dbo].[TMS_FeesTerm] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_FeesTerm] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSFeesTerm instance = new TMSFeesTerm();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSFeesTerm Get(System.Int64 feesTermID)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSFeesTerm instance;
instance = new TMSFeesTerm();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFeesTerm_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, feesTermID);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSFeesTerm ID:" + feesTermID.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
