예제 #1
0
        public List <Models.MOrders> GetAllbyid(int id)
        {
            List <Models.MOrders> model = new List <Models.MOrders>();
            var query = from o in obj.Orders where Convert.ToString(o.id) == id.ToString() select o;

            foreach (var item in query)
            {
                Models.MOrders m = new Models.MOrders();
                m.id               = Convert.ToString(item.id);
                m.OrdersNo         = item.OrderNo;
                m.OrderName        = item.OrderName;
                m.OrderDescription = item.OrderDescription;
                m.Orderdate        = Convert.ToString(item.OrderDate);
                m.deliverydate     = Convert.ToString(item.deliveryDate);
                m.TotalCost        = item.TotalCost;
                m.OrderType        = item.OrderType;
                m.ClientId         = Convert.ToString(item.ClientId);
                m.venorld          = Convert.ToString(item.VendorId);
                m.FiscalYearld     = Convert.ToString(item.FiscalYearId);
                m.eDate            = Convert.ToString(item.eDate);
                model.Add(m);
            }

            return(model);
        }
예제 #2
0
        public int Update(Models.MOrders model)
        {
            Common.Logger l         = new Common.Logger();
            string        ClassName = "COrder";

            try
            {
                var query = from o in obj.Orders where Convert.ToString(o.id) == Convert.ToString(model.id) select o;

                foreach (var item in query)
                {
                    item.OrderNo          = model.OrdersNo;
                    item.OrderName        = model.OrderName;
                    item.OrderDescription = model.OrderDescription;
                    item.OrderDate        = Convert.ToDateTime(model.Orderdate);
                    item.deliveryDate     = Convert.ToDateTime(model.deliverydate);
                    item.TotalCost        = model.TotalCost;
                    item.OrderType        = model.OrderType;
                    item.ClientId         = Convert.ToInt32(model.ClientId);
                    item.VendorId         = Convert.ToInt32(model.venorld);
                    item.FiscalYearId     = Convert.ToInt32(model.FiscalYearld);
                    item.eDate            = Convert.ToDateTime(model.eDate);
                }
                l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] OrderNo[" + model.OrdersNo + "] OrderName[" + model.OrderName + "] Orderdescription[" + model.OrderDescription + "] OrderDate[ " + model.Orderdate + " ] DeliveryDate[ " + model.deliverydate + " ] TotalCost [ " + model.TotalCost + " ] OrdersType [ " + model.ClientId + "] VendoeId [ " + model.venorld + " ] FiscalId [ " + model.FiscalYearld + "] eDate [ " + model.eDate + " ]");
                obj.SubmitChanges();
                l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully");
                return(1);
            }
            catch (Exception ex)
            {
                l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
                return(-1);
            }
        }
예제 #3
0
        public List <Models.MOrders> GetAll()
        {
            List <Models.MOrders> model = new List <Models.MOrders>();
            var query = from o in obj.Orders select o;

            foreach (var item in query)
            {
                Models.MOrders m = new Models.MOrders();
                m.id                 = Convert.ToString(item.id);
                m.OrdersNo           = item.OrderNo;
                m.OrderName          = item.OrderName;
                m.OrderDescription   = item.OrderDescription;
                m.Orderdate          = Convert.ToString(item.OrderDate);
                m.deliverydate       = Convert.ToString(item.deliveryDate);
                m.TotalCost          = item.TotalCost;
                m.OrderType          = item.OrderType;
                m.ClientId           = Convert.ToString(item.ClientId);
                m.venorld            = Convert.ToString(item.VendorId);
                m.FiscalYearld       = Convert.ToString(item.FiscalYearId);
                m.eDate              = Convert.ToString(item.eDate);
                m.InstallmentDueDate = item.InstallmentDueDate;
                m.Installments       = item.Installments;
                m.ModeOfPayment      = item.ModeOfPayment;
                m.WareHouseId        = item.WareHouseId.ToString();
                m.GrantorName        = item.GrantorName;
                model.Add(m);
            }

            return(model);
        }
