public Data.Data SelectByUserId(int userId, bool dependency)
{
var data = new Data.Data();
if (!Data.UserExist(userId))
{
throw new Exception("User doesn't exist.");
}
data.AddUser(Data.UserList.Single(x => x.Id == userId));
if (!dependency)
{
return(data);
}
foreach (var good in Data.GoodList.Where(x => x.UserId == userId).ToList())
{
data.AddGood(good);
}
foreach (var category in Data.CategoryList.Where(x => x.UserId == userId).ToList())
{
data.AddCategory(category);
}
return(data);
}
public ActionResult SingIn(Data.User user)
{
try
{
if (repository.ValidateUser(user.EmailId, user.Password))
{
FormsAuthentication.SetAuthCookie(user.EmailId, false);
Data.User currentUser = repository.GetByEmail(user.EmailId);
Session["UserId"] = currentUser.PKUserId;
Session["UserName"] = currentUser.FirstName;
return RedirectToAction("Index", "Home", new { area = "Common" });
}
else
{
TempData["Msg"] = "Login Failed";
return RedirectToAction("Index");
}
}
catch (Exception E1)
{
TempData["Msg"] = "Login Failed " + E1.Message;
//return RedirectToAction("Index");
return View("Error", new HandleErrorInfo(E1,"Login","SingIn"));
}
}
public VehiclePark(int numberOfSectors, int placesPerSector)
{
this.Sectors = numberOfSectors;
this.PlacesPerSector = placesPerSector;
this.database = new Data();
this.database.SectorSpacesTaken = new int[numberOfSectors];
}
public Data.Data SelectByCategoryId(int categoryId, bool dependency)
{
var data = new Data.Data();
if (!Data.CategoryExist(categoryId))
{
throw new Exception("Category doesn't exist.");
}
var category = Data.CategoryList.Single(x => x.Id == categoryId);
data.AddCategory(category);
if (!dependency)
{
return(data);
}
foreach (var user in Data.UserList.Where(x => x.Id == category.UserId).ToList())
{
data.AddUser(user);
}
foreach (var good in Data.SelectGoodByCategory(categoryId).ToList())
{
data.AddGood(good);
}
foreach (var reference in Data.ReferenceList.Where(x => x.CategoryId == category.Id).ToList())
{
data.AddReference(reference);
}
return(data);
}
public BOMenuMon(Data.Transit transit)
{
frmMon = new FrameworkRepository<MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs);
frmNhom = new FrameworkRepository<MENUNHOM>(transit.KaraokeEntities, transit.KaraokeEntities.MENUNHOMs);
frmKichThuocMon = new FrameworkRepository<MENUKICHTHUOCMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUKICHTHUOCMONs);
frmItemMayIn = new FrameworkRepository<MENUITEMMAYIN>(transit.KaraokeEntities, transit.KaraokeEntities.MENUITEMMAYINs);
}
public Data.Data SelectByGoodId(int goodId, bool dependency)
{
var data = new Data.Data();
if (!Data.GoodExist(goodId))
{
throw new Exception("Good doesn't exist.");
}
var good = Data.GoodList.Single(x => x.Id == goodId);
data.AddGood(good);
if (!dependency)
{
return(data);
}
foreach (var user in Data.UserList.Where(x => x.Id == good.UserId).ToList())
{
data.AddUser(user);
}
foreach (var category in Data.SelectCategoryByGood(goodId).ToList())
{
data.AddCategory(category);
}
foreach (var reference in Data.ReferenceList.Where(x => x.GoodId == good.Id).ToList())
{
data.AddReference(reference);
}
return(data);
}
public BOKhachHang(Data.Transit transit)
{
mTransit = transit;
mKaraokeEntities = new KaraokeEntities();
frmKhachHang = new FrameworkRepository<KHACHHANG>(transit.KaraokeEntities, transit.KaraokeEntities.KHACHHANGs);
frmLoaiKhachHang = new FrameworkRepository<LOAIKHACHHANG>(transit.KaraokeEntities, transit.KaraokeEntities.LOAIKHACHHANGs);
}
public void addBalance(string connectionString, Decimal changeAmount, Data.Dber dberr)
{
try
{
if (this.getCreditAllowed())
{
this.newBal = this.actmP.ac_bal + changeAmount;
this.actmP.ac_bal = this.newBal;
//resultP = this.newBal.ToString();
// Check if newBal is at most as much as the maximum balance allowed for the account through ACPRM table.
// Update newBal in Actm.
//Boolean dbCode = Data.ActmD.UpdateAccountBalance(connectionString, this.actmP.ac_no, this.actmP.ac_bal, dberr);
}
else
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_NO_CREDIT);
resultP = dberr.getErrorDesc(connectionString);
}
}
catch(Exception e)
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_NO_DEBIT);
resultP = dberr.getErrorDesc(connectionString);
}
}
public string Serialize(Data.Data Data)
{
return(JsonConvert.SerializeObject(Data, new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.All,
Formatting = Formatting.Indented
}));
}
public void Load()
{
string json = File.ReadAllText(path);
data = JsonConvert.DeserializeObject <Data.Data>(json, new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.All
});
}
public BOXuLyKho(Data.Transit transit)
{
frmXuLyKho = new FrameworkRepository<XULYKHO>(transit.KaraokeEntities, transit.KaraokeEntities.XULYKHOes);
frmKho = new FrameworkRepository<KHO>(transit.KaraokeEntities, transit.KaraokeEntities.KHOes);
frmNhanVien = new FrameworkRepository<NHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.NHANVIENs);
frmXuLyKhoLoai = new FrameworkRepository<XULYKHOLOAI>(transit.KaraokeEntities, transit.KaraokeEntities.XULYKHOLOAIs);
frmTonKho = new FrameworkRepository<TONKHO>(transit.KaraokeEntities, transit.KaraokeEntities.TONKHOes);
frmTonKhoTong = new FrameworkRepository<TONKHOTONG>(transit.KaraokeEntities, transit.KaraokeEntities.TONKHOTONGs);
}
public IQueryable<BOTonKhoTong> GetAll(Data.Transit mTransit)
{
return from tkt in frmTonKhoTong.Query()
join m in frmMon.Query() on tkt.MonID equals m.MonID
select new BOTonKhoTong
{
TonKhoTong = tkt,
Mon = m
};
}
public static void Main()
{
var reader = new ConsoleReader();
var writer = new ConsoleWriter();
var data = new Data.Data();
var engine = new Engine(writer, reader, data);
engine.Run();
}
public CAIDATMAYINHOADON GetAll(Data.Transit transit)
{
CAIDATMAYINHOADON item = mKaraokeEntities.CAIDATMAYINHOADONs.FirstOrDefault();
if (item == null)
{
item = new CAIDATMAYINHOADON();
item.HeaderTextString1 = "";
item.HeaderTextString2 = "";
item.HeaderTextString3 = "";
item.HeaderTextString4 = "";
item.HeaderTextFontSize1 = 12;
item.HeaderTextFontSize2 = 12;
item.HeaderTextFontSize3 = 12;
item.HeaderTextFontSize4 = 12;
item.HeaderTextFontStyle1 = (int)SomeEnum.FontStyles.Normal;
item.HeaderTextFontStyle2 = (int)SomeEnum.FontStyles.Normal;
item.HeaderTextFontStyle3 = (int)SomeEnum.FontStyles.Normal;
item.HeaderTextFontStyle4 = (int)SomeEnum.FontStyles.Normal;
item.HeaderTextFontWeights1 = (int)SomeEnum.FontWeights.Normal;
item.HeaderTextFontWeights2 = (int)SomeEnum.FontWeights.Normal;
item.HeaderTextFontWeights3 = (int)SomeEnum.FontWeights.Normal;
item.HeaderTextFontWeights4 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextString1 = "";
item.FooterTextString2 = "";
item.FooterTextString3 = "";
item.FooterTextString4 = "";
item.FooterTextFontSize1 = 12;
item.FooterTextFontSize2 = 12;
item.FooterTextFontSize3 = 12;
item.FooterTextFontSize4 = 12;
item.FooterTextFontStyle1 = (int)SomeEnum.FontStyles.Normal;
item.FooterTextFontStyle2 = (int)SomeEnum.FontStyles.Normal;
item.FooterTextFontStyle3 = (int)SomeEnum.FontStyles.Normal;
item.FooterTextFontStyle4 = (int)SomeEnum.FontStyles.Normal;
item.FooterTextFontWeights1 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextFontWeights2 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextFontWeights3 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextFontWeights4 = (int)SomeEnum.FontWeights.Normal;
item.SumanyFontSize = 12;
item.SumanyFontStyle = (int)SomeEnum.FontStyles.Normal;
item.SumanyFontWeights = (int)SomeEnum.FontWeights.Normal;
item.SumanyFontSizeBig = 12;
item.SumanyFontStyleBig = (int)SomeEnum.FontStyles.Normal;
item.SumanyFontWeightsBig = (int)SomeEnum.FontWeights.Normal;
item.TitleTextFontSize = 12;
item.TitleTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.TitleTextFontWeights = (int)SomeEnum.FontWeights.Normal;
mKaraokeEntities.CAIDATMAYINHOADONs.AddObject(item);
mKaraokeEntities.SaveChanges();
}
return item;
}
private int processTransaction(string connectionString, String acc_no, Data.Dber dberr)
{
tx = new Cp_Txnm(connectionString, TXID, dberr);
// Check if TXNM fetch for transaction type "010" is successful. Return if error encountered
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
acct = new Cp_Actm(connectionString, acc_no, dberr);
// Check if ACTM fetch for account number acc_no is successful. Return if error encountered
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
// Verify if account has the privilege to execute the transaction
pvg = new Privilege(tx.txnmP.tran_pvga, tx.txnmP.tran_pvgb, acct.actmP.ac_pvg);
if(!pvg.verifyInitPrivilege(dberr))
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if (!pvg.verifyApprovePrivilege())
{
String inData = this.TXID + "|" + acct.actmP.ac_no;
if (pvg.writeToPendingTxns(connectionString, acct.actmP.ac_no, "0", acct.actmP.cs_no1, tx.txnmP.tran_pvgb.ToString(),
tx.txnmP.tran_desc, "0", 0, 0, tx.txnmP.tran_id, inData, dberr) != 0)
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
resultP = Mnemonics.DbErrorCodes.MSG_SENT_FOR_AUTH;
return 0;
}
// Store transaction in hisory table. Determine which history table to store in based on tx.txnmP.tran_fin_type
if (tx.txnmP.tran_fin_type.Equals("Y"))
{
// Write to FINHIST table
Entity.Finhist fhist = new Entity.Finhist(this.acct.actmP.ac_no, "0", this.tx.txnmP.tran_desc,
0, 0, Convert.ToString(this.acct.actmP.ac_bal), "0", "0","0");
Data.FinhistD.Create(connectionString, fhist, dberr);
}
else
{
// Write to NFINHIST table
Entity.Nfinhist nFhist = new Entity.Nfinhist(this.acct.actmP.ac_no, "0", this.tx.txnmP.tran_desc, "0", "0","0");
Data.NfinhistD.Create(connectionString, nFhist, dberr);
}
resultP = Convert.ToString(acct.actmP.ac_bal - acct.actmP.ac_hold);
return 0;
}
public void AddData(Data.Data data)
{
#if UNITY_EDITOR
var tmpData = GetData(data.GetType());
if (tmpData != null)
{
LogUtil.W("Type {0} has been added!", data.GetType());
return;
}
#endif
_dataList.Add(data);
}
public void RemoveData(Data.Data data)
{
#if UNITY_EDITOR
var tmpData = GetData(data.GetType());
if (tmpData == null)
{
LogUtil.W("Type {0} could not been found!", data.GetType());
return;
}
#endif
_dataList.Remove(data);
WorldManager.Instance.PoolMgr.ReleaseData(data);
}
public static NHANVIEN Login(string TenDangNhap, string MatKhau, Data.Transit mTransit)
{
if (TenDangNhap != null && MatKhau != null)
{
var Parameter_TenDangNhap = new System.Data.SqlClient.SqlParameter("@TenDangNhap", System.Data.SqlDbType.VarChar, 50);
Parameter_TenDangNhap.Value = TenDangNhap;
var Parameter_MatKhau = new System.Data.SqlClient.SqlParameter("@MatKhau", System.Data.SqlDbType.VarChar, 255);
Parameter_MatKhau.Value = MatKhau;
List<NHANVIEN> lsArray = mTransit.KaraokeEntities.ExecuteStoreQuery<NHANVIEN>("SP_Login_NhanVien @TenDangNhap, @MatKhau", Parameter_TenDangNhap, Parameter_MatKhau).ToList();
if (lsArray.Count > 0)
return lsArray[0];
}
return null;
}
public BOChiTietBanHang(Data.BOMenuKichThuocMon ktm, Transit transit)
{
mTransit = transit;
this.ChiTietBanHang = new CHITIETBANHANG();
_ListKhuyenMai = new List<BOChiTietBanHang>();
this.MenuKichThuocMon = ktm.MenuKichThuocMon;
this.ChiTietBanHang.SoLuongBan = ktm.MenuKichThuocMon.SoLuongBanBan;
this.ChiTietBanHang.GiaBan = ktm.MenuKichThuocMon.GiaBanMacDinh;
this.ChiTietBanHang.KichThuocLoaiBan = ktm.KichThuocLoaiBan;
this.ChiTietBanHang.GiamGia = ktm.MenuMon.GiamGia;
this.ChiTietBanHang.KichThuocMonID = ktm.MenuKichThuocMon.KichThuocMonID;
this.MenuMon = ktm.MenuMon;
SoLuongBanTam = (int)this.ChiTietBanHang.SoLuongBan;
ChangeThanhTien();
}
public CAIDATBAN GetAll(Data.Transit transit)
{
CAIDATBAN item = fr.Query().FirstOrDefault();
if (item == null)
{
item = new CAIDATBAN();
item.TableWidth = (decimal)0.0735294000;
item.TableHeight = (decimal)0.0938086000;
item.TableFontStyle = (int)SomeEnum.FontStyles.Normal;
item.TableFontWeights = (int)SomeEnum.FontWeights.Normal;
fr.AddObject(item);
fr.Commit();
}
return item;
}
public void GetAll(Data.BOMenuKichThuocMon item)
{
var res = from km in mKaraokeEntities.MENUKHUYENMAIs
join ktm in mKaraokeEntities.MENUKICHTHUOCMONs on km.KichThuocMonTang equals ktm.KichThuocMonID
join mm in mKaraokeEntities.MENUMONs on ktm.MonID equals mm.MonID
where km.KichThuocMonID == item.MenuKichThuocMon.KichThuocMonID && km.Deleted == false
select new BOMenuKhuyenMai
{
MenuKhuyenMai = km,
KichThuocMonTang = new BOMenuKichThuocMon() { MenuMon = mm, MenuKichThuocMon = ktm }
};
foreach (var line in res)
{
item.DanhSachKhuyenMai.Add(line);
}
}
public void Run()
{
var database = new Data();
IUser user = null;
while (true)
{
string input = renderer.ReadLine();
if (input == null)
{
break;
}
var route = new Route(input);
var controllerType = Assembly
.GetExecutingAssembly()
.GetTypes()
.FirstOrDefault(type => type.Name == route.ControllerName);
if (controllerType == null)
{
continue;
}
var controller = Activator.CreateInstance(controllerType, database, user) as Controller;
var action = controllerType.GetMethod(route.ActionName);
object[] @params = MapParameters(route, action);
try
{
var view = action.Invoke(controller, @params) as IView;
if (view != null)
{
renderer.WriteLine(view.Display());
}
if (controller != null)
{
user = controller.User;
}
}
catch (Exception ex)
{
renderer.WriteLine(ex.InnerException.Message);
}
}
}
public CAIDATTHUCDON GetAll(Data.Transit transit)
{
CAIDATTHUCDON item = mKaraokeEntities.CAIDATTHUCDONs.FirstOrDefault();
if (item == null)
{
item = new CAIDATTHUCDON();
item.NhomTextFontSize = 12;
item.NhomTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.NhomTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.MonTextFontSize = 12;
item.MonTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.MonTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.LoaiNhomTextFontSize = 12;
item.LoaiNhomTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.LoaiNhomTextFontWeights = (int)SomeEnum.FontWeights.Normal;
mKaraokeEntities.CAIDATTHUCDONs.AddObject(item);
mKaraokeEntities.SaveChanges();
}
return item;
}
public CAIDATMAYINBEP GetAll(Data.Transit transit)
{
CAIDATMAYINBEP item = mKaraokeEntities.CAIDATMAYINBEPs.FirstOrDefault();
if (item == null)
{
item = new CAIDATMAYINBEP();
item.TitleTextFontSize = 12;
item.TitleTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.TitleTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.InfoTextFontSize = 12;
item.InfoTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.InfoTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.ItemTextFontSize = 12;
item.ItemTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.ItemTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.SumTextFontSize = 12;
item.SumTextFontStyle = (int)SomeEnum.FontStyles.Normal;
item.SumTextFontWeights = (int)SomeEnum.FontWeights.Normal;
mKaraokeEntities.CAIDATMAYINBEPs.AddObject(item);
mKaraokeEntities.SaveChanges();
}
return item;
}
public BOMenuNhom(Data.MENUNHOM menuNhom, Data.MENULOAINHOM menuLoaiNhom)
{
MenuNhom = menuNhom;
MenuLoaiNhom = menuLoaiNhom;
}
public BOMenuNhom(Data.Transit transit)
{
frmNhom = new FrameworkRepository<MENUNHOM>(transit.KaraokeEntities, transit.KaraokeEntities.MENUNHOMs);
frmLoaiNhom = new FrameworkRepository<MENULOAINHOM>(transit.KaraokeEntities, transit.KaraokeEntities.MENULOAINHOMs);
}
public static IQueryable<XULYKHOLOAI> GetQueryNoTracking(Data.Transit mTransit)
{
return FrameworkRepository<XULYKHOLOAI>.QueryNoTracking(mTransit.KaraokeEntities.XULYKHOLOAIs);
}
public override bool IsUpdateRequired(Data.Data data)
{
return(data.GetType() == typeof(ActorStressData));
}
public void Load()
{
var json = File.ReadAllText(Path);
Data = Serializer.Deserialize(json);
}
public Database()
{
data = new Data.Data();
path = "db.txt";
Load();
}
public BOLoaiKhachHang(Data.Transit transit)
{
mKaraokeEntities = new KaraokeEntities();
}
public override bool IsUpdateRequired(Data.Data data)
{
return(data.GetType() == typeof(SpeedData));
}
public override bool IsUpdateRequired(Data.Data data)
{
var type = data.GetType();
return(type == typeof(Physics2DData) || type == typeof(DirectionData));
}
public void ReleaseData(Data.Data data)
{
Release(typeof(Data.Data), data);
}
public BOTonKhoTong(Data.Transit mTransit)
{
frmTonKhoTong = new FrameworkRepository<TONKHOTONG>(mTransit.KaraokeEntities, mTransit.KaraokeEntities.TONKHOTONGs);
frmMon = new FrameworkRepository<MENUMON>(mTransit.KaraokeEntities, mTransit.KaraokeEntities.MENUMONs);
}
public override bool IsUpdateRequired(Data.Data data)
{
return(data.GetType() == typeof(ResourceStateData) || data.GetType() == typeof(ResourceData) ||
data.GetType() == typeof(CreatureStateData));
}
public BOBaoCaoThuChi(Data.Transit transit)
{
mTransit = transit;
mKaraokeEntities = new KaraokeEntities();
}
public void SapXep(int LoaiNhomID, Data.Transit mTransit)
{
var Parameter_LoaiNhomID = new System.Data.SqlClient.SqlParameter("@LoaiNhomID", System.Data.SqlDbType.Int);
Parameter_LoaiNhomID.Value = LoaiNhomID;
mTransit.KaraokeEntities.ExecuteStoreCommand("SP_SAPXEP_NHOM @LoaiNhomID", Parameter_LoaiNhomID);
}
public BOThuChi(Data.Transit transit)
{
mKaraokeEntities = new KaraokeEntities();
}
public BOQuyenNhanVien(Data.Transit transit)
{
frmNhanVien = new FrameworkRepository<NHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.NHANVIENs);
frmQuyen = new FrameworkRepository<QUYEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENs);
frmQuyenNhanVien = new FrameworkRepository<QUYENNHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENNHANVIENs);
}
public override bool IsUpdateRequired(Data.Data data)
{
return(data.GetType() == typeof(ClientJoyStickData));
}
public BOMenuItemMayIn(Data.Transit transit)
{
frmMenuItemMayIn = new FrameworkRepository<MENUITEMMAYIN>(transit.KaraokeEntities, transit.KaraokeEntities.MENUITEMMAYINs);
frmMayIn = new FrameworkRepository<MAYIN>(transit.KaraokeEntities, transit.KaraokeEntities.MAYINs);
frmMenuMon = new FrameworkRepository<MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs);
}
public override bool IsUpdateRequired(Data.Data data)
{
return(data.GetType() == typeof(ResourceHurtData));
}
public BOGiaoDienChucNangBanHang(Data.Transit transit)
{
mKaraokeEntities = new KaraokeEntities();
}
public override bool IsUpdateRequired(Data.Data data)
{
return(false);
}
public BOMenuLoaiNhom(Data.Transit transit)
{
mKaraokeEntities = new KaraokeEntities();
}
public BOMenuLoaiGia(Data.Transit transit)
{
mTransit = transit;
mKaraokeEntities = new KaraokeEntities();
}
public BOCaiDatThucDon(Data.Transit transit)
{
mKaraokeEntities = new KaraokeEntities();
}
