public static string DiaChiCuaHang(string unitCode)
{
string result = "";
if (!string.IsNullOrEmpty(unitCode))
{
using (var context = new ERBusContext())
{
var donvis = context.CUAHANGs.FirstOrDefault(x => x.MA_CUAHANG == unitCode);
if (donvis != null)
{
result = donvis.DIACHI;
}
}
}
return(result);
}
public List <MENU> GetAllForStarting(string username, string unitCode)
{
List <MENU> result = new List <MENU>();
try
{
using (var ctx = new ERBusContext())
{
using (var dbContextTransaction = ctx.Database.BeginTransaction())
{
try
{
var pUserName = new OracleParameter("P_USERNAME", OracleDbType.Varchar2, username, ParameterDirection.Input);
var pUnitCode = new OracleParameter("P_UNITCODE", OracleDbType.Varchar2, unitCode, ParameterDirection.Input);
var pCUR = new OracleParameter("CUR", OracleDbType.RefCursor, ParameterDirection.Output);
var str = "BEGIN ERBUS.GET_MENU(:P_USERNAME,:P_UNITCODE, :CUR); END;";
ctx.Database.ExecuteSqlCommand(str, pUserName, pUnitCode, pCUR);
OracleDataReader reader = ((OracleRefCursor)pCUR.Value).GetDataReader();
while (reader.Read())
{
var item = new MENU()
{
MA_MENU = reader["MA_MENU"].ToString(),
SAPXEP = int.Parse(reader["SAPXEP"].ToString()),
MENU_CHA = reader["MENU_CHA"].ToString(),
TIEUDE = reader["TIEUDE"].ToString()
};
result.Add(item);
}
return(result);
}
catch (Exception ex)
{
throw new Exception("Xảy ra lỗi trong khi chạy Store_Procude. Tự động rollback!");
}
}
}
}
catch (Exception e)
{
throw e;
}
}
public NguoiDungViewModel.Dto FindUser(string username, string password)
{
var result = new NguoiDungViewModel.Dto();
using (var ctx = new ERBusContext())
{
var user = ctx.NGUOIDUNGs.FirstOrDefault(x => x.USERNAME == username && x.TRANGTHAI == 10);
if (user != null)
{
if (user.PASSWORD == MD5Encrypt.Encrypt(password))
{
result = Mapper.Map <NGUOIDUNG, NguoiDungViewModel.Dto>(user);
return(result);
}
}
else
{
result = null;
}
}
return(result);
}
