Exemplo n.º 1
0
        private void FindExisitingTransfer(string ReqNo)
        {
            try{
                if (T_wastageDL.ExistingT_wastage(ReqNo.Trim()))
                {
                    formMode = 3;
                    //clear datagrid
                    dtx.Clear();
                    dataGridView1.Refresh();

                    //clear error fields
                    errorProvider1.Clear();

                    t_wastage cat = new t_wastage();
                    cat.no = ReqNo.Trim();
                    T_wastageDL dl = new T_wastageDL();
                    cat = dl.Selectt_wastage(cat);

                    //set the process message and mode to edit mode
                    if (cat.isProcessed == false)
                    {
                        lbl_processes.Visible = false;
                        performButtons(xEnums.PerformanceType.Edit);
                    }
                    else
                    {
                        lbl_processes.Visible = true;
                    }

                    //load and disable the data fields

                    //txt_destinationLocId.Text = cat.destinationLocId.Trim();
                    txt_sourceLocId.Text = cat.locationId.Trim();
                    //txt_supplierId.Text = cat.supplierId.Trim();
                    txt_remarks.Text = cat.remarks;
                    //dte_date.Value = cat.process_date.Value;

                    textareaFunctions(false);

                    t_wastage_detail req = new t_wastage_detail();
                    req.wastageNo = ReqNo.Trim();
                    T_wastage_detailDL      tdl      = new T_wastage_detailDL();
                    List <t_wastage_detail> requests = new List <t_wastage_detail>();
                    requests = tdl.SelectT_wastage_detailMulti(req);

                    foreach (t_wastage_detail det in requests)
                    {
                        commonFunctions.AddRow(dtx, det.itemCode, findExisting.FindExisitingStock(det.itemCode).Trim(), det.costPrice.ToString(), det.sellingPrice.ToString(), det.quantity.ToString(), det.amount.ToString());
                    }

                    txt_net.Text         = commonFunctions.GetGrossAmount(dataGridView1).ToString();
                    txt_grossAmount.Text = commonFunctions.GetGrossAmount(dataGridView1).ToString();
                    txt_noOfPeaces.Text  = commonFunctions.GetNoofPices(dataGridView1).ToString();
                    txt_noOfItems.Text   = commonFunctions.GetNoofItems(dataGridView1).ToString();
                }
                else
                {
                    if (formMode != 1)
                    {
                        errorProvider1.SetError(txt_no, "Wastage Number you have entered does not exists in the system.");
                    }
                }
            }
            catch (Exception ex)
            {
                LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
                commonFunctions.SetMDIStatusMessage("Genaral Error", 1);
            }
        }
