Ejemplo n.º 1
0
        //------------------ Methods -------------------------------

        public void Clear()
        {
            txtDate.Text            = "";
            txtDepartment.Text      = "";
            txtMRNo.Text            = "";
            txtRemarks.Text         = "";
            txtReqestBy.Text        = "";
            txtType.Text            = "";
            bindItemList.DataSource = null;
            objMR = null;
            try
            {
                Department objDep = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue));
                if (rbInitial.Checked)
                {
                    bindMRList.DataSource = objMRDL.GetMR_ToDep_or_ToStore(objDep.DepID, MR.Status.Initial, MR.Origin.ToBatch);
                }
                else if (rbApproved.Checked)
                {
                    bindMRList.DataSource = objMRDL.GetMR_ToDep_or_ToStore(objDep.DepID, MR.Status.Approved, MR.Origin.ToBatch);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 2
0
 public void LoadStore()
 {
     try
     {
         cmbDepartment.DataSource  = objDepDL.Get();
         cmbStoreKeeper.DataSource = objEmpDL.Get();
         bindStoreList.DataSource  = objStoreDL.Get();
     }
     catch (Exception ex)
     {
         MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Ejemplo n.º 3
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Store objStore = new Store();

            objStore.StoreID = CurrStore;
            objDepTo         = objDepartmentDL.Get(25);
            objDepFrom       = objDepartmentDL.Get(25);

            //objMTN.MTNDate = DateTime.Now;
            //objMTN.MTNApprovedBy = null;
            objMTN.MTNDepartmentFrom = objDepFrom;
            objMTN.MTNDepartmentTo   = objDepTo;
            objMTN.MTNEnterdBy       = CurrentUser.UserEmp;
            objMTN.MTNStatus         = MTN.Status.Initial;
            objMTN.MTNType           = MTN.Type.Dispose;
            objMTN.MTNStore          = objStore;
            objMTN.MTNItemType       = MTN.ItemType.Finish_Product;

            objMTN.MTNItemType = MTN.ItemType.Finish_Product;

            objMTN.MTNNo = objMTNDL.Add_FinishedGoodsReturns(objMTN);


            //objMTN.MTNNo =
            //objMTNDL.Add(objMTN);

            if (objMTN.MTNNo > 0)
            {
                foreach (DataGridViewRow dr in dgvProduct.Rows)
                {
                    String tempproductCode = dr.Cells[0].Value.ToString();
                    String tempproduct     = dr.Cells[1].Value.ToString();
                    long   tempqty         = Convert.ToInt64(dr.Cells[2].Value.ToString());
                    string tempstore       = dr.Cells[3].Value.ToString();


                    objFinishProduct = objFinishProductDL.Get(tempproductCode);
                    //objMTNFinish.Batch = "No";
                    //objMTNFinish.Description = "No";
                    objMTNFinish.FinishProduct   = objFinishProduct;
                    objMTNFinish.MTN             = objMTN;
                    objMTNFinish.ReceivedQty     = 0;
                    objMTNFinish.UnitRate        = 0;
                    objMTNFinish.UnitRate_Budget = 0;
                    objMTNFinish.TransferQty     = tempqty;
                    objMTNFinisProductDL.Add(objMTNFinish);
                }
                MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.Close();
            }
        }
Ejemplo n.º 4
0
        private void LoadMaterialList()
        {
            try
            {
                if ((cmbBatchNo.SelectedValue != null) && (cmbPart.Text != ""))
                {
                    objBatch = objBatch_DL.Get(cmbBatchNo.SelectedValue.ToString());

                    dt = objBatchFormulaMaterial_DL.GetView(objBatch.BatchID, cmbPart.Text);

                    dgvItemList.AutoGenerateColumns  = false;
                    objSourceMaterialList.DataSource = dt;
                    dgvItemList.DataSource           = objSourceMaterialList;
                    objSourceMaterialList.ResetBindings(true);


                    DepID = objDepDL.Get(objBatch.StandardBatch.STDBatchBasicProduct.BasicProductCode, "Manf");
                    DataTable dtMR = new DataTable();


                    if (rdbMaterial.Checked == true)
                    {
                        dtMR = objMRDL.GetActiveMR(cmbBatchNo.SelectedValue.ToString(), cmbPart.Text, (int)BatchMR.Status.Rejected, (int)MR.Type.Material, objStore.StoreID);
                    }

                    if (rdbSemiFinished.Checked == true)
                    {
                        dtMR = objMRDL.GetActiveMR(cmbBatchNo.SelectedValue.ToString(), cmbPart.Text, (int)BatchMR.Status.Rejected, (int)MR.Type.BasicProduct, objStore.StoreID);
                    }

                    if (dtMR.Rows.Count > 0)
                    {
                        lblMessage.Text   = "There is a request already made from MRNO : " + dtMR.Rows[0]["MRNO"].ToString() + ".  Please check the status of that requisition";
                        btnSendMR.Enabled = false;
                    }
                    else
                    {
                        lblMessage.Text   = "This will request material list of the selected Part at once";
                        btnSendMR.Enabled = true;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 5
0
 public void Set(Sections obj)
 {
     try
     {
         Department objDep = objDepartmentDL.Get(obj.DepID);
         cmbDivision.SelectedValue  = objDep.DivisionID;
         cmDepartment.SelectedValue = objDep.DepID;
         cmbSection.SelectedValue   = obj.SectionID;
     }
     catch (Exception)
     {
     }
 }
Ejemplo n.º 6
0
        private void frmGRNMATDirect_Load(object sender, EventArgs e)
        {
            try
            {
                LoadDirect();

                objStore           = objStoreDL.Get(StoreID);
                objDepartment      = objDepartmentDL.Get(objStore.StoreDepartment.DepID);
                txtDepartment.Text = objDepartment.DepName;
                txtStores.Text     = objStore.StoreDescription;
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 7
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                objMR.MRDepartmentFrom = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue));
                objMR.MREnterdBy       = CurrentUser.UserEmp.EmployeeID;
                if (txtDescription.Text != "")
                {
                    objMR.MRRemarks = txtDescription.Text;
                }
                else
                {
                    objMR.MRRemarks = "No";
                }
                objMR.MRStore    = objStore;
                objMR.MRStatus   = MR.Status.Initial;
                objMR.MRType     = MR.Type.BasicProduct;
                objMR.OriginType = MR.Origin.ToStore;


                if (objMRBasicProductCollec.Count > 0)
                {
                    long MRNO = objMRDL.Add_M(objMR);
                    if (MRNO > 0)
                    {
                        objMR.MRNO = MRNO;
                        foreach (MRBasicProduct obj in objMRBasicProductCollec)
                        {
                            obj.MR = objMR;
                            objMRBasicProduct_DL.Add(obj);
                        }
                        MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        ClearItem();
                        ClearMR();
                    }
                }
                else
                {
                    MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 8
0
        private void cmbDepartment_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                Load_Stores();

                if (cmbDepartment.SelectedValue != null)
                {
                    objDepartment = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue));
                }
                Load_MRList();
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, "Error occured while Receiving", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 9
0
        //-------------------Events ------------------------
        private void frmMaterialsReceipt_Load(object sender, EventArgs e)
        {
            try
            {
                dt            = objUserDepartments_DL.Get_Default(CurrentUser.UserID);
                objDepartment = objDepDL.Get(Convert.ToInt64((dt.Rows[0]["Department"])));
                objStore      = objStoreDL.Get_Default(objDepartment.DepID);

                txtDepartment.Text = objDepartment.DepName;
                txtStore.Text      = objStore.StoreID;

                Load_MRList();
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 10
0
        private void frmRemoveStock_Load(object sender, EventArgs e)
        {
            try
            {
                cmbMTNType.SelectedIndex     = 0;
                cmbDepartmentFrom.DataSource = objDepartmentDL.Get();
                //cmbDepartmentTo.DataSource = objDepartmentDL.Get();

                dt.Columns.Add("ItemCode");
                dt.Columns.Add("Item");
                dt.Columns.Add("Remarks");
                dt.Columns.Add("Qty");
                dt.Columns.Add("Unit");
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 11
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                objMR.MRDepartmentFrom = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue));
                objMR.MREnterdBy       = CurrentUser.UserEmp.EmployeeID;
                objMR.MRRemarks        = "No";
                objMR.MRStore          = objStore;
                objMR.MRStatus         = MR.Status.Initial;
                objMR.MRType           = MR.Type.Material;
                objMR.OriginType       = MR.Origin.ToSection;


                if (objMRMaterialCollec.Count > 0)
                {
                    long MRNO = objMRDL.Add_Packing_ToSections(objStore.StoreID, Convert.ToInt32(cmbSection.SelectedValue), Convert.ToInt32(cmbDepartment.SelectedValue),
                                                               CurrentUser.UserEmp.EmployeeID, "Packing for RPD Batches", MR.Status.Initial, MR.Type.Material, (int)MR.Origin.ToSection);
                    if (MRNO > 0)
                    {
                        objMR.MRNO = MRNO;
                        foreach (MRMaterial obj in objMRMaterialCollec)
                        {
                            obj.MR = objMR;
                            objMRMaterialDL.Add(obj);
                        }
                        MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        ClearItem();
                        ClearMR();
                    }
                }
                else
                {
                    MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 12
0
        private void gvDepartment_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                Department_DL    objDepDL            = new Department_DL(ConnectionStringClass.GetConnection());
                Section_DL       objSection_DL       = new Section_DL(ConnectionStringClass.GetConnection());
                OverheadRates    objOverheadRates    = new OverheadRates();
                OverheadRates_DL objOverheadRates_DL = new OverheadRates_DL(ConnectionStringClass.GetConnection());
                Employee_DL      objEmpDL            = new Employee_DL(ConnectionStringClass.GetConnection());
                ClearDep();
                if (true)
                {
                    Sections   objSection = objSection_DL.Get(Convert.ToInt64(gvDepartment.Rows[e.RowIndex].Cells["colDepID"].Value));
                    Department objDep     = objDepDL.Get(objSection.DepID);
                    if (objDep.DepID != 0)
                    {
                        txtSection.Text        = objSection.SectionName;
                        objSelectedSections    = objSection;
                        txtDID.Text            = objDep.DepID.ToString();
                        txtDepartmentName.Text = objDep.DepName;
                        objOverheadRates       = objOverheadRates_DL.Get(objSection.SectionID);
                        if (objOverheadRates.SectionID != 0)
                        {
                            txtDepCurrent.Text = objOverheadRates.Rate.ToString();
                            Employee objEmp = objEmpDL.Get(objOverheadRates.EnterdBy);

                            txtDepEnterdBy.Text   = objEmp.EmployeeName;
                            txtDepEnterdDate.Text = objOverheadRates.EnterdDate.ToShortDateString();
                        }
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show(this, "Error occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Ejemplo n.º 13
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            MTNMaterial      objMTNMat    = new MTNMaterial();
            MTNBasicProduct  objMTNBasic  = new MTNBasicProduct();
            MTNFinishProduct objMTNFinish = new MTNFinishProduct();

            Department objDepFrom = new Department();
            Department objDepTo   = new Department();

            Store         objStore         = new Store();
            Material      objMaterial      = new Material();
            FinishProduct objFinishProduct = new FinishProduct();
            BasicProduct  objBasicProduct  = new BasicProduct();
            GRN           objGRN           = new GRN();

            try
            {
                if (cmbGRNNO.Items.Count > 0 && cmbGRNNO.SelectedValue != null)
                {
                    objGRN.GRNNo = Convert.ToInt64(cmbGRNNO.SelectedValue);
                }

                String ItemCode = "";
                if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
                {
                    ItemCode = cmbItem.SelectedValue.ToString();
                }


                if (cmbDepartmentFrom.Items.Count > 0)
                {
                    objDepFrom = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentFrom.SelectedValue));
                }

                if (cmbDepartmentTo.Items.Count > 0)
                {
                    objDepTo = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentTo.SelectedValue));
                }

                if (cmbStoreFrom.Items.Count > 0)
                {
                    objStore = (Store)cmbStoreFrom.SelectedItem;
                }

                if (!ItemCode.Equals("") && !objGRN.GRNNo.Equals("") && objDepTo != null && objDepFrom != null)
                {
                    if (txtQty.Text.Equals(""))
                    {
                        MessageBox.Show(this, "Please enter Valid Quantity for Transfer", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(txtAvailableQty.Text))
                        {
                            MessageBox.Show(this, "Available Quantity is " + txtAvailableQty.Text + ",Transfer quantity cannot be more than available", "Available Quantity Exceed", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            objMTN.MTNDepartmentFrom = objDepFrom;
                            objMTN.MTNDepartmentTo   = objDepTo;
                            objMTN.MTNEnterdBy       = CurrentUser.UserEmp;
                            objMTN.MTNStatus         = MTN.Status.Initial;
                            objMTN.MTNType           = MTN.Type.General;
                            objMTN.MTNStore          = objStore;
                            if (cmbMTNType.SelectedItem.Equals("Basic Product"))
                            {
                                objMTN.MTNItemType = MTN.ItemType.Basic_Product;


                                objMTN.MTNNo = objMTNDL.Add(objMTN);

                                if (objMTN.MTNNo > 0)
                                {
                                    objBasicProduct = objBasicProductDL.Get((cmbItem.SelectedValue.ToString()));


                                    objMTNBasic.Batch        = "No";
                                    objMTNBasic.Description  = txtRemarks.Text;
                                    objMTNBasic.BasicProduct = objBasicProduct;
                                    objMTNBasic.MTN          = objMTN;
                                    objMTNBasic.TransferQty  = Convert.ToDecimal(txtQty.Text);
                                    objMTNBasic.UnitRate     = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text);


                                    objMTNBasicProductDL.Add(objMTNBasic);

                                    MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                }
                            }
                            else if (cmbMTNType.SelectedItem.Equals("Material"))
                            {
                                objMTN.MTNItemType = MTN.ItemType.Material;


                                objMTN.MTNNo = objMTNDL.Add(objMTN);

                                if (objMTN.MTNNo > 0)
                                {
                                    objMaterial = objMaterialDL.Get(cmbItem.SelectedValue.ToString());


                                    objMTNMat.Batch       = "No";
                                    objMTNMat.Description = txtRemarks.Text;
                                    objMTNMat.Material    = objMaterial;
                                    objMTNMat.MTN         = objMTN;
                                    objMTNMat.TransferQty = Convert.ToDecimal(txtQty.Text);
                                    objMTNMat.UnitRate    = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text);


                                    objMTNMaterialDL.Add(objMTNMat);

                                    MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                }
                            }
                            else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
                            {
                                objMTN.MTNItemType = MTN.ItemType.Finish_Product;


                                objMTN.MTNNo = objMTNDL.Add(objMTN);

                                if (objMTN.MTNNo > 0)
                                {
                                    objFinishProduct = objFinishProductDL.Get((cmbItem.SelectedValue.ToString()));


                                    objMTNFinish.Batch         = "No";
                                    objMTNFinish.Description   = txtRemarks.Text;
                                    objMTNFinish.FinishProduct = objFinishProduct;
                                    objMTNFinish.MTN           = objMTN;
                                    objMTNFinish.TransferQty   = Convert.ToDecimal(txtQty.Text);
                                    objMTNFinish.UnitRate      = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text);


                                    objMTNFinisProductDL.Add(objMTNFinish);

                                    MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                }
                            }
                        }
                    }
                }
                else
                {
                    MessageBox.Show(this, "Please check Item, Department and GRN that you selected", "Selection Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 14
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                objMR.MRDate           = DateTime.Now;
                objMR.MRDepartmentFrom = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue));
                objMR.MREnterdBy       = CurrentUser.UserEmp.EmployeeID;
                objMR.MRRemarks        = txtRemarks.Text;
                objMR.MRStatus         = MR.Status.Initial;
                objMR.MRStore          = (Store)cmbStore.SelectedItem;
                if (cbSection.Checked)
                {
                    objMR.SectionID = Convert.ToInt64(cmbSection.SelectedValue);
                }
                else
                {
                    objMR.SectionID = null;
                }

                if (cmbMRType.SelectedItem.Equals("Material"))
                {
                    objMR.MRType = MR.Type.Material;
                    if (objMRMaterialCollec.Count > 0)
                    {
                        long MRNO = objMRDL.Add_M(objMR);
                        if (MRNO > 0)
                        {
                            objMR.MRNO = MRNO;
                            foreach (MRMaterial obj in objMRMaterialCollec)
                            {
                                obj.MR = objMR;
                                objMRMaterialDL.Add(obj);
                            }
                            MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            ClearItem();
                            ClearMR();
                        }
                    }
                    else
                    {
                        MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                else if (cmbMRType.SelectedItem.Equals("Basic Products"))
                {
                    objMR.MRType = MR.Type.BasicProduct;
                    if (objMRBasicProductCollec.Count > 0)
                    {
                        long MRNO = objMRDL.Add_M(objMR);
                        if (MRNO > 0)
                        {
                            objMR.MRNO = MRNO;
                            foreach (MRBasicProduct obj in objMRBasicProductCollec)
                            {
                                obj.MR = objMR;
                                objMRBasicProductDL.Add(obj);
                            }
                            MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            ClearItem();
                            ClearMR();
                        }
                    }
                    else
                    {
                        MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                else if (cmbMRType.SelectedItem.Equals("Finish Products"))
                {
                    objMR.MRType = MR.Type.FinishProduct;
                    if (objMRFinishhProductCollec.Count > 0)
                    {
                        long MRNO = objMRDL.Add_M(objMR);
                        if (MRNO > 0)
                        {
                            objMR.MRNO = MRNO;
                            foreach (MRFinishProduct obj in objMRFinishhProductCollec)
                            {
                                obj.MR = objMR;
                                objMRFinishProductDL.Add(obj);
                            }
                            MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            ClearItem();
                            ClearMR();
                            objMRMaterialCollec.Clear();
                        }
                    }
                    else
                    {
                        MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 15
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            MTNMaterial      objMTNMat    = new MTNMaterial();
            MTNBasicProduct  objMTNBasic  = new MTNBasicProduct();
            MTNFinishProduct objMTNFinish = new MTNFinishProduct();

            Department objDepFrom = new Department();
            Department objDepTo   = new Department();

            Store         objStore         = new Store();
            Material      objMaterial      = new Material();
            FinishProduct objFinishProduct = new FinishProduct();
            BasicProduct  objBasicProduct  = new BasicProduct();
            GRN           objGRN           = new GRN();

            try
            {
                String ItemCode = "";
                if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
                {
                    ItemCode = cmbItem.SelectedValue.ToString();
                }


                if (cmbDepartmentFrom.Items.Count > 0)
                {
                    objDepFrom = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentFrom.SelectedValue));
                }

                if (cmbDepartmentTo.Items.Count > 0)
                {
                    objDepTo = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentTo.SelectedValue));
                }

                if (cmbStoreFrom.Items.Count > 0)
                {
                    objStore = (Store)cmbStoreFrom.SelectedItem;
                }

                objMTN.MTNDepartmentFrom = objDepFrom;
                objMTN.MTNDepartmentTo   = objDepTo;
                objMTN.MTNEnterdBy       = CurrentUser.UserEmp;
                objMTN.MTNStatus         = MTN.Status.Initial;
                objMTN.MTNType           = MTN.Type.General;
                objMTN.MTNStore          = objStore;
                if (cmbMTNType.SelectedItem.Equals("Basic Product"))
                {
                    objMTN.MTNItemType = MTN.ItemType.Basic_Product;


                    objMTN.MTNNo = objMTNDL.Add_Other(objMTN);

                    if (objMTN.MTNNo > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            objBasicProduct          = objBasicProductDL.Get(dr["ItemCode"].ToString());
                            objMTNBasic.Batch        = "No";
                            objMTNBasic.Description  = dr["Remarks"].ToString();
                            objMTNBasic.BasicProduct = objBasicProduct;
                            objMTNBasic.MTN          = objMTN;
                            objMTNBasic.TransferQty  = Convert.ToDecimal(dr["Qty"].ToString());
                            objMTNBasicProductDL.Add(objMTNBasic);
                        }

                        MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Close();
                    }
                }
                else if (cmbMTNType.SelectedItem.Equals("Material"))
                {
                    objMTN.MTNItemType = MTN.ItemType.Material;


                    objMTN.MTNNo = objMTNDL.Add_Other(objMTN);

                    if (objMTN.MTNNo > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            objMaterial = objMaterialDL.Get(dr["ItemCode"].ToString());


                            objMTNMat.Batch       = "No";
                            objMTNMat.Description = dr["Remarks"].ToString();
                            objMTNMat.Material    = objMaterial;
                            objMTNMat.MTN         = objMTN;
                            objMTNMat.TransferQty = Convert.ToDecimal(dr["Qty"]);
                            objMTNMaterialDL.Add(objMTNMat);
                        }
                        MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Close();
                    }
                }
                else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
                {
                    objMTN.MTNItemType = MTN.ItemType.Finish_Product;


                    objMTN.MTNNo = objMTNDL.Add_Other(objMTN);

                    if (objMTN.MTNNo > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            objFinishProduct           = objFinishProductDL.Get((cmbItem.SelectedValue.ToString()));
                            objMTNFinish.Batch         = "No";
                            objMTNFinish.Description   = dr["Remarks"].ToString();
                            objMTNFinish.FinishProduct = objFinishProduct;
                            objMTNFinish.MTN           = objMTN;
                            objMTNFinish.TransferQty   = Convert.ToDecimal(dr["Qty"]);
                            objMTNFinisProductDL.Add(objMTNFinish);
                        }
                        MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }