public static CustomList <POMaster> GetAllPOMaster() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <POMaster> POMasterCollection = new CustomList <POMaster>(); IDataReader reader = null; const String sql = "select *from POMaster"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { POMaster newPOMaster = new POMaster(); newPOMaster.SetData(reader); POMasterCollection.Add(newPOMaster); } return(POMasterCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
private void PopulatePO(POMaster objPO) { try { txtCustomCode.Text = objPO.CustomCode; txtTransactionDate.Text = objPO.PODate.ToShortDateString(); ddlCostCentre.SelectedValue = objPO.CostCenterID.ToString(); ddlBranch.SelectedValue = objPO.BranchID.ToString(); txtNote.Text = objPO.Description; txtShipTo.Text = objPO.ShipTo; txtBillTo.Text = objPO.BillTo; txtExpectedReceiveDate.Text = objPO.ExpectedReceiptDate.ToShortDateString(); ddlParty.SelectedValue = objPO.SupplierID.ToString(); PODetailList = new CustomList<PODetail>(); PODetailList = manager.GetAllPODetail(objPO.POID); } catch (Exception ex) { throw (ex); } }
public static CustomList<POMaster> GetAllPOMasterFind() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<POMaster> ItemRequisitionMasterCollection = new CustomList<POMaster>(); IDataReader reader = null; String sql = "spFindPO"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { POMaster newPOMaster = new POMaster(); newPOMaster.SetDataFind(reader); ItemRequisitionMasterCollection.Add(newPOMaster); } return ItemRequisitionMasterCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { CustomList<POMaster> lstPOMaster = POMasterList; if (lstPOMaster.Count == 0) { POMaster newPOMaster = new POMaster(); lstPOMaster.Add(newPOMaster); } SetDataFromControlToObj(ref lstPOMaster); CustomList<PODetail> lstPODetail = (CustomList<PODetail>)PODetailList; if (!((PageBase)this.Page).CheckUserAuthentication(lstPOMaster, lstPODetail)) return; manager.SavePO(ref lstPOMaster, ref lstPODetail); 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)); } }