private void Onsearch() { try { grdCompany.Rows.Clear(); master = new Master_Company(); List <Company_GetCompany_Result> result = master.Get_Company(txtSearch.Text.Trim()); foreach (Company_GetCompany_Result re in result) { grdCompany.Rows.Add(grdCompany.Rows.Count + 1 , re.companyID , re.companyName , re.phone , re.address); } if (result.Count > 0) { GrdComclick(0); } } catch (Exception ex) { Log_Error(ex); } }
private void Product_Load(object sender, EventArgs e) { design_Dgv(); masterCom = new Master_Company(); List <Company_GetCompany_Result> result = masterCom.Get_Company(string.Empty); foreach (Company_GetCompany_Result re in result) { ComboboxItem item = new ComboboxItem(); item.Text = re.companyName; item.Value = re.companyID; cbCompany.Items.Add(item); } MasterStore = new Master_StoreManagement(); List <Store_GetListbank_Result> result2 = MasterStore.Get_Listbank(); foreach (Store_GetListbank_Result re2 in result2) { ComboboxItem item = new ComboboxItem(); item.Text = re2.bankName; item.Value = re2.bankID; cbbType.Items.Add(item); } ViewMode(); }
//company add public int Addcompany(Master_Company c) { int i; using (SqlConnection con = new SqlConnection(cs)) { con.Open(); string q = "insert into Master_Company(CompanyName,Address1,Address2,Tagline,LogoUrl,Username,Password,LocalArea,CityCode,CompanyEmail) values(@CompanyName, @Address1, @Address2, @Tagline, @LogoUrl, @Username, @Password, @LocalArea, @CityCode, @CompanyEmail)"; SqlCommand com = new SqlCommand(q, con); //com.Parameters.AddWithValue("@CompanyID", c.CompanyID); com.Parameters.AddWithValue("@CompanyName", c.CompanyName); com.Parameters.AddWithValue("@Address1", c.Address1); com.Parameters.AddWithValue("@Address2", c.Address2); com.Parameters.AddWithValue("@Tagline", c.Tagline); com.Parameters.AddWithValue("@LogoUrl", c.LogoUrl); com.Parameters.AddWithValue("@Username", c.Username); com.Parameters.AddWithValue("@Password", c.Password); com.Parameters.AddWithValue("@LocalArea", c.LocalArea); com.Parameters.AddWithValue("@CityCode", c.CityCode); com.Parameters.AddWithValue("@CompanyEmail", c.CompanyEmail); i = com.ExecuteNonQuery(); } return(i); }
private void OnEdit() { DialogResult dialog = MessageBox.Show(Messge.INF_Edit, Messge.CM_Confirm, MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { master = new Master_Company(); master.Edit_Company(Convert.ToInt32(txtID.Text), txtCompany.Text, txtPhone.Text, txtAddress.Text); MessageBox.Show(Messge.INF_Edit, Messge.CM_Confirm); } else { MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm); } }
private void OnAdd() { DialogResult dialog = MessageBox.Show(Messge.CM_Add, Messge.CM_Confirm, MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { master = new Master_Company(); master.Add_Company(txtCompany.Text, txtPhone.Text, txtAddress.Text); MessageBox.Show(Messge.INF_Save, Messge.CM_Confirm); } else { MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm); } }
private void btnDelete_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show(Messge.CM_Delete, Messge.CM_Confirm, MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { master = new Master_Company(); master.Del_Company(Convert.ToInt32(txtID.Text)); MessageBox.Show(Messge.INF_Delete, Messge.CM_Confirm); Onsearch(); } else { MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm); } }
public JsonResult Add(Master_Company c) { return(Json(db.Addcompany(c), JsonRequestBehavior.AllowGet)); }