예제 #4
0
        public int Save(Models.MOrders model)
        {
            Common.Logger l         = new Common.Logger();
            string        ClassName = "COrders";

            try
            {
                DB.Order bs = new DB.Order();
                //bs.id = Convert.ToInt32(model.id);
                bs.OrderNo            = model.OrdersNo;
                bs.OrderName          = model.OrderName;
                bs.OrderDescription   = model.OrderDescription;
                bs.OrderDate          = Convert.ToDateTime(model.Orderdate);
                bs.deliveryDate       = Convert.ToDateTime(model.deliverydate);
                bs.TotalCost          = model.TotalCost;
                bs.OrderType          = model.OrderType;
                bs.ClientId           = Convert.ToInt32(model.ClientId);
                bs.VendorId           = Convert.ToInt32(model.venorld);
                bs.FiscalYearId       = Convert.ToInt32(model.FiscalYearld);
                bs.eDate              = Convert.ToDateTime(model.eDate);
                bs.WareHouseId        = Convert.ToInt32(model.WareHouseId);
                bs.Installments       = model.Installments;
                bs.InstallmentDueDate = model.InstallmentDueDate;
                bs.ModeOfPayment      = model.ModeOfPayment;
                bs.GrantorName        = model.GrantorName;
                l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] OrderNo[" + model.OrdersNo + "] OrderName[" + model.OrderName + "] Orderdescription[" + model.OrderDescription + "] OrderDate[ " + model.Orderdate + " ] DeliveryDate[ " + model.deliverydate + " ] TotalCost [ " + model.TotalCost + " ] OrdersType [ " + model.ClientId + "] VendoeId [ " + model.venorld + " ] FiscalId [ " + model.FiscalYearld + "] eDate [ " + model.eDate + " ]");
                obj.Orders.InsertOnSubmit(bs);
                obj.SubmitChanges();



                l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully");
                return(1);
            }
            catch (Exception ex)
            {
                l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
                return(-1);
            }
        }
