protected void btnSaveAdd_Click(object sender, EventArgs e) { if (!this.Page.IsValid) { return; } if (this.txtItemName.Text.Trim().Length > 0) { this.objItemMasterDT = this.objItemMasterBll.GetDataByItemName(int.Parse(this.hfCompanyID.Value), this.txtItemName.Text.Trim()); if (this.objItemMasterDT.Rows.Count > 0) { this.checkInDB = true; this.DisplayAlert("Item Already Exists..!"); } if (this.checkInDB) { return; } Decimal?dUnitCost = new Decimal?(); Decimal?dQuantity = new Decimal?(); Decimal?dCurrentStock = new Decimal?(); int? iTaskID1 = new int?(); int? iTaskID2 = new int?(); if (this.ddlTax.SelectedIndex > 0) { iTaskID1 = new int?(int.Parse(this.ddlTax.SelectedItem.Value)); } if (this.ddlTax2.SelectedIndex > 0) { iTaskID2 = new int?(int.Parse(this.ddlTax2.SelectedItem.Value)); } if (this.txtQuantity.Text.Trim().Length > 0) { dQuantity = new Decimal?(Decimal.Parse(this.txtQuantity.Text.Trim())); } if (this.txtCurrentStock.Text.Trim().Length > 0) { dCurrentStock = new Decimal?(Decimal.Parse(this.txtCurrentStock.Text.Trim())); } if (this.txtUnitCost.Text.Trim().Length > 0) { dUnitCost = new Decimal?(Decimal.Parse(this.txtUnitCost.Text.Trim())); } if (this.objItemMasterBll.AddItem(int.Parse(this.hfCompanyID.Value), this.txtItemName.Text.Trim(), this.txtItemDesc.Text.Trim(), dUnitCost, dQuantity, iTaskID1, iTaskID2, this.chkInventory.Checked, dCurrentStock, true, false, false) != 0) { this.Session["saveItem"] = (object)1; this.DisplayAlert("Details Added Successfully."); this.btnAdd_Click(sender, e); } else { this.DisplayAlert("Fail to Add New Details."); this.Clear(); } } else { this.DisplayAlert("Please Fill All Details...!"); } }
public virtual CloudAccountDA.ItemMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.ItemMasterDataTable dataTable = new CloudAccountDA.ItemMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.ItemMasterDataTable UpdateWhenDelete(int?ItemID, bool?Active, bool?Deleted) { this.Adapter.SelectCommand = this.CommandCollection[8]; if (ItemID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = ItemID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (Active.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = Active.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (Deleted.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = Deleted.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } CloudAccountDA.ItemMasterDataTable dataTable = new CloudAccountDA.ItemMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void SetRecord(string iD) { this.objItemMasterDT = this.objItemMasterBll.GetDataByItemID(int.Parse(iD)); if (this.objItemMasterDT.Rows.Count <= 0) { return; } this.hfItemID.Value = this.objItemMasterDT.Rows[0]["ItemID"].ToString(); this.hfCompanyID.Value = this.objItemMasterDT.Rows[0]["CompanyID"].ToString(); this.txtItemName.Text = this.objItemMasterDT.Rows[0]["ItemName"].ToString(); this.txtItemDesc.Text = this.objItemMasterDT.Rows[0]["Description"].ToString(); this.txtUnitCost.Text = this.objItemMasterDT.Rows[0]["UnitCost"].ToString(); this.txtCurrentStock.Text = this.objItemMasterDT.Rows[0]["CurrentStock"].ToString(); this.txtQuantity.Text = this.objItemMasterDT.Rows[0]["Quantity"].ToString(); this.chkInventory.Checked = bool.Parse(this.objItemMasterDT.Rows[0]["TrackInventory"].ToString()); this.chkInventory_CheckedChanged((object)null, (EventArgs)null); string str1 = this.objItemMasterDT.Rows[0]["TaxID1"].ToString(); string str2 = this.objItemMasterDT.Rows[0]["TaxID2"].ToString(); if (!string.IsNullOrEmpty(str1)) { this.ddlTax.SelectedValue = str1; } if (string.IsNullOrEmpty(str2)) { return; } this.ddlTax.SelectedValue = str2; }
private void ViewRecord(string iD) { this.objItemMasterDT = this.objItemMasterBll.GetDataByItemID(int.Parse(iD)); if (this.objItemMasterDT.Rows.Count <= 0) { return; } this.hfItemID.Value = this.objItemMasterDT.Rows[0]["ItemID"].ToString(); this.hfCompanyID.Value = this.objItemMasterDT.Rows[0]["CompanyID"].ToString(); this.lblItemName.Text = this.objItemMasterDT.Rows[0]["ItemName"].ToString(); this.lblItemDesc.Text = this.objItemMasterDT.Rows[0]["Description"].ToString(); this.lblUnitCost.Text = this.objItemMasterDT.Rows[0]["UnitCost"].ToString(); this.lblCurrentStock.Text = this.objItemMasterDT.Rows[0]["CurrentStock"].ToString(); this.lblQuantity.Text = this.objItemMasterDT.Rows[0]["Quantity"].ToString(); this.lblInventory.Text = this.objItemMasterDT.Rows[0]["TrackInventory"].ToString(); string s1 = this.objItemMasterDT.Rows[0]["TaxID1"].ToString(); string s2 = this.objItemMasterDT.Rows[0]["TaxID2"].ToString(); if (!string.IsNullOrEmpty(s1)) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(s1)); this.lblTax.Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); } if (string.IsNullOrEmpty(s2)) { return; } this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(s2)); this.lblTax2.Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); }
public virtual int Fill(CloudAccountDA.ItemMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
public virtual CloudAccountDA.ItemMasterDataTable DeleteByCompanyID(int?CompanyID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.ItemMasterDataTable dataTable = new CloudAccountDA.ItemMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
protected void gvItemView_OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) { return; } string text1 = e.Row.Cells[0].Text; string text2 = e.Row.Cells[4].Text; string text3 = e.Row.Cells[5].Text; this.objItemMasterDT = this.objItemMasterBll.GetDataByItemID(int.Parse(text1)); if (this.objItemMasterDT.Rows.Count > 0) { e.Row.Cells[0].Text = this.objItemMasterDT.Rows[0]["ItemName"].ToString(); } try { if (!string.IsNullOrEmpty(text2) && !text2.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(text2)); if (this.objTaxMasterDT.Rows.Count > 0) { e.Row.Cells[4].Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); } } if (string.IsNullOrEmpty(text3) || text3.Contains("&")) { return; } this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(text3)); if (this.objTaxMasterDT.Rows.Count <= 0) { return; } e.Row.Cells[5].Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); } catch (Exception ex) { e.Row.Cells[4].Text = ""; e.Row.Cells[5].Text = ""; } }
public virtual CloudAccountDA.ItemMasterDataTable UpdateCurrentStock(int?ItemID, decimal?CurrentStock) { this.Adapter.SelectCommand = this.CommandCollection[6]; if (ItemID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = ItemID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (CurrentStock.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = CurrentStock.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } CloudAccountDA.ItemMasterDataTable dataTable = new CloudAccountDA.ItemMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.ItemMasterDataTable GetDataByItemName(int?CompanyID, string ItemName) { this.Adapter.SelectCommand = this.CommandCollection[5]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (ItemName == null) { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = ItemName; } CloudAccountDA.ItemMasterDataTable dataTable = new CloudAccountDA.ItemMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Update(CloudAccountDA.ItemMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }
public virtual CloudAccountDA.ItemMasterDataTable GetDataByCompanyIDAndStatus(int?CompanyID, bool?Active, bool?Archived, bool?Deleted, string ItemName, string ItemDesc, string Tax, decimal?UnitCostTo, decimal?UnitCostFrom, decimal?InvetoryTo, decimal?InvetoryFrom, decimal?QuantityTo, decimal?QuantityFrom) { this.Adapter.SelectCommand = this.CommandCollection[3]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (Active.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = Active.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (Archived.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = Archived.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } if (Deleted.HasValue) { this.Adapter.SelectCommand.Parameters[4].Value = Deleted.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = DBNull.Value; } if (ItemName == null) { this.Adapter.SelectCommand.Parameters[5].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[5].Value = ItemName; } if (ItemDesc == null) { this.Adapter.SelectCommand.Parameters[6].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[6].Value = ItemDesc; } if (Tax == null) { this.Adapter.SelectCommand.Parameters[7].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[7].Value = Tax; } if (UnitCostTo.HasValue) { this.Adapter.SelectCommand.Parameters[8].Value = UnitCostTo.Value; } else { this.Adapter.SelectCommand.Parameters[8].Value = DBNull.Value; } if (UnitCostFrom.HasValue) { this.Adapter.SelectCommand.Parameters[9].Value = UnitCostFrom.Value; } else { this.Adapter.SelectCommand.Parameters[9].Value = DBNull.Value; } if (InvetoryTo.HasValue) { this.Adapter.SelectCommand.Parameters[10].Value = InvetoryTo.Value; } else { this.Adapter.SelectCommand.Parameters[10].Value = DBNull.Value; } if (InvetoryFrom.HasValue) { this.Adapter.SelectCommand.Parameters[11].Value = InvetoryFrom.Value; } else { this.Adapter.SelectCommand.Parameters[11].Value = DBNull.Value; } if (QuantityTo.HasValue) { this.Adapter.SelectCommand.Parameters[12].Value = QuantityTo.Value; } else { this.Adapter.SelectCommand.Parameters[12].Value = DBNull.Value; } if (QuantityFrom.HasValue) { this.Adapter.SelectCommand.Parameters[13].Value = QuantityFrom.Value; } else { this.Adapter.SelectCommand.Parameters[13].Value = DBNull.Value; } CloudAccountDA.ItemMasterDataTable dataTable = new CloudAccountDA.ItemMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }