public static int GetUserID(string userName)
{
using (APAXEntities3 db = new APAXEntities3())
try { return(Task.Run(() =>
db.DM_DTTC.FirstOrDefault(it => it.TAIKHOAN.Equals(userName)).ID_DTTC).Result); }
catch { return(0); }
}
public static int GetUserID()
{
var name = System.Threading.Thread.CurrentPrincipal.Identity.Name;
using (APAXEntities3 db = new APAXEntities3())
{
return((db.DM_DTTC.FirstOrDefault(it => it.TAIKHOAN.Equals(name))).ID_DTTC);
}
}
public string[] GetAllRolesByUser(string userName)
{
try
{
using (APAXEntities3 db = new APAXEntities3())
{
TH_HOSOKHACHHANG Quyen = db.TH_HOSOKHACHHANG.FirstOrDefault(it => it.TAIKHOAN.Equals(userName));
if (Quyen != null && Quyen.ID_QUYENNGUOIDUNG > 0)
{
var strQuyen = db.DM_QUYEN.FirstOrDefault(it => it.A_QUYEN == Quyen.ID_QUYENNGUOIDUNG);
return(strQuyen != null?strQuyen.QUYENNGUOIDUNG.Split(',') : null);
}
return(null);
}
}
catch { return(null); }
}
public async Task <TH_DUBAO> GetDKNghiPhep(int?ID)
{
try
{
using (APAXEntities3 db = new APAXEntities3())
{
if (ID > 0)
{
TH_DUBAO model = await Task.Run(() => db.TH_DUBAO.FirstOrDefault(it => it.A_TH_DUBAO == ID));
return(model);
}
return(null);
}
}
catch { return(null); }
}
public async Task <TH_HOSOKHACHHANG> GetHoSoKhachHang(int?ID)
{
try
{
using (APAXEntities3 db = new APAXEntities3())
{
if (ID > 0)
{
TH_HOSOKHACHHANG model = await Task.Run(() => db.TH_HOSOKHACHHANG.FirstOrDefault(it => it.A_HOSOKHACHHANG == ID));
return(model);
}
return(null);
}
}
catch { return(null); }
}
public async Task <PQ_NGUOIDUNG> GetUserLogin(string userName, string pass)
{
try
{
using (APAXEntities3 db = new APAXEntities3())
{
if (!String.IsNullOrEmpty(userName))
{
PQ_NGUOIDUNG model = await db.PQ_NGUOIDUNG.FirstOrDefaultAsync(it => it.TAIKHOAN.Equals(userName) && it.MATKHAU.Equals(pass));
return(model);
}
return(null);
}
}
catch { return(null); }
}
public override string[] GetRolesForUser(string userName)
{
try
{
if (userName.Equals("Administrator"))
{
List <string> Quyen = new List <string>();
Quyen.Add("0=0");
return(Quyen.ToArray());
}
using (APAXEntities3 db = new APAXEntities3())
{
TH_HOSOKHACHHANG nguoiDung = db.TH_HOSOKHACHHANG.FirstOrDefault(it => it.TAIKHOAN.Equals(userName));
if (nguoiDung != null)
{
string[] _Quyen = null;
List <string> Quyen = new List <string>();
string[] QuyenUser = GetAllRolesByUser(userName);
if (QuyenUser != null)
{
Quyen.AddRange(QuyenUser);
}
if (Quyen.Count > 0)
{
_Quyen = Quyen.Distinct().ToArray();
}
if (_Quyen == null)
{
_Quyen[0] = "IsNull";
}
return(_Quyen);
}
}
List <string> Quyen0 = new List <string>();
Quyen0.Add("IsNull");
return(Quyen0.ToArray());
}
catch
{
List <string> Quyen = new List <string>();
Quyen.Add("IsNull");
return(Quyen.ToArray());
}
}
public async Task <int> GetUserID(HttpCookieCollection Cookies)
{
try
{
using (APAXEntities3 db = new APAXEntities3())
{
string userName = GetUserName().ToLower();
TH_HOSOKHACHHANG model = await Task.Run(() => db.TH_HOSOKHACHHANG
.FirstOrDefault(it => it.TAIKHOAN.ToLower().Equals(userName)));
if (model != null)
{
return(model.A_HOSOKHACHHANG);
}
else
{
return(1);
}
}
}
catch { return(1); }
}
public int UpdateChuyenPhi(
int A_HOSOKHACHHANG_CHUYEN,
int?A_KEHOACH_CHUYEN,
int A_HOSOKHACHHANG_NHAN,
int?A_KEHOACH_NHAN,
decimal?SOTIEN,
int?SOBUOICON,
decimal DONGIABUOI,
int?A_SANPHAM_NHAN,
int A_TH_HOPDONG_NHAN,
int?A_SANPHAM_CHUYEN,
int A_TH_HOPDONG_CHUYEN,
DateTime?NGAYBATDAU_CHUYEN,
DateTime?NGAYCHUYEN,
DateTime?NGAYBATDAU_NHAN,
DateTime?NHAYKETTHUC_NHAN,
int?SOBUOINHAN,
decimal?DONGIACHUYEN,
decimal?DONGIANHAN,
decimal?ThanhTien,
int?HinhThucChuyenPhi,
int?A_DUBAO_XEPLOP)
{
try
{
int sc = 0, ec = 0;
APAXEntities3 db = new APAXEntities3();
db.TH_DUBAO.Add(new TH_DUBAO()
{
J_HOSOKHACHHANG = A_HOSOKHACHHANG_CHUYEN,
J_TH_HOPDONG = A_TH_HOPDONG_CHUYEN,
ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
DULIEUNHOM = true,
J_KEHOACH = A_KEHOACH_CHUYEN,
NGAYLAM = DateTime.Now,
NGAYGIAOHANG = NGAYBATDAU_CHUYEN,
NGAYTHANHTOAN = NGAYCHUYEN,
SOBUOI = SOBUOICON,
TONGTIEN_DH = SOTIEN,
ID_LYDO_HV = 99,
ID_THAIDO = HinhThucChuyenPhi,
ID_LYDO_TD = 241
});
sc += db.SaveChanges();
if (sc > 0)
{
int a_th_dubao = db.TH_DUBAO.OrderByDescending(t => t.A_TH_DUBAO).FirstOrDefault().A_TH_DUBAO;
db.TH_DUBAO_SANPHAM.Add(new TH_DUBAO_SANPHAM()
{
J_TH_DUBAO = a_th_dubao,
J_SANPHAM = A_SANPHAM_CHUYEN > 0?(int)A_SANPHAM_CHUYEN:0,
SOLUONG = SOBUOICON == null ? 0 : decimal.Parse(SOBUOICON.ToString()),
DONGIA = SOTIEN,
THANHTIEN = SOTIEN * (SOBUOICON == null ? 0 : decimal.Parse(SOBUOICON.ToString())),
});
sc += db.SaveChanges();
if (sc >= 2)
{
db.TH_DUBAO.Add(new TH_DUBAO()
{
J_HOSOKHACHHANG = A_HOSOKHACHHANG_NHAN,
J_TH_HOPDONG = A_TH_HOPDONG_NHAN,
ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
DULIEUNHOM = true,
J_KEHOACH = A_KEHOACH_NHAN,
NGAYLAM = DateTime.Now,
NGAYGIAOHANG = NGAYBATDAU_NHAN,
NGAYTHANHTOAN = NHAYKETTHUC_NHAN,
SOBUOI = SOBUOICON,
TONGTIEN_DH = SOTIEN,
ID_THAIDO = HinhThucChuyenPhi,
ID_LYDO_HV = 1103,
ID_LYDO_TD = 241,
A_THUCHIEN = a_th_dubao
});
ec += db.SaveChanges();
if (ec > 0)
{
int a_th_dubaonhan = db.TH_DUBAO.OrderByDescending(t => t.A_TH_DUBAO).FirstOrDefault().A_TH_DUBAO;
db.TH_DUBAO_SANPHAM.Add(new TH_DUBAO_SANPHAM()
{
J_TH_DUBAO = a_th_dubaonhan,
J_SANPHAM = A_SANPHAM_NHAN > 0?(int)A_SANPHAM_NHAN:0,
SOLUONG = SOBUOINHAN == null ? 0 : decimal.Parse(SOBUOINHAN.ToString()),
DONGIA = DONGIANHAN,
THANHTIEN = DONGIANHAN * (SOBUOINHAN == null ? 0 : decimal.Parse(SOBUOINHAN.ToString())),
});
ec += db.SaveChanges();
TH_DUBAO DUBAO = db.TH_DUBAO.FirstOrDefault(st => st.A_TH_DUBAO == A_DUBAO_XEPLOP);
DUBAO.ID_TRANGTHAI = 1;
db.Entry(DUBAO).State = EntityState.Modified;
sc += db.SaveChanges();
}
}
else
{
return(0);
}
}
//db.TH_THUTIEN.Add(new TH_THUTIEN()
//{
// J_HOSOKHACHHANG = A_HOSOKHACHHANG_NHAN,
// J_TH_HOPDONG = A_TH_HOPDONG_NHAN,
// NGAYTHUTIEN = DateTime.Now,
// SOTIENTHU = SOTIEN,
// ID_LOAIPHIEUTHU = 3,
// ID_DTTC = FCVDataProvider.GetUserID(User.Identity.Name),
// MATHUTIEN = "1111",
// DULIEUNHOM = true
//});
//sc += db.Database.ExecuteSqlCommand("UPDATE dbo.TH_DUBAO SET NGAYTHANHTOAN = GETDATE(), ID_LYDO_TD = 240 WHERE J_HOSOKHACHHANG= '" + A_HOSOKHACHHANG_CHUYEN + "' AND J_KEHOACH = '" + A_KEHOACH_CHUYEN + "'");
//db.SaveChanges();
return(sc);
}
catch
{
return(0);
}
}
