public static void Insert(String action, String messageError, String Note)
{
SqlService.ExecuteQuery("insert into ErrorReport ([Action],MsgError,[Datetime],Note,UserID) values('" + action + "','" + Utilities.ReplaceQuot(messageError) + "','" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "','" + GetComputerInfo.GetHostName() + ":" + GetComputerInfo.GetIPAddress() + " - " + "" + " - " + Note + "','" + MYAPPCS.Properties.Settings.Default.id_user + "')");
}
public static void Delete(String TableName, String data, String Note)
{
var formMain = (FormMain)GetOpenForm.GetForm("FormMain");
SqlService.ExecuteQuery("insert into LogApp ([Action],TableName,DataBefore,DataAfter,[Datetime],Note,UserID) values('Delete','" + Utilities.ReplaceQuot(TableName) + "','" + Utilities.ReplaceQuot(data) + "','-','" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "','" + GetComputerInfo.GetHostName() + ":" + GetComputerInfo.GetIPAddress() + " - " + formMain.FormActive + " - " + Utilities.ReplaceQuot(Note) + "','" + MYAPPCS.Properties.Settings.Default.id_user + "')");
}
public static void Logout()
{
SqlService.ExecuteQuery("insert into LogApp ([Action],TableName,DataBefore,DataAfter,[Datetime],Note,UserID) values('Logout','-','-','-','" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "','" + GetComputerInfo.GetHostName() + ":" + GetComputerInfo.GetIPAddress() + "','" + MYAPPCS.Properties.Settings.Default.id_user + "')");
}
public static void GetUserAuth()
{
GetAuthUser = SqlService.GetDataTable("select b.name,allow_view,allow_add,allow_update,allow_delete,allow_print,allow_custom_access from UserRole a left join Roles b on a.id_role = b.id where a.id_user=" + MYAPPCS.Properties.Settings.Default.id_user);
}
