コード例 #1
0
ファイル: Customers.cs プロジェクト: amolwabale/MyData
        private void idBtnSave_Click(object sender, EventArgs e)
        {
            var objCustInfo  = GetCustomerInfoFromTextBox();
            var ErrorCounter = 0;
            var ErrorMessage = "Following fields should not be empty \n\n";

            if (string.IsNullOrEmpty(objCustInfo.CompanyName))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Company Name \n";
            }

            if (string.IsNullOrEmpty(objCustInfo.Address))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Address \n";
            }

            if (string.IsNullOrEmpty(objCustInfo.Contact))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Contact \n";
            }

            if (string.IsNullOrEmpty(objCustInfo.StateName))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter State Name \n";
            }

            if (ErrorCounter > 0)
            {
                MessageBox.Show(ErrorMessage, "Warning !...");
                return;
            }



            if (string.IsNullOrEmpty(objCustInfo.Id))
            {
                var dt = MastersBl.GetFilteredCustomerList("CompanyName", idTxtCompanyName.Text.Trim());
                if (dt.Rows.Count > 0)
                {
                    MessageBox.Show("Customer with company name '" + idTxtCompanyName.Text.Trim() + "' already exist.");
                    return;
                }
                CustomerBl.SaveCustomer(objCustInfo);
            }
            else
            {
                CustomerBl.UpdateCustomer(objCustInfo);
            }
            FormCancelButton = true;
            if (InitFromMenu != true)
            {
                MastersCustomers obj = new MastersCustomers();
                obj.Show();
            }
            this.Close();
        }
コード例 #2
0
ファイル: MastersVehicle.cs プロジェクト: amolwabale/MyData
        private void idBtnSearch_Click(object sender, EventArgs e)
        {
            var ColumnName   = idCmbSearchParam.Text;
            var Val          = idTxtSearch.Text;
            var ErrorMessage = "Folowing inputs are required \n\n";
            var ErrorCounter = 0;

            if (string.IsNullOrEmpty(ColumnName))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Select Filter \n";
            }

            if (string.IsNullOrEmpty(Val))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Enter search parameter";
            }

            if (ErrorCounter > 0)
            {
                MessageBox.Show(ErrorMessage, "Warning !...");
                return;
            }
            var dt = MastersBl.GetFilteredVehicleList(ColumnName, Val);

            idDgvMastersVehicle.DataSource = dt;
            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("No record found", "Information");
            }
        }
コード例 #3
0
        public void RefreshDgv()
        {
            DataTable dt = MastersBl.GetMasterItemList();

            ManipulateDtValue(dt);
            idDgvMastersItem.DataSource = dt;
        }
コード例 #4
0
 private void idBtnDelete_Click(object sender, EventArgs e)
 {
     if (IsDgvRowsPresent())
     {
         var rowIndex = idDgvMasterTransportMode.SelectedCells[0].RowIndex;
         var id       = idDgvMasterTransportMode.Rows[rowIndex].Cells[0].Value.ToString();
         MastersBl.DeleteMode(id);
         RefreshDgv();
     }
 }
コード例 #5
0
ファイル: MastersUnit.cs プロジェクト: amolwabale/MyData
 private void idBtnDelete_Click(object sender, EventArgs e)
 {
     if (IsDgvRowsPresent())
     {
         var rowIndex = idDgvMasterUnit.SelectedCells[0].RowIndex;
         var id       = idDgvMasterUnit.Rows[rowIndex].Cells[0].Value.ToString();
         MastersBl.DeleteUnit(id);
         DataTable dt = MastersBl.GetMasterUnitList();
         idDgvMasterUnit.DataSource = dt;
     }
 }
コード例 #6
0
ファイル: Items.cs プロジェクト: amolwabale/MyData
        public void FillUnitDropdowns()
        {
            List <string> ListUnit = new List <string>();

            ListUnit.Add("");
            DataTable dt = MastersBl.GetMasterUnitList();

            for (var i = 0; i < dt.Rows.Count; i++)
            {
                var unit = dt.Rows[i][1].ToString();
                ListUnit.Add(unit);
            }
            idCmbUnit.DataSource = ListUnit;
        }
