void Supplier_Delete() { try { c_row_select = dgrSupplier.SelectedIndex; Supplier_Info _Supplier_Info = (Supplier_Info)dgrSupplier.SelectedItem; if (_Supplier_Info == null) { return; } MessageBoxResult result = NoteBox.Show("Bạn chắc chắn muốn xóa nhà cung cấp hay không?", "Thông báo", NoteBoxLevel.Question); if (MessageBoxResult.Yes == result) { if (c_Supplier_Controller.Supplier_Delete(_Supplier_Info.Supplier_Id)) { NoteBox.Show("Xóa dữ liệu thành công"); LoadData(); } } else { DataGridHelper.NVSFocus(dgrSupplier, c_row_select, 0); } } catch (Exception ex) { CommonData.log.Error(ex.ToString()); } }
void Supplier_Update() { try { c_row_select = dgrSupplier.SelectedIndex; Supplier_Info _Supplier_Info = (Supplier_Info)dgrSupplier.SelectedItem; if (_Supplier_Info == null) { return; } frmCreate_Supplier _frmCreate_Supplier = new frmCreate_Supplier(); _frmCreate_Supplier.c_Supplier_Info = _Supplier_Info; _frmCreate_Supplier.c_type = Convert.ToInt16(Form_Type.Update); _frmCreate_Supplier.Owner = Window.GetWindow(this); _frmCreate_Supplier.ShowDialog(); if (_frmCreate_Supplier.c_id_insert != 0) { LoadData(); } DataGridHelper.NVSFocus(dgrSupplier, c_row_select, 0); } catch (Exception ex) { CommonData.log.Error(ex.ToString()); } }
void Supplier_Insert() { try { frmCreate_Supplier _frmCreate_Supplier = new frmCreate_Supplier(); _frmCreate_Supplier.c_type = Convert.ToInt16(Form_Type.Insert); _frmCreate_Supplier.Owner = Window.GetWindow(this); _frmCreate_Supplier.ShowDialog(); if (_frmCreate_Supplier.c_id_insert != 0) { LoadData(); for (int i = 0; i < c_lst.Count; i++) { Supplier_Info ui = (Supplier_Info)c_lst[i]; if (ui.Supplier_Id == _frmCreate_Supplier.c_id_insert) { c_row_select = i; _frmCreate_Supplier.c_id_insert = 0; break; } } } DataGridHelper.NVSFocus(dgrSupplier, c_row_select, 0); } catch (Exception ex) { CommonData.log.Error(ex.ToString()); } }
public bool Supplier_Insert(Supplier_Info p_Supplier_Info, ref decimal _id) { try { SqlParameter[] spParameter = new SqlParameter[4]; spParameter[0] = new SqlParameter("@Supplier_Name", SqlDbType.NVarChar); spParameter[0].Direction = ParameterDirection.Input; spParameter[0].Value = p_Supplier_Info.Supplier_Name; spParameter[1] = new SqlParameter("@Phone", SqlDbType.NVarChar); spParameter[1].Direction = ParameterDirection.Input; spParameter[1].Value = p_Supplier_Info.Phone; spParameter[2] = new SqlParameter("@Address", SqlDbType.NVarChar); spParameter[2].Direction = ParameterDirection.Input; spParameter[2].Value = p_Supplier_Info.Address; spParameter[3] = new SqlParameter("@Supplier_Id", SqlDbType.Int); spParameter[3].Direction = ParameterDirection.Output; spParameter[3].Value = _id; SqlHelper.ExecuteNonQuery(CommonData.ConnectionString, CommandType.StoredProcedure, "proc_Supplier_Insert", spParameter); _id = Convert.ToDecimal(spParameter[3].Value); return(true); } catch (Exception ex) { CommonData.log.Error(ex.ToString()); return(false); } }
public bool Supplier_Update(decimal p_Supplier_Id, Supplier_Info p_Supplier_Info) { try { return(true); } catch (Exception ex) { CommonData.log.Error(ex.ToString()); return(false); } }
public Supplier_Info Get_Supplier_Info_By_Id(int ID) { Supplier_Info _Supplier_Info = new Supplier_Info(); DataTable dt = Supplier_Info_DA.Get_Supplier_Info_By_Id(ID); foreach (DataRow row in dt.Rows) { _Supplier_Info.ID = ID; _Supplier_Info.Code = row["Code"].ToString(); _Supplier_Info.Name = row["Name"].ToString(); _Supplier_Info.Address = row["Address"].ToString(); _Supplier_Info.Zip_Postal = row["Zip/Postal"].ToString(); _Supplier_Info.State_Province = row["State/Province"].ToString(); _Supplier_Info.Phone = row["Phone"].ToString(); _Supplier_Info.City = row["City"].ToString(); _Supplier_Info.Country = row["Country"].ToString(); _Supplier_Info.Fax = row["Fax"].ToString(); _Supplier_Info.ST_Reg = row["ST_Reg"].ToString(); _Supplier_Info.STRegNTA = row["STRegNTA"].ToString(); } return _Supplier_Info; }
public string Update(int ID, string Code, string Name, string Address, string Zip_Postal, string State_Province, string Phone, string City, string Country, string Fax, string ST_Reg, string STRegNTA) { Supplier_Info _Supplier_Info = new Supplier_Info(); _Supplier_Info.ID = ID; _Supplier_Info.Code = Code; _Supplier_Info.Name = Name; _Supplier_Info.Address = Address; _Supplier_Info.Zip_Postal = Zip_Postal; _Supplier_Info.State_Province = State_Province; _Supplier_Info.Phone = Phone; _Supplier_Info.City = City; _Supplier_Info.Country = Country; _Supplier_Info.Fax = Fax; _Supplier_Info.ST_Reg = ST_Reg; _Supplier_Info.STRegNTA = STRegNTA; _Supplier_Info.UpdatedBy = Session["User"].ToString(); if (_Supplier_Info.UpdatedBy.ToString().ToUpper() == ("Mr. Asif").ToString().ToUpper() || _Supplier_Info.UpdatedBy.ToString().ToUpper() == ("Saud Piracha").ToString().ToUpper() || _Supplier_Info.UpdatedBy.ToString().ToUpper() == ("USAMA").ToString().ToUpper()) { return Supplier_Info_DA.Update(_Supplier_Info); } else { return "-1"; } }
public string Insert(string Code, string Name, string Address, string Zip_Postal, string State_Province, string Phone, string City, string Country, string Fax, string ST_Reg, string STRegNTA) { Supplier_Info _Supplier_Info = new Supplier_Info(); _Supplier_Info.Code = Code; _Supplier_Info.Name = Name; _Supplier_Info.Address = Address; _Supplier_Info.Zip_Postal = Zip_Postal; _Supplier_Info.State_Province = State_Province; _Supplier_Info.Phone = Phone; _Supplier_Info.City = City; _Supplier_Info.Country = Country; _Supplier_Info.Fax = Fax; _Supplier_Info.ST_Reg = ST_Reg; _Supplier_Info.STRegNTA = STRegNTA; _Supplier_Info.CreatedBy = Session["User"].ToString(); return Supplier_Info_DA.Insert(_Supplier_Info); }
void Accept() { try { if (!CheckValidate_F()) { return; } Supplier_Controller _Supplier_Controller = new Supplier_Controller(); if (c_type == Convert.ToInt16(Form_Type.Insert)) { MessageBoxResult result = NoteBox.Show("Bạn chắc chắn muốn thêm mới nhà cung cấp hay không?", "Thông báo", NoteBoxLevel.Question); if (MessageBoxResult.Yes == result) { Supplier_Info _Supplier_Info = new Supplier_Info(); _Supplier_Info.Supplier_Name = txtName.Text; _Supplier_Info.Phone = txtPhone.Text; _Supplier_Info.Address = txtAddress.Text; decimal _id = 0; if (_Supplier_Controller.Supplier_Insert(_Supplier_Info, ref _id)) { NoteBox.Show("Thêm mới thành công"); c_id_insert = _id; this.Close(); } else { NoteBox.Show("Có lỗi trong quá trình thêm mới", "", NoteBoxLevel.Error); } } } else { MessageBoxResult result = NoteBox.Show("Bạn chắc chắn muốn cập nhật hay không?", "Thông báo", NoteBoxLevel.Question); if (MessageBoxResult.Yes == result) { Supplier_Info _Supplier_Info = new Supplier_Info(); _Supplier_Info.Supplier_Name = txtName.Text; _Supplier_Info.Phone = txtPhone.Text; _Supplier_Info.Address = txtAddress.Text; if (_Supplier_Controller.Supplier_Update(c_Supplier_Info.Supplier_Id, _Supplier_Info)) { NoteBox.Show("Cập nhật dữ liệu thành công"); c_id_insert = 1; this.Close(); } else { NoteBox.Show("Có lỗi trong quá trình cập nhật dữ liệu", "", NoteBoxLevel.Error); } } } } catch (Exception ex) { CommonData.log.Error(ex.ToString()); } }