public static int InsertNewRule(Rule item) { try { return(DataConnector.ExecuteNonQuery("INSERT INTO QuyDinh " + "(NgayCapNhat, SoLuongSachTonToiThieuDeNhap, SoLuongSachNhapToiThieu, TienNoToiDa, SoLuongSachTonToiThieuSauKhiBan, DuocThuVuotSoTienKhachHangDangNo) " + string.Format("VALUES ('{0}', {1}, {2}, {3}, {4}, '{5}')", DateTime.Now, item.MinNumberToImport, item.MinNumberWhenImport, item.MaxDebt, item.MinNumberInStore, item.AllowGetMoneyGreaterDebt))); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } return(-1); }
public static int InsertAccount(Account account) { try { string password = account.Email.Split('@')[0]; password = crypto.encodeMD5(crypto.encodeSHA1(password)); return(DataConnector.ExecuteNonQuery( String.Format("INSERT INTO TaiKhoan VALUES(N'{0}', '{1}', N'{2}', {3}, 0)", account.Email, password, account.Name, account.AccessLevel.ID ))); } catch (Exception exception) { ErrorManager.Current.DataCantBeUpdate.Call("Có lỗi xảy ra khi tạo tài khoản mới"); } return(-1); }
public static int ResetPassword(Account account) { try { string password = account.Email.Split('@')[0]; password = crypto.encodeMD5(crypto.encodeSHA1(password)); return(DataConnector.ExecuteNonQuery( String.Format("UPDATE TaiKhoan SET MatKhau = '{0}' WHERE MaTaiKhoan = {1}", password, account.ID ))); } catch (Exception exception) { ErrorManager.Current.DataCantBeUpdate.Call("Có lỗi xảy ra khi reset mật khẩu"); } return(-1); }
public static int UpdateCustomer(Customer item) { try { return(DataConnector.ExecuteNonQuery(string.Format("Update KhachHang set " + " HoTen=N'{0}'," + "SoTienNo={1}," + "DiaChi=N'{2}'," + "DienThoai='{3}'," + "Email=N'{4}'," + "BiXoa='{5}'" + " where MaKhachHang = {6}", item.Name, item.Debt, item.Adress, item.Phone, item.Email, item.IsDeletedItem, item.ID))); } catch (Exception ex) { ErrorManager.Current.DataCantBeUpdate.Call(ex.Message); } return(-1); }
public static int InsertNewNumberReport(ObservableCollection <Book> data, int month, int year) { try { var result = DataConnector.ExecuteNonQuery(string.Format("insert into BaoCaoTon (Thang, Nam) values ({0}, {1})", month, year)); if (result == 1) { var id = ExistNumberReport(month, year); foreach (var c in data) { DataConnector.ExecuteNonQuery(string.Format("insert into ChiTietBaoCaoTon (MaBaoCao, MaSach, SoLuongTonDau, SoLuongTonCuoi) values ({0}, {1}, {2}, {3})", id, c.ID, c.Tag, c.Number)); } } return(result); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } return(-1); }
public static int InsertNewDebtorReport(ObservableCollection <Customer> data, int month, int year) { try { var result = DataConnector.ExecuteNonQuery(string.Format("insert into BaoCaoCongNo (Thang, Nam) values ({0}, {1})", month, year)); if (result == 1) { var id = ExistDebtorReport(month, year); foreach (var c in data) { DataConnector.ExecuteNonQuery(string.Format("insert into ChiTietBaoCaoCongNo (MaBaoCao, MaKhachHang, SoTienNoDau, SoTienNoCuoi) values ({0}, {1}, {2}, {3})", id, c.ID, c.Tag, c.Debt)); } } return(result); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } return(-1); }