コード例 #7
0
        public void FillVehicleCmb()
        {
            var dt = MastersBl.GetMasterVehicleList();
            Dictionary <string, string> ListUnit = new Dictionary <string, string>();

            ListUnit.Add("", "");
            for (var i = 0; i < dt.Rows.Count; i++)
            {
                var id   = dt.Rows[i]["ID"].ToString();
                var name = dt.Rows[i]["VehicleNum"].ToString();
                ListUnit.Add(id, name);
            }
            idCmbVehicleNum.DataSource    = new BindingSource(ListUnit, null);
            idCmbVehicleNum.DisplayMember = "Value";
            idCmbVehicleNum.ValueMember   = "Key";
        }
コード例 #8
0
        private void idBtnSave_Click(object sender, EventArgs e)
        {
            GetCompanyInfoFromTextBox();
            var ErrorCounter = 0;
            var ErrorMessage = "Following fields should not be empty \n\n";

            if (string.IsNullOrEmpty(GlobalObjCompanyInfo.CompanyName))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Company Name \n";
            }

            if (string.IsNullOrEmpty(GlobalObjCompanyInfo.Address))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Company Address \n";
            }

            if (string.IsNullOrEmpty(GlobalObjCompanyInfo.Contact))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Contact \n";
            }

            if (string.IsNullOrEmpty(GlobalObjCompanyInfo.StateName))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter State Name \n";
            }
            if (ErrorCounter > 0)
            {
                MessageBox.Show(ErrorMessage, "Warning !...");
                return;
            }
            if (GlobalObjCompanyInfo.Id == "0")
            {
                MastersBl.SaveCompanyInfo(GlobalObjCompanyInfo);
            }
            else
            {
                MastersBl.UpdateCompanyInfo(GlobalObjCompanyInfo);
            }
            SetViewMode();
            GlobalObjCompanyInfo = MastersBl.GetCompanyInfo();
        }
コード例 #9
0
        public void FillBilledToCustomerCmb()
        {
            var dt = MastersBl.GetMasterCustomerList();
            Dictionary <string, string> ListUnit = new Dictionary <string, string>();

            ListUnit.Add("", "");
            for (var i = 0; i < dt.Rows.Count; i++)
            {
                var id   = dt.Rows[i]["ID"].ToString();
                var name = dt.Rows[i]["CompanyName"].ToString();
                ListUnit.Add(id, name);
            }
            idCmbBilledTo.DataSource     = new BindingSource(ListUnit, null);
            idCmbBilledTo.DisplayMember  = "Value";
            idCmbBilledTo.ValueMember    = "Key";
            idCmbShippedTo.DataSource    = new BindingSource(ListUnit, null);
            idCmbShippedTo.DisplayMember = "Value";
            idCmbShippedTo.ValueMember   = "Key";
        }
コード例 #10
0
        private void idBtnAdd_Click(object sender, EventArgs e)
        {
            var Mode = idTxtTransportMode.Text.Trim();

            if (!string.IsNullOrEmpty(Mode))
            {
                if (!MastersBl.IfTransportModeAlreadyExist(Mode))
                {
                    MastersBl.AddNewMode(Mode);
                    RefreshDgv();
                    idTxtTransportMode.Text = "";
                }
                else
                {
                    MessageBox.Show("Transport Mode Already Exist.");
                }
            }
            else
            {
                MessageBox.Show("Please enter Transport Mode.");
            }
        }
コード例 #11
0
ファイル: MastersUnit.cs プロジェクト: amolwabale/MyData
        private void idBtnAdd_Click(object sender, EventArgs e)
        {
            var unit = idTxtUnit.Text.Trim();

            if (!string.IsNullOrEmpty(unit))
            {
                if (!MastersBl.IfUnitAlreadyExist(unit))
                {
                    MastersBl.AddNewUnit(unit);
                    DataTable dt = MastersBl.GetMasterUnitList();
                    idDgvMasterUnit.DataSource = dt;
                    idTxtUnit.Text             = "";
                }
                else
                {
                    MessageBox.Show("Unit Already Exist.");
                }
            }
            else
            {
                MessageBox.Show("Please enter unit.");
            }
        }
