public static TMSOtherExpensesDetails Get(System.Int64 spoeDetailsId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSOtherExpensesDetails instance;
instance = new TMSOtherExpensesDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSOtherExpensesDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, spoeDetailsId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) //throw new ApplicationException("Could not get TMSOtherExpensesDetails ID:" + spoeDetailsId.ToString()+ " from Database.");
// Return results.
{
return(null);
}
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
protected void BindStationaryPrinting_ExpenseMonthWise()
{
try
{
DataTable dtExpensesDetails = null;
if (ViewState["Sort"] != null)
{
dtExpensesDetails = TMSOtherExpensesDetails.GetExpenseDetailsMonthAndYearWise(Convert.ToInt64(Session["UserId"]), null, ddlMonth1.SelectedItem.Text, ddlYear1.SelectedItem.Text).Tables[0];
}
else
{
dtExpensesDetails = TMSOtherExpensesDetails.GetExpenseDetailsMonthAndYearWise(Convert.ToInt64(Session["UserId"]), null, null, null).Tables[0];
}
if (dtExpensesDetails.Rows.Count > 0)
{
grdPrintingStationary.DataSource = dtExpensesDetails;
grdPrintingStationary.DataBind();
}
else
{
grdPrintingStationary.DataSource = null;
grdPrintingStationary.DataBind();
}
}
catch (Exception ex) { }
}
protected void grdExpensesDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
dvMsg.Visible = false;
ddlYear1.Visible = false;
ddlMonth1.Visible = false;
GridViewRow row = grdExpensesDetails.Rows[e.RowIndex];
TextBox txtTotalAmount = (TextBox)row.FindControl("txtTotalAmount");
Label lblExpensesDetailsId = (Label)row.FindControl("lblExpensesDetailsId");
Int64 ExpensesDetailsId = Convert.ToInt64(lblExpensesDetailsId.Text);
TMSOtherExpensesDetails objExpenseDetails = TMSOtherExpensesDetails.Get(ExpensesDetailsId);
if (objExpenseDetails != null)
{
objExpenseDetails.SPOETotalAmount = Convert.ToDouble(txtTotalAmount.Text);
objExpenseDetails.Update();
BindEXpenseGridView();
grdExpensesDetails.EditIndex = -1;
dvMsg.Visible = true;
lblMessage.Text = "Record Updated Successfully";
dvMsg.Attributes.Add("class", "warring_msg");
BindEXpenseGridView();
}
}
catch (Exception ex) { }
}
public static TMSOtherExpensesDetails[] Search(System.Int64?spoeDetailsId, System.String spoeTitle, System.String spoeItemName, System.String spoeType, System.String spoeQuantity, System.String spoeDescription, System.Double?spoeTotalAmount, System.String spoeMonth, System.String spoeYear, System.DateTime?spoeTransactionDate, System.Int64?spoeAddedById, System.String spoeAddedByRemark, System.String spoeExtraOne, System.String spoeExtraTwo, System.DateTime?spoeDate, System.Int32?spoeStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSOtherExpensesDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, spoeDetailsId, spoeTitle, spoeItemName, spoeType, spoeQuantity, spoeDescription, spoeTotalAmount, spoeMonth, spoeYear, spoeTransactionDate, spoeAddedById, spoeAddedByRemark, spoeExtraOne, spoeExtraTwo, spoeDate, spoeStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSOtherExpensesDetails.MapFrom(ds));
}
protected void BindEXpenseGridView()
{
try
{
DataTable dtExpense = TMSOtherExpensesDetails.GetAllExpensesDetails(null, "Other Expenses", null, null, null, null, null, null, Convert.ToInt64(Session["UserId"]), null).Tables[0];
if (dtExpense.Rows.Count > 0)
{
grdExpensesDetails.DataSource = dtExpense;
grdExpensesDetails.DataBind();
}
else
{
grdExpensesDetails.DataSource = null;
grdExpensesDetails.DataBind();
}
}
catch (Exception ex) { }
}
protected void grdExpensesDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
string cmdName = e.CommandName.ToString();
if (cmdName == "Edit1")
{
Int64 ExpenseDetailsId = Convert.ToInt64(e.CommandArgument);
grdExpensesDetails.Visible = false;
fieldsetAddBill.Visible = true;
btnSave.Text = "Update";
TMSOtherExpensesDetails objExpenseDetails = TMSOtherExpensesDetails.Get(ExpenseDetailsId);
if (objExpenseDetails != null)
{
}
}
}
catch (Exception ex) { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DataTable dtAlreadyExists = TMSOtherExpensesDetails.GetAllExpensesDetails(null, "Other Expenses", Convert.ToString(txtItemName.Text), Convert.ToString(ddlType.SelectedItem.Text), null, Convert.ToString(ddlMonth.SelectedItem.Text), Convert.ToString(ddlYear.SelectedItem.Text), null, Convert.ToInt64(Session["UserId"]), null).Tables[0];
if (dtAlreadyExists.Rows.Count > 0)
{
dvMsg.Visible = true;
lblMessage.Text = "Details Are Already Added For This Month !!!";
dvMsg.Attributes.Add("class", "error_msg");
}
else
{
TMSOtherExpensesDetails objExpense = new TMSOtherExpensesDetails();
objExpense.SPOEType = ddlType.SelectedValue.ToString();
objExpense.SPOETitle = "Other Expenses";
objExpense.SPOEItemName = txtItemName.Text;
objExpense.SPOEQuantity = txtQuantity.Text;
objExpense.SPOETotalAmount = Convert.ToDouble(txtCost.Text);
objExpense.SPOEMonth = ddlMonth.SelectedItem.Text;
objExpense.SPOEYear = ddlYear.SelectedItem.Text;
objExpense.SPOEAddedById = Convert.ToInt64(Session["UserId"]);
objExpense.SPOEAddedByRemark = ddlType.SelectedItem.Value + " " + "Expense";
objExpense.SPOEDate = DateTime.Now;
objExpense.SPOEStatus = 1;
objExpense.Insert();
txtCost.Text = "";
txtItemName.Text = "";
txtQuantity.Text = "";
ddlYear.SelectedValue = "2012";
ddlMonth.SelectedValue = "June";
ddlType.SelectedValue = "LandBuilding";
dvMsg.Visible = true;
lblMessage.Text = ddlType.SelectedItem.Text + " Expenses Added Successfully!!!";
dvMsg.Attributes.Add("class", "warring_msg");
BindEXpenseGridView();
}
}
catch (Exception ex) { }
}
public static TMSOtherExpensesDetails[] MapFrom(DataSet ds)
{
List <TMSOtherExpensesDetails> objects;
// Initialise Collection.
objects = new List <TMSOtherExpensesDetails>();
// 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_OtherExpensesDetails] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_OtherExpensesDetails] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSOtherExpensesDetails instance = new TMSOtherExpensesDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
private void ViewPopUp(string Type, string MonthName, string CurrentYear)
{
try
{
string ExpenseType = Type;
string Month = MonthName;
string Year = CurrentYear;
DataTable dtExpensePopUp = TMSOtherExpensesDetails.ViewPopUpDetailsMonthAndYearWise(Convert.ToInt64(Session["UserId"]), ExpenseType, Month, Year).Tables[0];
if (dtExpensePopUp.Rows.Count > 0)
{
grdExpensePopUp.DataSource = dtExpensePopUp;
grdExpensePopUp.DataBind();
}
else
{
grdExpensePopUp.DataSource = null;
grdExpensePopUp.DataBind();
}
}
catch (Exception ex) { }
}
public static void Update(TMSOtherExpensesDetails tMSOtherExpensesDetails, DbTransaction transaction)
{
tMSOtherExpensesDetails.Update(transaction);
}
public static void Update(TMSOtherExpensesDetails tMSOtherExpensesDetails)
{
tMSOtherExpensesDetails.Update();
}
public static TMSOtherExpensesDetails[] Search(TMSOtherExpensesDetails searchObject)
{
return Search ( searchObject.SPOEDetailsId, searchObject.SPOETitle, searchObject.SPOEItemName, searchObject.SPOEType, searchObject.SPOEQuantity, searchObject.SPOEDescription, searchObject.SPOETotalAmount, searchObject.SPOEMonth, searchObject.SPOEYear, searchObject.SPOETransactionDate, searchObject.SPOEAddedById, searchObject.SPOEAddedByRemark, searchObject.SPOEExtraOne, searchObject.SPOEExtraTwo, searchObject.SPOEDate, searchObject.SPOEStatus);
}
public static TMSOtherExpensesDetails[] MapFrom(DataSet ds)
{
List<TMSOtherExpensesDetails> objects;
// Initialise Collection.
objects = new List<TMSOtherExpensesDetails>();
// 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_OtherExpensesDetails] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_OtherExpensesDetails] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSOtherExpensesDetails instance = new TMSOtherExpensesDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSOtherExpensesDetails Get(System.Int64 spoeDetailsId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSOtherExpensesDetails instance;
instance = new TMSOtherExpensesDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSOtherExpensesDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, spoeDetailsId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) //throw new ApplicationException("Could not get TMSOtherExpensesDetails ID:" + spoeDetailsId.ToString()+ " from Database.");
// Return results.
return null;
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
public static void Update(TMSOtherExpensesDetails tMSOtherExpensesDetails)
{
tMSOtherExpensesDetails.Update();
}
public static DataSet GetSearch(TMSOtherExpensesDetails searchObject)
{
return(GetSearch(searchObject.SPOEDetailsId, searchObject.SPOETitle, searchObject.SPOEItemName, searchObject.SPOEType, searchObject.SPOEQuantity, searchObject.SPOEDescription, searchObject.SPOETotalAmount, searchObject.SPOEMonth, searchObject.SPOEYear, searchObject.SPOETransactionDate, searchObject.SPOEAddedById, searchObject.SPOEAddedByRemark, searchObject.SPOEExtraOne, searchObject.SPOEExtraTwo, searchObject.SPOEDate, searchObject.SPOEStatus));
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DataTable dtAlreadyExists = TMSOtherExpensesDetails.GetAllExpensesDetails(null, "Printing And Stationary", Convert.ToString(txtItemName.Text), Convert.ToString(ddlType.SelectedItem.Text), null, Convert.ToString(ddlMonth.SelectedItem.Text), Convert.ToString(ddlYear.SelectedItem.Text), null, Convert.ToInt64(Session["UserId"]), null).Tables[0];
if (dtAlreadyExists.Rows.Count > 0)
{
dvMsg.Visible = true;
lblMessage.Text = "Details Are Already Added For This Month !!!";
dvMsg.Attributes.Add("class", "error_msg");
}
else
{
TMSOtherExpensesDetails objExpense = new TMSOtherExpensesDetails();
objExpense.SPOEType = ddlType.SelectedItem.Text;
objExpense.SPOETitle = "Printing And Stationary";
objExpense.SPOEItemName = txtItemName.Text;
objExpense.SPOEQuantity = txtQuantity.Text;
objExpense.SPOETotalAmount = Convert.ToDouble(txtCost.Text);
objExpense.SPOEMonth = ddlMonth.SelectedItem.Text;
objExpense.SPOEYear = ddlYear.SelectedItem.Text;
objExpense.SPOEAddedById=Convert.ToInt64(Session["UserId"]);
objExpense.SPOEAddedByRemark =ddlType.SelectedItem.Text +" "+ "Expense";
objExpense.SPOEDate = DateTime.Now;
objExpense.SPOEStatus = 1;
objExpense.Insert();
txtCost.Text = "";
txtItemName.Text = "";
txtQuantity.Text = "";
ddlYear.SelectedValue = "2012";
ddlMonth.SelectedValue = "June";
ddlType.SelectedValue = "Stationary";
dvMsg.Visible = true;
lblMessage.Text = ddlType.SelectedItem.Text+" Bill Details added Successfully!!!";
dvMsg.Attributes.Add("class", "warring_msg");
BindEXpenseGridView();
}
}
catch (Exception ex) { }
}
public static void Update(TMSOtherExpensesDetails tMSOtherExpensesDetails, DbTransaction transaction)
{
tMSOtherExpensesDetails.Update(transaction);
}
