//Update row in Tbl_Log_Activities_y Table
public async Task <bool> Tbl_Log_Activities_yUpdate(Tbl_Log_Activities_y tbl_Log_Activities_y)
{
using (var conn = new SqlConnection(_configuration.Value))
{
Debug.WriteLine(tbl_Log_Activities_y.ID);
var parameters = new DynamicParameters();
parameters.Add("ID", tbl_Log_Activities_y.ID, System.Data.DbType.String);
parameters.Add("pTimeStamp", tbl_Log_Activities_y.TimeStamp, System.Data.DbType.DateTime);
parameters.Add("pUser_ID", tbl_Log_Activities_y.User_ID, System.Data.DbType.String);
parameters.Add("pUser_Name", tbl_Log_Activities_y.User_Name, System.Data.DbType.String);
parameters.Add("pUser_Job", tbl_Log_Activities_y.User_Job, System.Data.DbType.String);
parameters.Add("pUser_Department", tbl_Log_Activities_y.User_Department, System.Data.DbType.String);
parameters.Add("pUser_Can_Navigate", tbl_Log_Activities_y.User_Can_Navigate, System.Data.DbType.Boolean);
parameters.Add("pPage_Name", tbl_Log_Activities_y.Page_Name, System.Data.DbType.String);
parameters.Add("pPage_Title", tbl_Log_Activities_y.Page_Title, System.Data.DbType.String);
parameters.Add("pHRDW", tbl_Log_Activities_y.HRDW, System.Data.DbType.String);
parameters.Add("pIP", tbl_Log_Activities_y.IP, System.Data.DbType.String);
parameters.Add("pDevice", tbl_Log_Activities_y.Device, System.Data.DbType.String);
parameters.Add("pAction", tbl_Log_Activities_y.Action, System.Data.DbType.String);
parameters.Add("pAction_Code", tbl_Log_Activities_y.Action_Code, System.Data.DbType.String);
parameters.Add("pAction_description", tbl_Log_Activities_y.Action_description, System.Data.DbType.String);
parameters.Add("pAction_QueryString", tbl_Log_Activities_y.Action_QueryString, System.Data.DbType.String);
parameters.Add("pProccessID", tbl_Log_Activities_y.ProccessID, System.Data.DbType.String);
parameters.Add("pAffected_tables", tbl_Log_Activities_y.Affected_tables, System.Data.DbType.String);
parameters.Add("pNotes", tbl_Log_Activities_y.Notes, System.Data.DbType.String);
Debug.WriteLine("Done . . .");
}
return(true);
}
//Insert new row to Tbl_Log_Activities_y Table
public async Task <bool> Tbl_Log_Activities_yInsert(Tbl_Log_Activities_y tbl_Log_Activities_y)
{
using (var conn = new SqlConnection(_configuration.Value))
{
//Debug.WriteLine(">> " + conn.ConnectionString);
var parameters = new DynamicParameters();
parameters.Add("pUser_ID", tbl_Log_Activities_y.User_ID, System.Data.DbType.String);
parameters.Add("pUser_Name", tbl_Log_Activities_y.User_Name, System.Data.DbType.String);
parameters.Add("pUser_Job", tbl_Log_Activities_y.User_Job, System.Data.DbType.String);
parameters.Add("pUser_Department", tbl_Log_Activities_y.User_Department, System.Data.DbType.String);
parameters.Add("pUser_Can_Navigate", tbl_Log_Activities_y.User_Can_Navigate, System.Data.DbType.Boolean);
parameters.Add("pPage_Name", tbl_Log_Activities_y.Page_Name, System.Data.DbType.String);
parameters.Add("pPage_Title", tbl_Log_Activities_y.Page_Title, System.Data.DbType.String);
parameters.Add("pHRDW", tbl_Log_Activities_y.HRDW, System.Data.DbType.String);
parameters.Add("pIP", tbl_Log_Activities_y.IP, System.Data.DbType.String);
parameters.Add("pDevice", tbl_Log_Activities_y.Device, System.Data.DbType.String);
parameters.Add("pAction", tbl_Log_Activities_y.Action, System.Data.DbType.String);
parameters.Add("pAction_Code", tbl_Log_Activities_y.Action_Code, System.Data.DbType.String);
parameters.Add("pAction_description", tbl_Log_Activities_y.Action_description, System.Data.DbType.String);
parameters.Add("pAction_QueryString", tbl_Log_Activities_y.Action_QueryString, System.Data.DbType.String);
parameters.Add("pProccessID", tbl_Log_Activities_y.ProccessID, System.Data.DbType.String);
parameters.Add("pAffected_tables", tbl_Log_Activities_y.Affected_tables, System.Data.DbType.String);
parameters.Add("pNotes", tbl_Log_Activities_y.Notes, System.Data.DbType.String);
//Raw sql Method
await conn.ExecuteAsync("sp_Insert_Tbl_Log_Activities_y", parameters, commandType : System.Data.CommandType.StoredProcedure);
}
return(true);
}
