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; })); }
private void btnAccept_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtRFC.Text) || RegularExpressions.CheckIsRFC(txtRFC.Text)) { if (RegularExpressions.CheckIsNormalText(txtCompany.Text, 1, 100)) { if (RegularExpressions.CheckIsNormalText(txtAddress.Text, 0, 255)) { if (RegularExpressions.CheckIsNumeric(txtPhone.Text, 0, 10)) { if (string.IsNullOrEmpty(txtEmail.Text) || RegularExpressions.CheckIskEmail(txtEmail.Text)) { if (RegularExpressions.CheckIsUrl(txtFacebook.Text)) { if (cboState.SelectedIndex < 1 || cboCity.SelectedIndex > -1) { byte[] logo = null; if (pcbLogo.Image != null) { logo = Tools.ConvertirImagenAByte(pcbLogo.Image); } if (BPrincipalCompany.Edit( objPrincipalCompany, !string.IsNullOrEmpty(txtRFC.Text) ? txtRFC.Text : null, txtCompany.Text, !string.IsNullOrEmpty(txtAddress.Text) ? txtAddress.Text : null, !string.IsNullOrEmpty(txtPhone.Text) ? txtPhone.Text : null, !string.IsNullOrEmpty(txtEmail.Text) ? txtEmail.Text : null, !string.IsNullOrEmpty(txtFacebook.Text) ? txtFacebook.Text : null, cboMode.SelectedIndex == 0 ? true : false, Convert.ToInt32(nudHoursToBackup.Value), Convert.ToInt32(nudDaysToDelete.Value), stPathPicture, logo, cboState.SelectedIndex > 0 ? cboState.Text : null, cboCity.SelectedIndex > -1 ? cboCity.Text : null, ObjForm_004.ObjSession )) { txtRFC.Enabled = false; txtCompany.Enabled = false; txtAddress.Enabled = false; txtPhone.Enabled = false; txtEmail.Enabled = false; txtFacebook.Enabled = false; cboState.Enabled = false; cboCity.Enabled = false; pcbLogo.Enabled = false; cboMode.Enabled = false; nudHoursToBackup.Enabled = false; nudDaysToDelete.Enabled = false; pcbLogo.Enabled = false; btnAccept.Visible = btnCancel.Visible = false; btnEdit.Visible = true; btnClose.Enabled = true; byAction = 0; MessageBox.Show(Preferences.GlobalSuccessOperation, Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(Preferences.GlobalErrorOperation, Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("The city must be selected if you selected some city.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCity.Focus(); } } else { MessageBox.Show("The facebook isn't correct.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtFacebook.Focus(); } } else { MessageBox.Show("The email isn't correct.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEmail.Focus(); } } else { MessageBox.Show("The phone isn't correct.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhone.Focus(); } } else { MessageBox.Show("The address isn't correct.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtAddress.Focus(); } } else { MessageBox.Show("The company isn't correct.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCompany.Focus(); } } else { MessageBox.Show("The RFC isn't correct.", Preferences.TitleSoftware, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtRFC.Focus(); } }
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; })); }