Beispiel #1
0
        public TradeEntry(int PtradeId)
        {
            InitializeComponent();
            TradeId = PtradeId;
            Trade_Model tm = new Trade_Model();

            tm.Action  = "fetchbyid";
            tm.TradeId = PtradeId;
            DataSet ds = tm.TradeOperation();

            if (ds.Tables[0].Rows.Count > 0)
            {
                txt_TradeName.Text     = ds.Tables[0].Rows[0]["TradeName"].ToString();
                txt_shortcode.Text     = ds.Tables[0].Rows[0]["ShortCode"].ToString();
                txt_Gstinno.Text       = ds.Tables[0].Rows[0]["GstInNo"].ToString();
                txt_Address1.Text      = ds.Tables[0].Rows[0]["AddressLine1"].ToString();
                txt_address2.Text      = ds.Tables[0].Rows[0]["AddressLine2"].ToString();
                txt_address3.Text      = ds.Tables[0].Rows[0]["AddressLine3"].ToString();
                txt_city.Text          = ds.Tables[0].Rows[0]["CityName"].ToString();
                txt_pincode.Text       = ds.Tables[0].Rows[0]["Pincode"].ToString();
                txt_ContactNo1.Text    = ds.Tables[0].Rows[0]["ContactNo1"].ToString();
                txt_contactno2.Text    = ds.Tables[0].Rows[0]["ContactNo2"].ToString();
                txt_email.Text         = ds.Tables[0].Rows[0]["EmailId"].ToString();
                txt_file.Text          = ds.Tables[0].Rows[0]["Logo"].ToString();
                btn_Save.Text          = "Update";
                btn_SaveAddNew.Enabled = false;
                btn_SaveAddNew.Text    = "Update Trade";
            }
        }
Beispiel #2
0
        private bool Save()
        {
            if (txt_TradeName.Text != "")
            {
                Trade_Model tm = new Trade_Model();

                if (btn_Save.Text == "Update")
                {
                    tm.Action  = "updateitem";
                    tm.TradeId = TradeId;
                }
                else
                {
                    tm.Action = "insert";
                }

                tm.TradeName    = txt_TradeName.Text;
                tm.ShortCode    = txt_shortcode.Text;
                tm.GstInNo      = txt_Gstinno.Text;
                tm.AddressLine1 = txt_Address1.Text;
                tm.AddressLine2 = txt_address2.Text;
                tm.AddressLine3 = txt_address3.Text;
                tm.CityName     = txt_city.Text;
                tm.Pincode      = txt_pincode.Text;
                tm.ContactNo1   = txt_ContactNo1.Text;
                tm.ContactNo2   = txt_contactno2.Text;
                tm.EmailId      = txt_email.Text;
                tm.Logo         = txt_file.Text;
                //tm.StateId = ddl_State.SelectedItem.ToString();
                DataSet ds = tm.TradeOperation();
                if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Record Submitted Successfully")
                {
                    MessageBox.Show("Record Submitted Successfully", "MinifyERPBilling", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return(true);
                }
                else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Update Successfully")
                {
                    MessageBox.Show("Updated Successfully", "MinifyERPBilling", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return(true);
                }
                else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Item Name Aready Exists")
                {
                    MessageBox.Show("Item Name Aready Exists!!!Please Try Again With Diffrent Trade Name", "MinifyERPBilling", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return(false);
                }
                else
                {
                    MessageBox.Show("Failed to Execute Command!!! Please Try Again Later", "MinifyERPBilling", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return(false);
                }
            }
            else
            {
                MessageBox.Show("Failed to Execute Command!!! Please Try Again Later", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return(false);
            }
        }
Beispiel #3
0
        private DataTable GetAll()
        {
            DataTable dt = new DataTable();

            dt.Columns.Add("TradeId", typeof(int));
            dt.Columns.Add("TradeName", typeof(string));
            dt.Columns.Add("ShortCode", typeof(string));
            dt.Columns.Add("AddressLine1", typeof(string));
            dt.Columns.Add("StateId", typeof(string));
            dt.Columns.Add("CityName", typeof(string));
            dt.Columns.Add("Pincode", typeof(string));
            dt.Columns.Add("EmailId", typeof(string));
            dt.Columns.Add("ContactNo1", typeof(string));
            dt.Columns.Add("GstInNo", typeof(string));
            dt.Columns.Add("Logo", typeof(string));
            Trade_Model trade_Model = new Trade_Model();

            trade_Model.Action = "fetch";
            DataSet ds = trade_Model.TradeOperation();

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                dt.Rows.Add(
                    ds.Tables[0].Rows[i]["TradeId"].ToString(),
                    ds.Tables[0].Rows[i]["TradeName"].ToString(),
                    ds.Tables[0].Rows[i]["ShortCode"].ToString(),
                    ds.Tables[0].Rows[i]["AddressLine1"].ToString(),
                    ds.Tables[0].Rows[i]["StateId"].ToString(),
                    ds.Tables[0].Rows[i]["CityName"].ToString(),
                    ds.Tables[0].Rows[i]["Pincode"].ToString(),
                    ds.Tables[0].Rows[i]["EmailId"].ToString(),
                    ds.Tables[0].Rows[i]["ContactNo1"].ToString(),
                    ds.Tables[0].Rows[i]["GstInNo"].ToString(),
                    ds.Tables[0].Rows[i]["Logo"].ToString()
                    );
            }
            return(dt);
        }
Beispiel #4
0
 private void ddl_Country_SelectedIndexChanged(object sender, EventArgs e)
 {
     Trade_Model tm = new Trade_Model();
     DataSet     ds = tm.TradeOperation();
 }