Exemplo n.º 2
0
        private void performButtons(xEnums.PerformanceType xenum)
        {
            try
            {
                switch (xenum)
                {
                case xEnums.PerformanceType.View:
                    if (ActiveControl.Name.Trim() == txt_no.Name.Trim())
                    {
                        int      length         = Convert.ToInt32(ConfigurationManager.AppSettings["WastageFieldLength"]);
                        string[] strSearchField = new string[length];

                        string strSQL = ConfigurationManager.AppSettings["WastageSQL"].ToString();

                        for (int i = 0; i < length; i++)
                        {
                            string m;
                            m = i.ToString();
                            strSearchField[i] = ConfigurationManager.AppSettings["WastageField" + m + ""].ToString();
                        }

                        frmU_Search find = new frmU_Search(strSQL, strSearchField, this);
                        find.ShowDialog(this);
                    }

                    break;

                case xEnums.PerformanceType.New:
                    FunctionButtonStatus(xEnums.PerformanceType.New);
                    formMode    = 1;
                    txt_no.Text = commonFunctions.GetSerial(formID.Trim());
                    txt_no.Focus();

                    txt_sourceLocId.Text     = commonFunctions.GlobalLocation;
                    txt_locationId_name.Text = findExisting.FindExisitingLoca(txt_sourceLocId.Text.Trim());

                    errorProvider1.Clear();

                    lbl_processes.Visible = false;
                    break;

                case xEnums.PerformanceType.Edit:
                    FunctionButtonStatus(xEnums.PerformanceType.Edit);
                    formMode = 3;
                    //txt_VehicleID.Enabled = false;
                    //txt_VehicleNo.Focus();
                    errorProvider1.Clear();
                    break;

                case xEnums.PerformanceType.Save:
                    errorProvider1.Clear();
                    if (formMode == 1)
                    {
                        if (!M_LocaDL.ExistingM_Loca(txt_sourceLocId.Text.Trim()))
                        {
                            errorProvider1.SetError(txt_sourceLocId, "Location does not exists on the system ");
                            commonFunctions.SetMDIStatusMessage("Location does not exists on the system ", 1);
                            return;
                        }

                        if (commonFunctions.GetNoofItems(dataGridView1) <= 0)
                        {
                            errorProvider1.SetError(dataGridView1, "Please enter some items to the details grid");
                            commonFunctions.SetMDIStatusMessage("Please enter some items to the details grid", 1);
                            return;
                        }



                        if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
                        {
                            try
                            {
                                using (System.Transactions.TransactionScope transaction = new System.Transactions.TransactionScope())
                                {
                                    //u_DBConnection.BeginTrans();
                                    //save header data
                                    t_wastage objt_wastage = new t_wastage();
                                    objt_wastage.no          = txt_no.Text.Trim();
                                    objt_wastage.date        = dte_date.Value;
                                    objt_wastage.refNo       = txt_refNo.Text.Trim();
                                    objt_wastage.refDate     = dte_refe.Value;
                                    objt_wastage.remarks     = txt_remarks.Text.Trim();
                                    objt_wastage.locationId  = txt_sourceLocId.Text.Trim();
                                    objt_wastage.noOfItems   = commonFunctions.ToDecimal(txt_noOfItems.Text.Trim());
                                    objt_wastage.noOfPeaces  = commonFunctions.ToDecimal(txt_noOfPeaces.Text.Trim());
                                    objt_wastage.grossAmount = commonFunctions.ToDecimal(txt_grossAmount.Text.Trim());
                                    objt_wastage.isSaved     = true;
                                    objt_wastage.isProcessed = false;
                                    objt_wastage.processDate = DateTime.Now;
                                    objt_wastage.processUser = "";
                                    objt_wastage.GLUpdate    = false;
                                    objt_wastage.triggerVal  = 1;
                                    T_wastageDL bal = new T_wastageDL();
                                    bal.Savet_wastageSP(objt_wastage, 1);

                                    //save details
                                    foreach (DataGridViewRow drow in dataGridView1.Rows)
                                    {
                                        if (drow.Cells["Product Code"].Value.ToString().Trim() != null)
                                        {
                                            //have to implement the logic. this is only saving the data to the system
                                            t_wastage_detail objt_wastage_detail = new t_wastage_detail();
                                            objt_wastage_detail.wastageNo    = txt_no.Text.Trim();
                                            objt_wastage_detail.locationId   = txt_sourceLocId.Text.Trim();
                                            objt_wastage_detail.wastageDate  = dte_date.Value;
                                            objt_wastage_detail.itemCode     = drow.Cells["Product Code"].Value.ToString();
                                            objt_wastage_detail.description  = findExisting.FindExisitingProduct(drow.Cells["Product Code"].Value.ToString());
                                            objt_wastage_detail.quantity     = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
                                            objt_wastage_detail.uom          = "PCS";
                                            objt_wastage_detail.costPrice    = commonFunctions.ToDecimal(drow.Cells["Cost Price"].Value.ToString());
                                            objt_wastage_detail.sellingPrice = commonFunctions.ToDecimal(drow.Cells["Selling Price"].Value.ToString());
                                            objt_wastage_detail.amount       = commonFunctions.ToDecimal(drow.Cells["Amount"].Value.ToString());
                                            objt_wastage_detail.triggerVal   = 1;
                                            T_wastage_detailDL bal2 = new T_wastage_detailDL();
                                            bal2.Savet_wastage_detailSP(objt_wastage_detail, 1);
                                        }
                                    }

                                    //increment the serial
                                    commonFunctions.IncrementSerial(formID);
                                    transaction.Complete();
                                }
                                //u_DBConnection.CommitTrans();
                                UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
                            }
                            catch (Exception ex)
                            {
                                // u_DBConnection.RollbackTrans();
                                LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
                                commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1);
                            }

                            if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
                            {
                                UpdateStock();
                                t_wastage objt_trnsferNote = new t_wastage();
                                objt_trnsferNote.no = txt_no.Text.Trim();

                                T_wastageDL balprocess = new T_wastageDL();
                                objt_trnsferNote = balprocess.Selectt_wastage(objt_trnsferNote);

                                objt_trnsferNote.isProcessed = true;
                                objt_trnsferNote.processDate = DateTime.Now;
                                objt_trnsferNote.processUser = commonFunctions.Loginuser;
                                balprocess.Savet_wastageSP(objt_trnsferNote, 3);
                                UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
                            }


                            //clear data in data grid
                            dtx.Rows.Clear();
                            dataGridView1.Refresh();
                            //clear text fields
                            textareaFunctions(true);

                            FunctionButtonStatus(xEnums.PerformanceType.Save);
                            //increment the serial
                            txt_no.Text = commonFunctions.GetSerial(formID.Trim());
                            //txt_supplierId.Focus();
                        }
                    }
                    else if (formMode == 3)
                    {
                        t_wastage cat = new t_wastage();
                        cat.no = txt_no.Text.Trim();
                        T_wastageDL dl = new T_wastageDL();
                        cat = dl.Selectt_wastage(cat);
                        if (cat.isProcessed == false)
                        {
                            if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
                            {
                                UpdateStock();

                                t_wastage objt_trnsferNote = new t_wastage();
                                objt_trnsferNote.no = txt_no.Text.Trim();

                                T_wastageDL balprocess = new T_wastageDL();
                                objt_trnsferNote = balprocess.Selectt_wastage(objt_trnsferNote);

                                objt_trnsferNote.isProcessed = true;
                                objt_trnsferNote.processDate = DateTime.Now;
                                objt_trnsferNote.processUser = commonFunctions.Loginuser;
                                balprocess.Savet_wastageSP(objt_trnsferNote, 3);
                                UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());

                                //clear data in data grid
                                dtx.Rows.Clear();
                                dataGridView1.Refresh();
                                //clear text fields
                                textareaFunctions(true);
                                FunctionButtonStatus(xEnums.PerformanceType.Save);

                                txt_no.Text = commonFunctions.GetSerial(formID.Trim());
                                txt_code.Focus();
                            }
                        }
                        else
                        {
                            errorProvider1.SetError(txt_no, "Wastage number you have entered already processed.");
                        }
                    }
                    break;

                case xEnums.PerformanceType.Cancel:
                    txt_no.Enabled = true;
                    FunctionButtonStatus(xEnums.PerformanceType.Default);
                    errorProvider1.Clear();
                    //clear text fields
                    textareaFunctions(true);
                    //clear Datagrid
                    dtx.Clear();
                    dataGridView1.Refresh();

                    //txt_supplierId.Text = "";
                    //txt_remarks.Text = "";

                    lbl_processes.Visible = false;

                    break;

                case xEnums.PerformanceType.Print:
                    UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
                    break;
                }
            }
            catch (Exception ex)
            {
                LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
                commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1);
            }
        }