예제 #5
0
        private int SaveOrders()
        {
            try
            {
                Classes.CDefaultCashAccount cda = new Classes.CDefaultCashAccount();
                Classes.CDefaultAccount     cba = new Classes.CDefaultAccount();

                int    OrderId            = 0;
                string OrderNo            = txtOrderNo.Text;
                string OrderName          = txtOrderName.Text;
                string OrderDescription   = txtOrderDescription.Text;
                string OrderDate          = txtOrderDate.Text;
                string OrderDeliveryDate  = txtDeliveryOfOrderDate.Text;
                string TotalCost          = ReturnTotalOrderCost().ToString();
                string OrderType          = ddlOrderType.SelectedValue;
                string VendorId           = ddlVendor.SelectedValue;
                string ClientId           = ddlCustomer.SelectedValue;
                string WareHouseId        = Session["WareHouse"].ToString();
                string ModeOfPayment      = ddlModeOfPayment.SelectedItem.Text;
                string Installments       = txtInstallments.Text;
                string InstallmentDueDate = txtIntallmentDueDate.Text;
                if (OrderType == "1")
                {
                    OrderType = "Order To Client";
                }
                else if (OrderType == "2")
                {
                    OrderType = "Order To Vendor";
                }
                else
                {
                    return(-2);
                }
                if (ModeOfPayment == "Please Select")
                {
                    return(-8);
                }
                Models.MOrders mr = new Models.MOrders();
                mr.OrdersNo           = OrderNo;
                mr.OrderName          = OrderName;
                mr.OrderDescription   = OrderDescription;
                mr.Orderdate          = OrderDate;
                mr.deliverydate       = OrderDeliveryDate;
                mr.TotalCost          = TotalCost;
                mr.OrderType          = OrderType;
                mr.eDate              = DateTime.Now.ToShortDateString();
                mr.FiscalYearld       = Session["FiscalYear"].ToString();
                mr.WareHouseId        = WareHouseId;
                mr.ModeOfPayment      = ModeOfPayment;
                mr.Installments       = Installments;
                mr.InstallmentDueDate = InstallmentDueDate;

                if (OrderType.EndsWith("Vendor"))
                {
                    mr.venorld  = VendorId;
                    mr.ClientId = "-1";
                    if (Convert.ToInt32(VendorId) < 0)
                    {
                        return(-5);
                    }
                }
                else
                {
                    if (cbGrantor.Checked)
                    {
                        string GrantorName = txtGrantorInfo.Text;
                        mr.GrantorName = GrantorName;
                    }

                    mr.ClientId = ClientId;
                    mr.venorld  = "-1";
                    if (Convert.ToInt32(ClientId) < 0)
                    {
                        return(-6);
                    }
                }
                Classes.COrders co = new Classes.COrders();
                if (Convert.ToInt32(WareHouseId) < 0)
                {
                    return(-7);
                }

                //Saving Order
                if (co.Save(mr) < 0)
                {
                    return(-1);
                }

                OrderId = co.GetLastOrderID();
                if (OrderId < 0)
                {
                    return(-3);
                }
                //Saving Order Products

                #region objects
                Models.MOrdersLine       mor = new Models.MOrdersLine();
                Models.MSaleTransactions ms  = new Models.MSaleTransactions();
                Classes.CSaleTransations ct  = new Classes.CSaleTransations();
                Classes.COrderOnline     cor = new Classes.COrderOnline();
                Models.MInventory        mi  = new Models.MInventory();
                Classes.CInventory       ci  = new Classes.CInventory();
                float OrderTotalCost         = 0;

                #endregion
                for (int i = 0; i < grdProducts.Rows.Count; i++)
                {
                    #region objects initializing
                    mor = new Models.MOrdersLine();
                    ms  = new Models.MSaleTransactions();
                    ct  = new Classes.CSaleTransations();
                    cor = new Classes.COrderOnline();
                    mi  = new Models.MInventory();
                    ci  = new Classes.CInventory();
                    DropDownList ddlProduct = (DropDownList)grdProducts.Rows[i].FindControl("ddlProducts");
                    TextBox      txtCp      = (TextBox)grdProducts.Rows[i].FindControl("txtCp");
                    TextBox      txtSp      = (TextBox)grdProducts.Rows[i].FindControl("txtSp");
                    TextBox      txtUnits   = (TextBox)grdProducts.Rows[i].FindControl("txtUnits");
                    TextBox      txtTotal   = (TextBox)grdProducts.Rows[i].FindControl("txtTotal");
                    string       ProductId  = ddlProduct.SelectedValue;
                    string       CostPrice  = txtCp.Text;
                    string       SalePrice  = txtSp.Text;
                    string       TotalUnits = txtUnits.Text;
                    string       totalCost  = (Convert.ToInt32(TotalUnits) * Convert.ToInt32(SalePrice)).ToString();
                    OrderTotalCost += Convert.ToSingle(totalCost);
                    #endregion

                    //OrderLine
                    #region OrderLine
                    mor.OrderId   = OrderId.ToString();
                    mor.ProductId = ProductId;
                    if (OrderType.EndsWith("Vendor"))
                    {
                        mor.SalePrice = CostPrice;
                    }
                    else
                    {
                        mor.SalePrice = SalePrice;
                    }
                    mor.unit             = TotalUnits;
                    mor.totalProductCost = totalCost;
                    mor.eDate            = DateTime.Now.ToShortDateString();
                    if (cor.Save(mor) < 0)
                    {
                        return(-3);
                    }
                    #endregion

                    //Sale transaction
                    #region Sale Transaction

                    ms.ProductID   = ProductId;
                    ms.clientID    = ClientId;
                    ms.CostPrice   = CostPrice;
                    ms.SalePrice   = SalePrice;
                    ms.units       = TotalUnits;
                    ms.clientID    = ClientId;
                    ms.VendorID    = VendorId;
                    ms.date        = Convert.ToDateTime(txtOrderDate.Text);
                    ms.WareHouseId = WareHouseId;
                    ms.OrderId     = OrderId.ToString();
                    if (OrderType.EndsWith("Vendor"))
                    {
                        ms.transactionType = Common.Constants.SaleTransactions.Addition.ToString();
                    }
                    else
                    {
                        ms.transactionType = Common.Constants.SaleTransactions.Deduction.ToString();
                    }


                    //sale transaction
                    if (ct.Save(ms) < 0)
                    {
                        return(-1);
                    }
                    #endregion


                    //Inventory
                    #region Inventory
                    mi.ProductId    = ProductId;
                    mi.WareHouseld  = WareHouseId;
                    mi.Quantity     = TotalUnits;
                    mi.FiscalYearld = Session["FiscalYear"].ToString();
                    mi.Date         = Convert.ToDateTime(OrderDate);
                    mi.Cost         = CostPrice;
                    if (OrderType.EndsWith("Vendor"))
                    {
                        //  mi.Cost = CostPrice;
                        if (ci.Save(mi, Common.Constants.SaleTransactions.Addition) < 0)
                        {
                            return(-4);
                        }
                    }
                    else
                    {
                        //   mi.Cost = SalePrice;
                        if (ci.Save(mi, Common.Constants.SaleTransactions.Deduction) < 0)
                        {
                            return(-4);
                        }
                    }
                    #endregion

                    //Accounts
                    #region Accounts
                    if (OrderType.Contains("Vendor"))
                    {
                        Classes.CJournal cj = new Classes.CJournal();
                        Models.MJournal  mj = new Models.MJournal();
                        mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString();
                        mj.amount = totalCost;
                        mj.des    = "Order Of Inventory for Vendor of Product Id [" + ProductId + "] units [" + TotalUnits + "] ";
                        mj.e_date = (OrderDate);
                        mj.type   = Common.Constants.Accounts.Type.Debit.ToString();
                        cj.Save(mj);

                        mj        = new Models.MJournal();
                        mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsPayable).ToString();
                        mj.amount = totalCost;
                        mj.des    = "Order Of Inventory for Vendor of Product Id [" + ProductId + "] units [" + TotalUnits + "] ";
                        mj.e_date = (OrderDate);
                        mj.type   = Common.Constants.Accounts.Type.Credit.ToString();
                        cj.Save(mj);
                    }
                    else if (OrderType.Contains("Client"))
                    {
                        Classes.CJournal cj = new Classes.CJournal();
                        Models.MJournal  mj = new Models.MJournal();
                        mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsRecievalbes).ToString();
                        mj.amount = totalCost;
                        mj.des    = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] ";
                        mj.e_date = (OrderDate);
                        mj.type   = Common.Constants.Accounts.Type.Debit.ToString();
                        cj.Save(mj);

                        cj        = new Classes.CJournal();
                        mj        = new Models.MJournal();
                        mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales).ToString();
                        mj.amount = totalCost;
                        mj.des    = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] ";
                        mj.e_date = (OrderDate);
                        mj.type   = Common.Constants.Accounts.Type.Credit.ToString();
                        cj.Save(mj);


                        cj        = new Classes.CJournal();
                        mj        = new Models.MJournal();
                        mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold).ToString();
                        mj.amount = totalCost;
                        mj.des    = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] ";
                        mj.e_date = (OrderDate);
                        mj.type   = Common.Constants.Accounts.Type.Debit.ToString();
                        cj.Save(mj);

                        cj        = new Classes.CJournal();
                        mj        = new Models.MJournal();
                        mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString();
                        mj.amount = totalCost;
                        mj.des    = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] ";
                        mj.e_date = (OrderDate);
                        mj.type   = Common.Constants.Accounts.Type.Credit.ToString();
                        cj.Save(mj);
                    }
                    #endregion
                }

                //Payments
                #region Payments
                Classes.CPayment cap           = new Classes.CPayment();
                Models.MPayments map           = new Models.MPayments();
                string           TransactionId = ct.GetLastTransactionId().ToString();
                if (ddlOrderType.SelectedItem.Text.Contains("Vendor"))
                {
                    map.ClientId = -1;
                    map.VendorId = Convert.ToInt32(VendorId);
                }
                else if (ddlOrderType.SelectedItem.Text.Contains("Client"))
                {
                    map.ClientId = Convert.ToInt32(ClientId);
                    map.VendorId = -1;
                }
                map.TransactionId = Convert.ToInt32(TransactionId);
                map.Paid          = "0";
                map.TotalCost     = OrderTotalCost.ToString();
                map.OrderId       = OrderId;
                map.PaymentType   = Common.Constants.PaymentTypes.Partial.ToString();
                map.Paymentstate  = Common.Constants.PaymentState.NotPaid.ToString();
                if (cap.Save(map) < 0)
                {
                    return(-4);
                }
                #endregion

                return(1);
            }
            catch
            {
                return(-1);
            }
        }