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