public static CustomList <StockTransactionMaster> GetAllStockTransactionMaster() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <StockTransactionMaster> StockTransactionMasterCollection = new CustomList <StockTransactionMaster>(); IDataReader reader = null; const String sql = "select *from StockTransactionMaster"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { StockTransactionMaster newStockTransactionMaster = new StockTransactionMaster(); newStockTransactionMaster.SetData(reader); StockTransactionMasterCollection.Add(newStockTransactionMaster); } return(StockTransactionMasterCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
protected void btnSave_Click(object sender, EventArgs e) { try { CustomList<StockTransactionMaster> lstStockTransactionMaster = StockTransactionMasterList; if (lstStockTransactionMaster.Count == 0) { StockTransactionMaster newStockTransactionMaster = new StockTransactionMaster(); lstStockTransactionMaster.Add(newStockTransactionMaster); } SetDataFromControlToObj(ref lstStockTransactionMaster); CustomList<StockTransactionDetail> lstStockTransactionDetail = (CustomList<StockTransactionDetail>)StockTransactionDetailList; if (!((PageBase)this.Page).CheckUserAuthentication(lstStockTransactionMaster, lstStockTransactionDetail)) return; manager.SaveStockTransaction(ref lstStockTransactionMaster, ref lstStockTransactionDetail); txtCustomCode.Text = manager.CustomCode; ((PageBase)this.Page).SuccessMessage = (StaticInfo.SavedSuccessfullyMsg); } catch (SqlException ex) { ((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex)); } catch (Exception ex) { ((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getExceptionMessage(ex)); } }
private void PopulateStockTransaction(StockTransactionMaster objSTM) { try { txtCustomCode.Text = objSTM.CustomCode; txtTransactionDate.Text = objSTM.TransDate.ToShortDateString(); if (objSTM.FromBranchID != 0) ddlFromBranch.SelectedValue = objSTM.FromBranchID.ToString(); if (objSTM.FromCostCenterID != 0) ddlFromCostCentre.SelectedValue = objSTM.FromCostCenterID.ToString(); if (objSTM.FromStockLocationID != 0) ddlFromStockLocation.SelectedValue = objSTM.FromStockLocationID.ToString(); if (objSTM.ToBranchID != 0) ddlToBranch.SelectedValue = objSTM.ToBranchID.ToString(); if (objSTM.ToCostCenterID != 0) ddlToCostCentre.SelectedValue = objSTM.ToCostCenterID.ToString(); if (objSTM.ToStockLocationID != 0) ddlToStockLocation.SelectedValue = objSTM.ToStockLocationID.ToString(); if (objSTM.PartyID != 0) ddlParty.SelectedValue = objSTM.PartyID.ToString(); if (objSTM.CurrencyID != 0) ddlCurrencyID.SelectedValue = objSTM.CurrencyID.ToString(); if (ddlFromCostCentre.SelectedValue != "") ddlFromCostCentre_SelectedIndexChanged(null,null); if (ddlToCostCentre.SelectedValue != "") ddlToCostCentre_SelectedIndexChanged(null, null); StockTransactionDetailList = new CustomList<StockTransactionDetail>(); StockTransactionDetailList = manager.GetAllStockTransactionDetail(objSTM.StockTransID); } catch (Exception ex) { throw (ex); } }
public static CustomList<StockTransactionMaster> GetAllStockTransactionMaster() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<StockTransactionMaster> StockTransactionMasterCollection = new CustomList<StockTransactionMaster>(); IDataReader reader = null; const String sql = "select *from StockTransactionMaster"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { StockTransactionMaster newStockTransactionMaster = new StockTransactionMaster(); newStockTransactionMaster.SetData(reader); StockTransactionMasterCollection.Add(newStockTransactionMaster); } return StockTransactionMasterCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }