public static TMSFeesHeadMaster Get(System.Int32 feeHeadID)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSFeesHeadMaster instance;
instance = new TMSFeesHeadMaster();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFeesHeadMaster_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, feeHeadID);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSFeesHeadMaster ID:" + feeHeadID.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
protected void btnSearchFeeHeads_Click(object sender, EventArgs e)
{
var dsFeesCategory = TMSFeesHeadMaster.FilterFeeHeads(txtFeeHeadsSearch.Text);
grdFeeHeads.DataSource = dsFeesCategory.Tables[0];
grdFeeHeads.DataBind();
}
protected void grdFeeHeads_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddNew"))
{
TMSFeesHeadMaster objFeeHead = new TMSFeesHeadMaster();
objFeeHead.FeeHeadName = ((TextBox)grdFeeHeads.FooterRow.FindControl("txtNewFeeHeadName")).Text;
objFeeHead.FeeCategoryID = Convert.ToInt32(((DropDownList)grdFeeHeads.FooterRow.FindControl("drpNewFeeCategoryName")).SelectedValue);
objFeeHead.CreatedDate = DateTime.Now;
objFeeHead.IsDelete = false;
objFeeHead.Insert();
grdFeeHeads.EditIndex = -1;
BindFeeHeads();
}
}
protected void grdFeeHeads_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int feeHeadID = Convert.ToInt32(grdFeeHeads.DataKeys[e.RowIndex].Value.ToString());
if (feeHeadID != 0)
{
TMSFeesHeadMaster objFeeHead = TMSFeesHeadMaster.Get(feeHeadID);
objFeeHead.IsDelete = true;
objFeeHead.Update();
}
grdFeeHeads.EditIndex = -1;
BindFeeHeads();
}
protected void grdFeeHeads_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddNew"))
{
TMSFeesHeadMaster objFeeHead = new TMSFeesHeadMaster();
objFeeHead.FeeHeadName = ((TextBox)grdFeeHeads.FooterRow.FindControl("txtNewFeeHeadName")).Text;
objFeeHead.FeeCategoryID = Convert.ToInt32(((DropDownList)grdFeeHeads.FooterRow.FindControl("drpNewFeeCategoryName")).SelectedValue);
objFeeHead.CreatedDate = DateTime.Now;
objFeeHead.IsDelete = false;
objFeeHead.Insert();
grdFeeHeads.EditIndex = -1;
BindFeeHeads();
}
}
protected void grdFeeHeads_UpdateRow(object sendedr, GridViewUpdateEventArgs e)
{
int feeHeadID = Convert.ToInt32(grdFeeHeads.DataKeys[e.RowIndex].Value.ToString());
GridViewRow row = grdFeeHeads.Rows[e.RowIndex] as GridViewRow;
if (feeHeadID != 0)
{
TMSFeesHeadMaster objFeeHead = TMSFeesHeadMaster.Get(feeHeadID);
objFeeHead.FeeHeadName = (row.FindControl("txtFeeHeadName") as TextBox).Text;
objFeeHead.FeeCategoryID = Convert.ToInt32((row.FindControl("drpFeeCategoryName") as DropDownList).SelectedValue);
objFeeHead.Update();
}
grdFeeHeads.EditIndex = -1;
BindFeeHeads();
}
public static TMSFeesHeadMaster[] Search(System.Int32?feeHeadID, System.Int32?feeCategoryID, System.String feeHeadName, System.DateTime?createdDate, System.Boolean?isDelete)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFeesHeadMaster_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, feeHeadID, feeCategoryID, feeHeadName, createdDate, isDelete);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSFeesHeadMaster.MapFrom(ds));
}
private void BindFeeHeads()
{
var dsFeeHead = TMSFeesHeadMaster.GetAllFeeHeads();
if (dsFeeHead.Tables[0].Rows.Count < 1)
{
DataRow rw = dsFeeHead.Tables[0].NewRow();
rw["FeeCategoryName"] = rw["FeeHeadName"] = "";
rw["FeeCategoryID"] = rw["FeeHeadID"] = 0;
dsFeeHead.Tables[0].Rows.InsertAt(rw, 0);
grdFeeHeads.DataSource = dsFeeHead.Tables[0];
grdFeeHeads.DataBind();
grdFeeHeads.Rows[0].Visible = false;
}
else
{
grdFeeHeads.DataSource = dsFeeHead.Tables[0];
grdFeeHeads.DataBind();
}
}
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 TMSFeesHeadMaster[] MapFrom(DataSet ds)
{
List <TMSFeesHeadMaster> objects;
// Initialise Collection.
objects = new List <TMSFeesHeadMaster>();
// 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_FeesHeadMaster] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_FeesHeadMaster] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSFeesHeadMaster instance = new TMSFeesHeadMaster();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
public static void Update(TMSFeesHeadMaster tMSFeesHeadMaster, DbTransaction transaction)
{
tMSFeesHeadMaster.Update(transaction);
}
public static void Update(TMSFeesHeadMaster tMSFeesHeadMaster)
{
tMSFeesHeadMaster.Update();
}
public static TMSFeesHeadMaster[] Search(TMSFeesHeadMaster searchObject)
{
return Search ( searchObject.FeeHeadID, searchObject.FeeCategoryID, searchObject.FeeHeadName, searchObject.CreatedDate, searchObject.IsDelete);
}
public static TMSFeesHeadMaster[] MapFrom(DataSet ds)
{
List<TMSFeesHeadMaster> objects;
// Initialise Collection.
objects = new List<TMSFeesHeadMaster>();
// 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_FeesHeadMaster] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_FeesHeadMaster] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSFeesHeadMaster instance = new TMSFeesHeadMaster();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSFeesHeadMaster Get(System.Int32 feeHeadID)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSFeesHeadMaster instance;
instance = new TMSFeesHeadMaster();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFeesHeadMaster_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, feeHeadID);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSFeesHeadMaster ID:" + feeHeadID.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
public static TMSFeesHeadMaster[] Search(TMSFeesHeadMaster searchObject)
{
return(Search(searchObject.FeeHeadID, searchObject.FeeCategoryID, searchObject.FeeHeadName, searchObject.CreatedDate, searchObject.IsDelete));
}
public static void Update(TMSFeesHeadMaster tMSFeesHeadMaster, DbTransaction transaction)
{
tMSFeesHeadMaster.Update(transaction);
}
public static void Update(TMSFeesHeadMaster tMSFeesHeadMaster)
{
tMSFeesHeadMaster.Update();
}