public async Task <List <M_Location> > GetLocation(int?id) { try { using (var context = new MasterDbContext(contextOptions)) { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", id) }; var objList = await context.Query <M_LocationObj>().FromSql("call sp_location_get(?)", parameters: sqlParams).ToListAsync(); return(objList.ConvertAll(loc => new M_Location { Id = loc.Id, LocationCode = loc.LocationCode, LocationName = loc.LocationName, LocationDesc = loc.LocationDesc, WarehouseId = loc.WarehouseId, WarehouseName = loc.WarehouseName, CompanyCode = loc.CompanyCode, Is_Active = loc.Is_Active, Created_By = loc.Created_By, Created_Date = loc.Created_Date, Updated_By = loc.Updated_By, Updated_Date = loc.Updated_Date })); } } catch (Exception ex) { throw ex; } }
public async Task <List <M_Product_Process> > GetProductProcess(int prodId) { try { using (var context = new MasterDbContext(contextOptions)) { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", prodId) }; var objList = await context.Query <M_Product_ProcessObj>().FromSql("call sp_product_process_get(?)", parameters: sqlParams).ToListAsync(); return(objList.ConvertAll(p => new M_Product_Process { Id = p.Id, ProductId = p.ProductId, ProcessId = p.ProcessId, Is_Active = p.Is_Active, ProcessSeq = p.ProcessSeq, ProcessCode = p.ProcessCode, ProcessName = p.ProcessName })); } } catch (Exception ex) { throw ex; } }
public async Task <List <M_Product> > GetProduct(int?id) { try { using (var context = new MasterDbContext(contextOptions)) { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", id) }; var objList = await context.Query <M_ProductObj>().FromSql("call sp_product_get(?)", parameters: sqlParams).ToListAsync(); return(objList.ConvertAll(p => new M_Product { Id = p.Id, ProductCode = p.ProductCode, ProductName = p.ProductName, ProductNameRef = p.ProductNameRef, ProductDesc = p.ProductDesc, MaterialTypeId = p.MaterialTypeId, MaterialType = p.MaterialType, ProductionTypeId = p.ProductionTypeId, ProductionType = p.ProductionType, MachineId = p.MachineId, Machine = p.Machine, UnitId = p.UnitId, Unit = p.Unit, PackageStdQty = p.PackageStdQty, SalesPrice1 = p.SalesPrice1, SalesPrice2 = p.SalesPrice2, SalesPrice3 = p.SalesPrice3, SalesPrice4 = p.SalesPrice4, SalesPrice5 = p.SalesPrice5, GLSalesAccount = p.GLSalesAccount, GLInventAccount = p.GLInventAccount, GLCogsAccount = p.GLCogsAccount, RevisionNo = p.RevisionNo, WarehouseId = p.WarehouseId, Warehouse = p.Warehouse, LocationId = p.LocationId, Location = p.Location, ProductImagePath = p.ProductImagePath, CompanyCode = p.CompanyCode, Is_Active = p.Is_Active, Created_Date = p.Created_Date, Created_By = p.Created_By, Updated_Date = p.Updated_Date, Updated_By = p.Updated_By })); } } catch (Exception ex) { throw ex; } }
public async Task <List <M_Material> > GetMaterialByRawType(int?rawMatTypeId, string comp) { try { using (var context = new MasterDbContext(contextOptions)) { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strRawMatTypeId", rawMatTypeId), new MySqlParameter("strCompanyCode", comp) }; var objList = await context.Query <M_MaterialObj>().FromSql("call sp_material_rawmattype_get(?, ?)", parameters: sqlParams).ToListAsync(); return(objList.ConvertAll(m => new M_Material { Id = m.Id, MaterialCode = m.MaterialCode, MaterialName = m.MaterialName, MaterialDesc1 = m.MaterialDesc1, MaterialDesc2 = m.MaterialDesc2, RawMatTypeId = m.RawMatTypeId, RawMatType = m.RawMatType, UnitId = m.UnitId, Unit = m.Unit, PackageStdQty = m.PackageStdQty, WarehouseId = m.WarehouseId, Warehouse = m.Warehouse, LocationId = m.LocationId, Location = m.Location, MaterialImagePath = m.MaterialImagePath, CompanyCode = m.CompanyCode, Is_Active = m.Is_Active, Created_Date = m.Created_Date, Created_By = m.Created_By, Updated_Date = m.Updated_Date, Updated_By = m.Updated_By })); } } catch (Exception ex) { throw ex; } }
public async Task <List <M_Menu> > GetMenu(int?id) { try { using (var context = new MasterDbContext(contextOptions)) { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", id) }; var objList = await context.Query <M_MenuObj>().FromSql("call sp_menu_get(?)", parameters: sqlParams).ToListAsync(); return(objList.ConvertAll(menu => new M_Menu { Id = menu.Id, nameOption = menu.nameOption, controller = menu.controller, action = menu.action, imageClass = menu.imageClass, status = menu.status, isParent = menu.isParent, parentId = menu.parentId, parentName = menu.parentName, area = menu.area, menuseq = menu.menuseq, Is_Active = menu.Is_Active, Created_By = menu.Created_By, Created_Date = menu.Created_Date, Updated_By = menu.Updated_By, Updated_Date = menu.Updated_Date })); } } catch (Exception ex) { throw ex; } }
public async Task <List <M_User> > GetSystemUser(string id) { try { using (var context = new MasterDbContext(contextOptions)) { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", id) }; var objList = await context.Query <M_UserObj>().FromSql("call sp_systemuser_get(?)", parameters: sqlParams).ToListAsync(); return(objList.ConvertAll(user => new M_User { Id = user.Id, UserCode = user.UserCode, UserName = user.UserName, EmpCode = user.EmpCode, DeptId = user.DeptId, DeptName = user.DeptName, Position = user.Position, CompanyCode = user.CompanyCode, aspnetuser_Id = user.aspnetuser_Id, UserImagePath = user.UserImagePath, CompanyLogoPath = user.CompanyLogoPath, Is_Active = user.Is_Active, Created_By = user.Created_By, Created_Date = user.Created_Date, Updated_By = user.Updated_By, Updated_Date = user.Updated_Date })); } } catch (Exception ex) { throw ex; } }