private async void timDeleteBackup_Tick(object sender, EventArgs e)
{
// 1000 = 1 seconds
// 60000 = 60 seconds / 1 minute
// 1,800,000 = 30 minutes
// 3,600,000 = 60 minutes / 1 hour
timDeleteBackup.Enabled = false;
if (Settings.Default["Local"].ToString() == "True" && BPrincipalCompany.Get().prco_daysdeletbackups__int > 0 && ObjUser.user_roleaccess__tinyint == 1)
{
tsslOperation.Text = "Deleting older backups...";
tsslOperation.Visible = true;
if (await DeleteBackups())
{
timDeleteBackup.Interval = 7200000;
timDeleteBackup.Enabled = true;
}
else
{
MessageBox.Show("It wasn't possible to delete one or severals backups files.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
tsslOperation.Text = "...";
tsslOperation.Visible = false;
}
}
private async void timCreateBackup_Tick(object sender, EventArgs e)
{
// 1000 = 1 seconds
// 60000 = 60 seconds / 1 minute
// 1,800,000 = 30 minutes
// 3,600,000 = 60 minutes / 1 hour
timCreateBackup.Enabled = false;
if (Settings.Default["Local"].ToString() == "True" && BPrincipalCompany.Get().prco_hoursbetweenbackups__int > 0 && ObjUser.user_roleaccess__tinyint == 1)
{
tsslOperation.Text = "Checking storage backups...";
tsslOperation.Visible = true;
int inHoursToNext = await DoBackup();
if (inHoursToNext != 0)
{
timCreateBackup.Interval = (3600000 * inHoursToNext) + 60000;
timCreateBackup.Enabled = true;
}
else
{
MessageBox.Show(Preferences.GlobalErrorOperation, Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
tsslOperation.Text = "...";
tsslOperation.Visible = false;
}
}
public static Task <bool> DeleteBackups()
{
return(Task.Run(() =>
{
if (Directory.Exists(Preferences.PathBackups))
{
List <string> objList = Directory.GetFiles(Preferences.PathBackups, "*.bak").ToList();
if (objList != null)
{
objList.OrderBy(l => l);
int inDaysConfigirated = BPrincipalCompany.Get().prco_daysdeletbackups__int;
DateTime objDateNow = DateTime.Now;
for (int inCont = 0; inCont < objList.Count; inCont++)
{
if (objList[inCont].Split('\\').Length == 4 || objList[inCont].Split('\\')[3].Length == 63 || objList[inCont].Contains(Preferences.DatabaseName) && RegularExpressions.CheckIsNumeric(objList[inCont].Split('\\')[3].Substring(47, 12), 12, 12))
{
string stDateTime = objList.Last().Split('\\')[3].Substring(47, 12);
int inYear = Convert.ToInt32("20" + stDateTime.Substring(0, 2));
int inMonth = Convert.ToInt32(stDateTime.Substring(2, 2));
int inDay = Convert.ToInt32(stDateTime.Substring(4, 2));
int inHour = Convert.ToInt32(stDateTime.Substring(6, 2));
int inMinute = Convert.ToInt32(stDateTime.Substring(8, 2));
int inSecond = Convert.ToInt32(stDateTime.Substring(10, 2));
TimeSpan objTimeSpan = objDateNow - new DateTime(inYear, inMonth, inDay, inHour, inMinute, inSecond);
if (objTimeSpan.TotalHours > (inDaysConfigirated * 24))
{
try
{
File.Delete(objList[inCont]);
}
catch { }
}
}
}
return true;
}
}
return false;
}));
}
public void RefreshMainValues()
{
objPrincipalCompany = null;
var vPrincipalCompany = BPrincipalCompany.Get();
if (vPrincipalCompany != null)
{
objPrincipalCompany = vPrincipalCompany;
RefreshStates();
RefreshModes();
txtRFC.Text = vPrincipalCompany.prco_rfc__nvarchar;
txtCompany.Text = vPrincipalCompany.prco_name__nvarchar;
txtAddress.Text = vPrincipalCompany.prco_address__nvarchar;
txtPhone.Text = vPrincipalCompany.prco_phone__nvarchar;
txtEmail.Text = vPrincipalCompany.prco_email__nvarchar;
txtFacebook.Text = vPrincipalCompany.prco_facebook__nvarchar;
if (vPrincipalCompany.city_uuid__uniqueidentifier != null)
{
var vCity = BCity.FindByUUID(vPrincipalCompany.city_uuid__uniqueidentifier.Value);
cboState.Text = BState.FindByUUID(vCity.stat_uuid__uniqueidentifier).stat_name__nvarchar;
cboCity.Text = vCity.city_name__nvarchar;
RefreshCities();
}
pcbLogo.Image = vPrincipalCompany.reso_uuid_logo__uniqueidentifier != null?Tools.ConvertirByteAImagen(BResource.FindByUUID(vPrincipalCompany.reso_uuid_logo__uniqueidentifier.Value).reso_value__varbinary) : null;
cboMode.SelectedIndex = vPrincipalCompany.prco_developmentmode__bit ? 0 : 1;
nudHoursToBackup.Value = objPrincipalCompany.prco_hoursbetweenbackups__int;
nudDaysToDelete.Value = objPrincipalCompany.prco_daysdeletbackups__int;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
var vPrincipalCompany = BPrincipalCompany.Get();
if (vPrincipalCompany != null)
{
if (vPrincipalCompany.sess_uuid_used__uniqueidentifier == null)
{
BPrincipalCompany.DisableToEdit(vPrincipalCompany.prco_uuid__uniqueidentifier, ObjForm_004.ObjSession);
txtRFC.Enabled = true;
txtCompany.Enabled = true;
txtAddress.Enabled = true;
txtPhone.Enabled = true;
txtEmail.Enabled = true;
txtFacebook.Enabled = true;
cboState.Enabled = true;
cboCity.Enabled = true;
pcbLogo.Enabled = true;
cboMode.Enabled = true;
nudHoursToBackup.Enabled = true;
nudDaysToDelete.Enabled = true;
btnEdit.Visible = false;
btnAccept.Visible = btnCancel.Visible = true;
btnClose.Enabled = false;
txtRFC.Focus();
byAction = 2;
}
else
{
MessageBox.Show("It isn't possible edit this user because in other session some user is editing it.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
public static Task <int> DoBackup()
{
return(Task.Run(() =>
{
try
{
if (Directory.Exists(Preferences.PathBackups))
{
Directory.CreateDirectory(Preferences.PathBackups);
}
List <string> objList = Directory.GetFiles(Preferences.PathBackups, "*.bak").ToList();
if (objList != null)
{
objList.OrderBy(l => l);
for (int inCont = 0; inCont < objList.Count; inCont++)
{
if (objList[inCont].Split('\\').Length != 4 || objList[inCont].Split('\\')[3].Length != 63 || !objList[inCont].Contains(Preferences.DatabaseName) && !RegularExpressions.CheckIsNumeric(objList[inCont].Split('\\')[3].Substring(47, 12), 12, 12))//if (objList[inCont].Split('\\').Length != 4 || objList[inCont].Split('\\')[3].Length != 63 || !objList[inCont].Contains(Preferences.DatabaseName) && !RegularExpressions.CheckIsNumeric(objList.Last().Split('\\')[3].Substring(47, 12), 12, 12))
{
objList.RemoveAt(inCont);
}
}
}
DateTime objDateNow = DateTime.Now;
string stQuery = "USE master; BACKUP DATABASE " + Preferences.DatabaseName + " TO DISK = N'" + Preferences.PathBackups + "\\" + Preferences.DatabaseName + "_auto_" + DateTime.Now.Year.ToString().Substring(2, 2) + (objDateNow.Month < 10 ? "0" + objDateNow.Month : objDateNow.Month.ToString()) + (objDateNow.Day < 10 ? "0" + objDateNow.Day : objDateNow.Day.ToString()) + "" + (objDateNow.Hour < 10 ? "0" + objDateNow.Hour : objDateNow.Hour.ToString()) + "" + (objDateNow.Minute < 10 ? "0" + objDateNow.Minute : objDateNow.Minute.ToString()) + "" + (objDateNow.Second < 10 ? "0" + objDateNow.Second : objDateNow.Second.ToString()) + ".bak' WITH NOFORMAT, NOINIT, NAME = N'test-Completa Base de datos Copia de seguridad', SKIP, NOREWIND, NOUNLOAD, STATS = 10;";
if (objList == null || objList.Count == 0)
{
if (Business.Execute(stQuery))
{
return BPrincipalCompany.Get().prco_hoursbetweenbackups__int;
}
}
else
{
int inHoursConfigirated = BPrincipalCompany.Get().prco_hoursbetweenbackups__int;
string stDateTime = objList.Last().Split('\\')[3].Substring(47, 12);
int inYear = Convert.ToInt32("20" + stDateTime.Substring(0, 2));
int inMonth = Convert.ToInt32(stDateTime.Substring(2, 2));
int inDay = Convert.ToInt32(stDateTime.Substring(4, 2));
int inHour = Convert.ToInt32(stDateTime.Substring(6, 2));
int inMinute = Convert.ToInt32(stDateTime.Substring(8, 2));
int inSecond = Convert.ToInt32(stDateTime.Substring(10, 2));
TimeSpan objTimeSpan = objDateNow - new DateTime(inYear, inMonth, inDay, inHour, inMinute, inSecond);
if (objTimeSpan.TotalMinutes > (inHoursConfigirated * 60))
{
if (Business.Execute(stQuery))
{
return inHoursConfigirated;
}
}
else
{
return Convert.ToInt32((inHoursConfigirated * 60) - objTimeSpan.TotalMinutes);
}
}
}
catch { }
return 0;
}));
}
private bool RefreshMainValues()
{
if (cboType.SelectedIndex > -1)
{
try
{
var vPrincipalCompany = BPrincipalCompany.Get();
if (cboType.SelectedIndex == 0)
{
var vUsers = BUser.GetAllUsers();
List <Report_Users_001> objListReport = new List <Report_Users_001>();
if (vUsers != null)
{
for (int inCont = 0; inCont < vUsers.Count; inCont++)
{
string stCreatedBy, stModifiedBy;
stCreatedBy = stModifiedBy = "";
var vUserBranches = BUser.GetAllBranches(vUsers[inCont].user_uuid__uniqueidentifier);
if (vUserBranches != null && vUserBranches.Count > 1)
{
var vUser = BUser.FindByUUID(vUserBranches[0].user_uuid__uniqueidentifier.Value);
stCreatedBy = Tools.Decrypt(vUser.user_firstname__nvarchar) + " " + Tools.Decrypt(vUser.user_lastname__nvarchar);
vUser = BUser.FindByUUID(vUserBranches[vUserBranches.Count - 1].user_uuid__uniqueidentifier.Value);
stModifiedBy = Tools.Decrypt(vUser.user_firstname__nvarchar) + " " + Tools.Decrypt(vUser.user_lastname__nvarchar);
}
else
{
stCreatedBy = Tools.Decrypt(vUsers[inCont].user_firstname__nvarchar) + " " + Tools.Decrypt(vUsers[inCont].user_lastname__nvarchar);
}
objListReport.Add(new Report_Users_001()
{
Number = Convert.ToString(inCont + 1),
Username = vUsers[inCont].user_username__nvarchar,
Email = vUsers[inCont].user_email__nvarchar,
Cellphone = vUsers[inCont].user_cellphone__nvarchar,
FirstName = Tools.Decrypt(vUsers[inCont].user_firstname__nvarchar),
LastName = Tools.Decrypt(vUsers[inCont].user_lastname__nvarchar),
RoleAccess = vUsers[inCont].user_roleaccess__tinyint == 1 ? "Administrator" : "<>",
CreatedBy = stCreatedBy,
LastModificationBy = stModifiedBy
});
}
}
///////////////////////////////////////////////////////////////////////////////
rpvReport.LocalReport.ReportEmbeddedResource = "General_Desktop_Application.Reports.Report_Users_001.rdlc";
// We clean DataSource of report.
rpvReport.LocalReport.DataSources.Clear();
//
// We establish the parameters that we'll send them to report.
//
string stPUser = Tools.Decrypt(ObjForm_004.ObjUser.user_firstname__nvarchar) + " " + Tools.Decrypt(ObjForm_004.ObjUser.user_lastname__nvarchar);
string stPCompany = vPrincipalCompany.prco_name__nvarchar;
string stPAddress = vPrincipalCompany.prco_address__nvarchar != null ? vPrincipalCompany.prco_address__nvarchar : "";
ReportParameter[] objReportParameter =
{
new ReportParameter("pReportName", "User Report"),
new ReportParameter("pLogo", vPrincipalCompany.reso_uuid_logo__uniqueidentifier != null ? Convert.ToBase64String(BResource.FindByUUID(vPrincipalCompany.reso_uuid_logo__uniqueidentifier.Value).reso_value__varbinary) : null),
new ReportParameter("pDate", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString()),
new ReportParameter("pCompany", stPCompany.Length > 20 ? stPCompany.Substring(0, 20) : stPCompany),
new ReportParameter("pRFC", vPrincipalCompany.prco_rfc__nvarchar != null ? vPrincipalCompany.prco_rfc__nvarchar :null),
new ReportParameter("pUser", stPUser.Length > 20 ? stPUser.Substring(0, 20) : stPUser),
new ReportParameter("pAddress", stPAddress.Length > 20 ? stPAddress.Substring(0, 20):stPAddress)
};
// We send the list with parameters.
rpvReport.LocalReport.SetParameters(objReportParameter);
//
// We establish the list as report's Datasource.
//
rpvReport.LocalReport.DataSources.Add(new ReportDataSource("dsReport_User_001", objListReport));
// We adjust the report's visualization mode.
rpvReport.SetDisplayMode(DisplayMode.PrintLayout);
rpvReport.ZoomMode = ZoomMode.Percent;
rpvReport.ZoomPercent = 100;
//
// We do a refresh to reportViewer.
//
rpvReport.RefreshReport();
}
}
catch
{
MessageBox.Show(Preferences.GlobalErrorOperation, Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
return(true);
}