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