Пример #1
0
        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();
                }
            }
        }
Пример #2
0
 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);
     }
 }
Пример #3
0
 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();
     }
 }
Пример #4
0
        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));
            }
        }