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);
}
