void DelelteData()
        {
            if (dgDisplayData.SelectedRows.Count > 0)
            {
                if (Datalayer.ShowQuestMsg(Datalayer.sMessageConfirmation))
                {
                    try
                    {
                        int ID = 0;
                        int.TryParse(dgDisplayData.CurrentRow.Cells["T007_STOCKINMASTERID"].Value.ToString(), out ID);

                        int?Iout = 0;
                        MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
                        MyDa.USP_VP_DELETE_STOCK_IN(ID, ref Iout);
                        MyDa.USP_VP_DELETE_STOCK_MASTER(ID, ref Iout);

                        if (Iout > 0)
                        {
                            PopualteData();
                        }
                        else
                        {
                            Datalayer.DosenotDeleteMessageBox("Stock In Details");
                        }
                    }
                    catch (Exception)
                    {
                        Datalayer.InformationMessageBox(Datalayer.sMessageForainKey);
                        return;
                    }
                }
            }
            else
            {
                Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection);
            }
        }
示例#2
0
        void Save()
        {
            try
            {
                ep1.Clear();

                if (string.IsNullOrEmpty(cmbName.Text.Trim()))
                {
                    ep1.SetError(cmbName, "This field is required.");
                    cmbName.Focus();
                    return;
                }

                if (dgDisplayData.Rows.Count == 0)
                {
                    Datalayer.InformationMessageBox("Record is required.");
                    return;
                }

                int    T005_STOCKINID = 0, T001_ACCOUNTID = 0;
                string T004_DETAILS = "";

                T005_STOCKINID = Datalayer.iT005_STOCKINID;

                int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
                T004_DETAILS = txtDetails.Text.Trim();

                if (T005_STOCKINID > 0)
                {
                    int?Iout = 0;
                    MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
                    MyDa.USP_VP_DELETE_STOCK_IN(T005_STOCKINID, ref Iout);
                }

                int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
                MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
                int?T004_ORDERID_out = 0;
                Cursor.Current = Cursors.WaitCursor;
                MyDa           = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
                MyDa.USP_VP_ADDUPDATE_STOCK_MASTER(T005_STOCKINID, dtpDate.Value, T001_ACCOUNTID, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref T004_ORDERID_out);
                if (T004_ORDERID_out > 0)
                {
                    T005_STOCKINID = int.Parse(T004_ORDERID_out.Value.ToString());
                    for (int i = 0; i < dgDisplayData.Rows.Count; i++)
                    {
                        if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value)))
                        {
                            int     TM01_PRODUCTID = 0;
                            decimal T005_WEIGHT = 0, T005_QTY = 0;
                            string  T005_UNIT = "", T005_TYPE = "";

                            int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID);
                            decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T005_QTY"].Value), out T005_QTY);
                            decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T005_WEIGHT"].Value), out T005_WEIGHT);
                            T005_UNIT = Convert.ToString(dgDisplayData.Rows[i].Cells["T005_UNIT"].Value);
                            T005_TYPE = Convert.ToString(dgDisplayData.Rows[i].Cells["T005_TYPE"].Value);

                            int?T008_SALEITEMID_Out = 0;
                            MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
                            MyDa.USP_VP_ADDUPDATE_STOCK_IN(0, T005_STOCKINID, TM01_PRODUCTID, T005_QTY, T005_UNIT, T005_TYPE, T005_WEIGHT, Datalayer.iT001_COMPANYID, ref T004_ORDERID_out);
                        }
                    }

                    if (T004_ORDERID_out > 0)
                    {
                        if (Datalayer.iT005_STOCKINID == 0)
                        {
                            Datalayer.InsertMessageBox(sPageName);
                        }
                        else
                        {
                            Datalayer.UpdateMessageBox(sPageName);
                        }

                        ResetData();
                    }
                    else
                    {
                        if (Datalayer.iT005_STOCKINID == 0)
                        {
                            Datalayer.DosenotInsertMessageBox(sPageName);
                        }
                        else
                        {
                            Datalayer.DosenotUpdateMessageBox(sPageName);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
            }
        }