コード例 #12
0
 private void MastersCompany_Load(object sender, EventArgs e)
 {
     GlobalObjCompanyInfo = MastersBl.GetCompanyInfo();
     SetCompanyInfoToTextBox();
     SetViewMode();
 }
コード例 #13
0
ファイル: MastersTax.cs プロジェクト: amolwabale/MyData
        private void idBtnSave_Click(object sender, EventArgs e)
        {
            GetValueFromTextBox();
            var ErrorCounter = 0;
            var ErrorMessage = "Following fields should not be empty \n\n";

            if (string.IsNullOrEmpty(GlobalObjTaxInfo.SGST))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter 0 if not SGST applicable \n";
            }
            if (string.IsNullOrEmpty(GlobalObjTaxInfo.CGST))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter 0 if not CGST applicable \n";
            }
            if (string.IsNullOrEmpty(GlobalObjTaxInfo.IGST))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter 0 if not IGST applicable \n";
            }
            if (!string.IsNullOrEmpty(GlobalObjTaxInfo.SGST))
            {
                float temp   = 0;
                var   str    = GlobalObjTaxInfo.SGST.ToString();
                var   fValue = float.TryParse(str, out temp);
                if (fValue == false)
                {
                    ErrorCounter++;
                    ErrorMessage += ErrorCounter.ToString() + "] " + "SGST should be numeric value. \n";
                }
            }
            if (!string.IsNullOrEmpty(GlobalObjTaxInfo.CGST))
            {
                float temp   = 0;
                var   str    = GlobalObjTaxInfo.CGST.ToString();
                var   fValue = float.TryParse(str, out temp);
                if (fValue == false)
                {
                    ErrorCounter++;
                    ErrorMessage += ErrorCounter.ToString() + "] " + "CGST should be numeric value. \n";
                }
            }
            if (!string.IsNullOrEmpty(GlobalObjTaxInfo.IGST))
            {
                float temp   = 0;
                var   str    = GlobalObjTaxInfo.IGST.ToString();
                var   fValue = float.TryParse(str, out temp);
                if (fValue == false)
                {
                    ErrorCounter++;
                    ErrorMessage += ErrorCounter.ToString() + "] " + "IGST should be numeric value. \n";
                }
            }
            if (ErrorCounter > 0)
            {
                MessageBox.Show(ErrorMessage, "Warning !...");
                return;
            }

            if (GlobalObjTaxInfo.ID == "0")
            {
                MastersBl.SaveTaxInfo(GlobalObjTaxInfo);
            }
            else
            {
                MastersBl.UpdateTaxInfo(GlobalObjTaxInfo);
            }

            GlobalObjTaxInfo = MastersBl.GetTaxInfo();
            SetModeView();
        }
コード例 #14
0
ファイル: MastersTax.cs プロジェクト: amolwabale/MyData
 private void MastersTax_Load(object sender, EventArgs e)
 {
     SetModeView();
     GlobalObjTaxInfo = MastersBl.GetTaxInfo();
     SetValueToTextBox();
 }
コード例 #15
0
ファイル: MastersVehicle.cs プロジェクト: amolwabale/MyData
        public void RefreshDgv()
        {
            var dt = MastersBl.GetMasterVehicleList();

            idDgvMastersVehicle.DataSource = dt;
        }
コード例 #16
0
 private void idBtnCancel_Click(object sender, EventArgs e)
 {
     GlobalObjCompanyInfo = MastersBl.GetCompanyInfo();
     SetCompanyInfoToTextBox();
     SetViewMode();
 }
コード例 #17
0
        public void RefreshDgv()
        {
            var dt = MastersBl.GetMasterCustomerList();

            idDgvMastersCustomer.DataSource = dt;
        }
コード例 #18
0
ファイル: MastersUnit.cs プロジェクト: amolwabale/MyData
        private void MastersUnit_Load(object sender, EventArgs e)
        {
            DataTable dt = MastersBl.GetMasterUnitList();

            idDgvMasterUnit.DataSource = dt;
        }
