public SingleResponeMessage <AnalyzerGroupInfo> Get(int id)
{
SingleResponeMessage <AnalyzerGroupInfo> ret = new SingleResponeMessage <AnalyzerGroupInfo>();
try
{
AnalyzerGroupInfo item = AnalyzerGroupService.GetInstance().getAnalyzerGroup(id);
if (item == null)
{
ret.isSuccess = false;
ret.err.msgCode = "001";
ret.err.msgString = "no AnalyzerGroup found";
return(ret);
}
ret.item = item;
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
/// <summary>
/// Hàm lấy nhóm tài sản theo Code
/// </summary>
/// <param AnalyzerGroupCode="_code"></param>
/// <returns>Return List<AnalyzerGroupInfo></returns>
///
public AnalyzerGroupInfo GetAnalyzerGroupByCode(SqlConnection connection, string _code)
{
AnalyzerGroupInfo result = null;
using (var command = new SqlCommand(
" Select ANG.* " +
" from tbl_AnalyzerGroup AN where AN.AnalyzerGroupCode = @AnalyzerGroupCode"
, connection))
{
AddSqlParameter(command, "@AnalyzerGroupCode", _code, System.Data.SqlDbType.NVarChar);
WriteLogExecutingCommand(command);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
result = new AnalyzerGroupInfo();
result.AnalyzerGroupID = GetDbReaderValue <int>(reader["AnalyzerGroupID"]);
result.AnalyzerGroupCode = GetDbReaderValue <string>(reader["AnalyzerGroupCode"]);
result.AnalyzerGroupName = GetDbReaderValue <string>(reader["AnalyzerGroupName"]);
result.UserI = GetDbReaderValue <string>(reader["UserI"]);
result.InTime = GetDbReaderValue <DateTime?>(reader["InTime"]);
result.UserU = GetDbReaderValue <string>(reader["UserU"]);
result.UpdateTime = GetDbReaderValue <DateTime>(reader["UpdateTime"]);
}
}
return(result);
}
}
public async Task <ActionMessage> createAnalyzerGroup2(AnalyzerGroupInfo _AnalyzerGroup, string _userI)
{
ActionMessage ret = new ActionMessage();
int insetId = -1;
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
insetId = AnalyzerGroupDataLayer.GetInstance().InsertAnalyzerGroup(connection, _AnalyzerGroup, _userI);
//TODO: insert member
// ret.isSuccess = true;
}
catch (Exception ex)
{
throw ex;
}
if (insetId > -1)
{
ret.id = insetId;
ret.isSuccess = true;
}
else
{
ret.isSuccess = false;
ret.err.msgCode = "lỗi thêm nhóm tài sản";
ret.err.msgString = "lỗi thêm nhóm tài sản";
}
return(ret);
}
}
/// <summary>
/// Hàm Insert Tài sản
/// </summary>
/// <param AnalyzerGroupInfo="_AnalyzerGroup"></param>
/// <param userInput="_userI"></param>
/// <returns>Return List<AnalyzerGroupInfo></returns>
///
public int InsertAnalyzerGroup(SqlConnection connection, AnalyzerGroupInfo _AnalyzerGroup, string _userI)
{
int lastestInserted = 0;
var currenttime = DateTime.Now.Date;
if (_AnalyzerGroup.AnalyzerGroupCode == null || _AnalyzerGroup.AnalyzerGroupCode == "")
{
_AnalyzerGroup.AnalyzerGroupCode = DateTime.Now.ToString("yyMMddHHmmssfff");
}
using (var command = new SqlCommand("Insert into [dbo].[tbl_AnalyzerGroup] (AnalyzerGroupCode,AnalyzerGroupName, UserI, UserU, UpdateTime)" +
"VALUES(@AnalyzerGroupCode, @AnalyzerGroupName , @UserI, @UserI, Getdate()) " +
"select IDENT_CURRENT('dbo.tbl_AnalyzerGroup') as LastInserted ", connection))
{
AddSqlParameter(command, "@AnalyzerGroupCode", _AnalyzerGroup.AnalyzerGroupCode, System.Data.SqlDbType.NVarChar);
AddSqlParameter(command, "@AnalyzerGroupName", _AnalyzerGroup.AnalyzerGroupName, System.Data.SqlDbType.NVarChar);
AddSqlParameter(command, "@UserI", _userI, System.Data.SqlDbType.VarChar);
WriteLogExecutingCommand(command);
var lastInsertedRaw = command.ExecuteScalar();
if (lastInsertedRaw != null && !DBNull.Value.Equals(lastInsertedRaw))
{
lastestInserted = Convert.ToInt32(lastInsertedRaw);
}
}
return(lastestInserted);
}
public AnalyzerGroupInfo getAnalyzerGroup(int _ID)
{
AnalyzerGroupInfo record = new AnalyzerGroupInfo();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
record = AnalyzerGroupDataLayer.GetInstance().getAnalyzerGroup(connection, _ID);
if (record == null)
{
return(null);
}
return(record);
}
}
public async Task <ActionMessage> Put(int id, [FromBody] AnalyzerGroupInfo _AnalyzerGroup)
{
ActionMessage ret = new ActionMessage();
try
{
ret = await AnalyzerGroupService.GetInstance().editAnalyzerGroup(id, _AnalyzerGroup, GetUserId());
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public ActionMessage Post([FromBody] AnalyzerGroupInfo _AnalyzerGroup)
{
ActionMessage ret = new ActionMessage();
try
{
ret = AnalyzerGroupService.GetInstance().createAnalyzerGroup(_AnalyzerGroup, GetUserId());
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public AnalyzerGroupInfo GetAnalyzerGroupByCode(string code)
{
AnalyzerGroupInfo record = new AnalyzerGroupInfo();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
record = AnalyzerGroupDataLayer.GetInstance().GetAnalyzerGroupByCode(connection, code);
if (record == null)
{
return(null);
}
return(record);
}
}
/// <summary>
/// Hàm Update Tài sản
/// </summary>
/// <param AnalyzerGroupInfo="_AnalyzerGroup"></param>
/// <param userInput="_userI"></param>
/// <returns>Return List<AnalyzerGroupInfo></returns>
///
public void UpdateAnalyzerGroup(SqlConnection connection, int _id, AnalyzerGroupInfo _AnalyzerGroup, string _userU)
{
using (var command = new SqlCommand("UPDATE tbl_AnalyzerGroup \n" +
" SET AnalyzerGroupCode = @AnalyzerGroupCode , AnalyzerGroupName = @AnalyzerGroupName " +
", UserU=@UserU,UpdateTime=getdate() \n" +
" WHERE (AnalyzerGroupID = @AnalyzerGroupID) ", connection))
{
AddSqlParameter(command, "@AnalyzerGroupID", _id, System.Data.SqlDbType.Int);
AddSqlParameter(command, "@AnalyzerGroupCode", _AnalyzerGroup.AnalyzerGroupCode, System.Data.SqlDbType.NVarChar);
AddSqlParameter(command, "@AnalyzerGroupName", _AnalyzerGroup.AnalyzerGroupName, System.Data.SqlDbType.NVarChar);
AddSqlParameter(command, "@UserU", _userU, System.Data.SqlDbType.VarChar);
WriteLogExecutingCommand(command);
command.ExecuteScalar();
}
}
public ActionMessage createAnalyzerGroup(AnalyzerGroupInfo _AnalyzerGroup, string _userI)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
ret.id = AnalyzerGroupDataLayer.GetInstance().InsertAnalyzerGroup(connection, _AnalyzerGroup, _userI);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "123";
ret.err.msgString = ex.Message;
}
}
return(ret);
}
public async Task <ActionMessage> editAnalyzerGroup(int id, AnalyzerGroupInfo _AnalyzerGroup, string _userU)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
var chkAnalyzerGroupInfo = AnalyzerGroupDataLayer.GetInstance().getAnalyzerGroup(connection, id);
if (chkAnalyzerGroupInfo != null)
{
try
{
AnalyzerGroupDataLayer.GetInstance().UpdateAnalyzerGroup(connection, id, _AnalyzerGroup, _userU);
}
catch (Exception ex)
{
throw ex;
}
}
ret.isSuccess = true;
return(ret);
}
}
/// <summary>
/// Hàm lấy tất cả nhóm tài sản
/// </summary>
/// <param name="connection"> </param>
/// <returns>Return List<AnalyzerGroupInfo></returns>
///
public List <AnalyzerGroupInfo> GetAllAnalyzerGroup(SqlConnection connection, AnalyzerGroupSeachCriteria _criteria)
{
var result = new List <AnalyzerGroupInfo>();
using (var command = new SqlCommand("Select ANG.* " +
" from tbl_AnalyzerGroup ANG " +
" where 1 = 1 order by ANG.AnalyzerGroupName Desc "
, connection))
{
if (_criteria.pageSize == 0)
{
_criteria.pageSize = 10;
}
var offSet = _criteria.pageIndex * _criteria.pageSize;
command.CommandText += " OFFSET @OFFSET ROWS FETCH NEXT @PAGESIZE ROWS ONLY ";
AddSqlParameter(command, "@OFFSET", offSet, System.Data.SqlDbType.Int);
AddSqlParameter(command, "@PAGESIZE", _criteria.pageSize, System.Data.SqlDbType.Int);
WriteLogExecutingCommand(command);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var info = new AnalyzerGroupInfo();
info.AnalyzerGroupID = GetDbReaderValue <int>(reader["AnalyzerGroupID"]);
info.AnalyzerGroupCode = GetDbReaderValue <string>(reader["AnalyzerGroupCode"]);
info.AnalyzerGroupName = GetDbReaderValue <string>(reader["AnalyzerGroupName"]);
info.UserI = GetDbReaderValue <string>(reader["UserI"]);
info.InTime = GetDbReaderValue <DateTime?>(reader["InTime"]);
info.UserU = GetDbReaderValue <string>(reader["UserU"]);
info.UpdateTime = GetDbReaderValue <DateTime>(reader["UpdateTime"]);
result.Add(info);
}
}
return(result);
}
}
