public int Update(ASSETKKF_MODEL.Data.Mssql.Mcis.muAPILog d, SqlTransaction transac = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@ID", d.ID);
param.Add("@RefID", d.RefID);
param.Add("@Token", d.Token);
param.Add("@APIName", d.APIName);
param.Add("@Status", d.Status);
param.Add("@StatusMessage", d.StatusMessage);
param.Add("@StartDate", d.StartDate);
param.Add("@EndDate", d.EndDate);
param.Add("@ServerName", d.ServerName);
param.Add("@Input", d.Input);
param.Add("@Output", d.Output);
string cmd = $"UPDATE muAPILog SET " +
"RefID=@RefID, " +
"Token=@Token, " +
"APIName=@APIName, " +
"Status=@Status, " +
"StatusMessage=@StatusMessage, " +
"StartDate=@StartDate, " +
"EndDate=@EndDate, " +
"ServerName=@ServerName, " +
"Input=@Input, " +
"Output=@Output " +
"WHERE ID=@ID;";
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.muAPILog> Search(ASSETKKF_MODEL.Data.Mssql.Mcis.muAPILog d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@ID", d.ID);
param.Add("@RefID", d.RefID);
param.Add("@Token", d.Token);
param.Add("@Status", d.Status);
param.Add("@StatusMessage", d.StatusMessage);
param.Add("@StartDate", d.StartDate);
param.Add("@EndDate", d.EndDate);
param.Add("@ServerName", d.ServerName);
string cmd = "SELECT * FROM muAPILog " +
"WHERE (@ID iS NULL OR ID=@ID) " +
"OR (@RefID iS NULL OR RefID=@RefID) " +
"OR (@Token iS NULL OR Token=@Token) " +
"OR (@Status iS NULL OR Status=@Status) " +
"OR (@StatusMessage iS NULL OR StatusMessage=@StatusMessage) " +
"OR (@StartDate iS NULL OR StartDate=@StartDate) " +
"OR (@EndDate iS NULL OR EndDate=@EndDate) " +
"OR (@ServerName iS NULL OR ServerName=@ServerName);";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.muAPILog>(cmd, param).ToList();
return(res);
}
public int Save(ASSETKKF_MODEL.Data.Mssql.Mcis.muAPILog d, SqlTransaction transac = null)
{
if (d.ID.HasValue)
{
return(Update(d, transac));
}
else
{
return(Insert(d, transac));
}
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.muAPILog d, SqlTransaction transac = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@RefID", d.RefID);
param.Add("@Token", d.Token);
param.Add("@APIName", d.APIName);
param.Add("@Status", d.Status);
param.Add("@StatusMessage", d.StatusMessage);
param.Add("@StartDate", d.StartDate);
param.Add("@EndDate", d.EndDate);
param.Add("@ServerName", d.ServerName);
param.Add("@Input", d.Input);
param.Add("@Output", d.Output);
param.Add("@Remark", d.Remark);
string cmd = "INSERT INTO muAPILog (RefID, Token, APIName, Status, StatusMessage, StartDate, EndDate, ServerName, Input, Output, Remark) " +
"VALUES (@RefID, @Token, @APIName, @Status, @StatusMessage, @StartDate, @EndDate, @ServerName, @Input, @Output, @Remark); " +
"SELECT SCOPE_IDENTITY();";
var res = ExecuteScalar <int>(transac, cmd, param);
return(res);
}
