public static Model.mdlUserConfig LoadUserConfigbyDeviceID(string DeviceID)
{
var mdlUserConfig = new Model.mdlUserConfig();
List<SqlParameter> sp = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@DeviceID", SqlDbType = SqlDbType.VarChar, Value = DeviceID },
};
DataTable dtUserConfig = Manager.DataFacade.DTSQLCommand("SELECT * FROM UserConfig WHERE DeviceID = @DeviceID", sp);
foreach (DataRow drUserConfig in dtUserConfig.Rows)
{
mdlUserConfig.DeviceID = drUserConfig["DeviceID"].ToString();
mdlUserConfig.EmployeeID = drUserConfig["EmployeeID"].ToString();
mdlUserConfig.BranchID = drUserConfig["BranchID"].ToString();
mdlUserConfig.BranchName = drUserConfig["BranchName"].ToString();
mdlUserConfig.VehicleNumber = drUserConfig["VehicleNumber"].ToString();
mdlUserConfig.IpLocal = drUserConfig["IpLocal"].ToString();
mdlUserConfig.PortLocal = drUserConfig["PortLocal"].ToString();
mdlUserConfig.IpPublic = drUserConfig["IpPublic"].ToString();
mdlUserConfig.PortPublic = drUserConfig["PortPublic"].ToString();
mdlUserConfig.IpAlternative = drUserConfig["IpAlternative"].ToString();
mdlUserConfig.PortAlternative = drUserConfig["PortAlternative"].ToString();
mdlUserConfig.Password = drUserConfig["Password"].ToString();
}
return mdlUserConfig;
}
public static List<Model.mdlUserConfig> LoadUserConfigByCertainBranch(string keyword, string branchid)
{
var mdlUserConfigList = new List<Model.mdlUserConfig>();
List<SqlParameter> sp = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@keyword", SqlDbType = SqlDbType.VarChar, Value = "%" +keyword+ "%" },
new SqlParameter() {ParameterName = "@branchid", SqlDbType = SqlDbType.VarChar, Value = "%" +branchid+ "%" }
};
DataTable dtUserConfig = Manager.DataFacade.DTSQLCommand("SELECT * FROM UserConfig WHERE (DeviceID LIKE @keyword OR EmployeeID LIKE @keyword) AND (BranchID IN ("+branchid+")) ORDER BY BranchID,EmployeeID ASC", sp);
foreach (DataRow drUserConfig in dtUserConfig.Rows)
{
var mdlUserConfig = new Model.mdlUserConfig();
mdlUserConfig.DeviceID = drUserConfig["DeviceID"].ToString();
mdlUserConfig.EmployeeID = drUserConfig["EmployeeID"].ToString();
mdlUserConfig.BranchID = drUserConfig["BranchID"].ToString();
mdlUserConfig.BranchName = drUserConfig["BranchName"].ToString();
mdlUserConfig.VehicleNumber = drUserConfig["VehicleNumber"].ToString();
mdlUserConfig.IpLocal = drUserConfig["IpLocal"].ToString();
mdlUserConfig.PortLocal = drUserConfig["PortLocal"].ToString();
mdlUserConfig.IpPublic = drUserConfig["IpPublic"].ToString();
mdlUserConfig.PortPublic = drUserConfig["PortPublic"].ToString();
mdlUserConfig.IpAlternative = drUserConfig["IpAlternative"].ToString();
mdlUserConfig.PortAlternative = drUserConfig["PortAlternative"].ToString();
mdlUserConfigList.Add(mdlUserConfig);
}
return mdlUserConfigList;
}