コード例 #19
0
        public void UpdateInvoiceDgv(string ItemId, string Qty)
        {
            var       GstInfo     = MastersBl.GetTaxInfo();
            var       ObjItemInfo = ItemsBl.GetItemPerId(ItemId);
            DataTable dt          = new DataTable();

            dt = idDgvInvoice.DataSource as DataTable;
            DataRow dtr = dt.NewRow();

            var ErrorCounter = 0;
            var ErrorMessage = "Following fields should not be empty \n\n";

            if (string.IsNullOrEmpty(ItemId))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Select Item \n";
            }

            if (string.IsNullOrEmpty(Qty))
            {
                ErrorCounter++;
                ErrorMessage += ErrorCounter.ToString() + "] " + "Please Enter Qty \n";
            }

            if (!string.IsNullOrEmpty(Qty))
            {
                var temp   = 0;
                var result = int.TryParse(Qty, out temp);
                if (result == false)
                {
                    ErrorCounter++;
                    ErrorMessage += ErrorCounter.ToString() + "] " + "Please enter quantity in numeric format \n";
                }
            }

            var rowCount = dt.Rows.Count;

            for (var i = 0; i < rowCount; i++)
            {
                var ExistingValue = dt.Rows[i]["Item"].ToString().Trim();
                if (ExistingValue == ObjItemInfo.Name)
                {
                    ErrorCounter++;
                    ErrorMessage += ErrorCounter.ToString() + "] " + "Item already added. \n";
                }
            }

            if (ErrorCounter > 0)
            {
                MessageBox.Show(ErrorMessage, "Warning !...");
                return;
            }

            var SrNo = dt.Rows.Count;

            dtr["Sr.no"] = SrNo + 1;

            var ItemName = ObjItemInfo.Name;

            if (!string.IsNullOrEmpty(ObjItemInfo.PartNumber))
            {
                ItemName += " [ " + ObjItemInfo.PartNumber + " ]";
            }
            dtr["Item"]     = ItemName;
            dtr["Quantity"] = Qty;
            dtr["UOM"]      = ObjItemInfo.Unit;
            dtr["HSN"]      = ObjItemInfo.Hsn;

            double PerPrice      = double.Parse(ObjItemInfo.Rate);
            var    TaxableAmount = PerPrice * double.Parse(Qty);

            dtr["TaxableAmount"] = TaxableAmount;

            if (ObjItemInfo.SGST == "true")
            {
                double sgstTaxAmount = 0;
                double sgstRate      = double.Parse(GstInfo.SGST);
                if (sgstRate > 0)
                {
                    sgstTaxAmount   = TaxableAmount * (sgstRate / 100);
                    dtr["SGST(Rs)"] = sgstTaxAmount;
                }
                else
                {
                    dtr["SGST(Rs)"] = "0";
                }
            }
            else
            {
                dtr["CGST(Rs)"] = "0";
            }

            if (ObjItemInfo.CGST == "true")
            {
                double cgstTaxAmount = 0;
                double cgstRate      = double.Parse(GstInfo.CGST);
                if (cgstRate > 0)
                {
                    cgstTaxAmount   = TaxableAmount * (cgstRate / 100);
                    dtr["CGST(Rs)"] = cgstTaxAmount;
                }
                else
                {
                    dtr["CGST(Rs)"] = "0";
                }
            }
            else
            {
                dtr["CGST(Rs)"] = "0";
            }

            if (ObjItemInfo.IGST == "true")
            {
                double igstTaxAmount = 0;
                double igstRate      = double.Parse(GstInfo.CGST);
                if (igstRate > 0)
                {
                    igstTaxAmount   = TaxableAmount * (igstRate / 100);
                    dtr["IGST(Rs)"] = igstTaxAmount;
                }
                else
                {
                    dtr["IGST(Rs)"] = "0";
                }
            }
            else
            {
                dtr["IGST(Rs)"] = "0";
            }

            double totalAmount = TaxableAmount + double.Parse(dtr["IGST(Rs)"].ToString()) +
                                 double.Parse(dtr["CGST(Rs)"].ToString()) +
                                 double.Parse(dtr["SGST(Rs)"].ToString());

            dtr["TotalAmount"] = totalAmount;
            dt.Rows.Add(dtr);

            idTxtQty.Text = "";
            idCmbAddItem.SelectedIndex = -1;
        }
コード例 #20
0
        public void RefreshDgv()
        {
            DataTable dt = MastersBl.GetMasterTransportModeList();

            idDgvMasterTransportMode.DataSource = dt;
        }