/// <summary>
/// phuc thuc phuc hoi du lieu , voi duong dan mac dinh se duoc tai cho thu muc cua chuong trinh
/// </summary>
/// <param name="p_FileName"></param>
/// <param name="p_confItem"></param>
public static void CreateRestore(string p_FileName, COMMAND.Config.ConfigItem p_confItem, object p_objCall)
{
try
{
objFormCall = (Form)p_objCall;
objFormCall.Enabled = false;
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_015");
string l_PathApp = Application.StartupPath + "\\App_Data";
if (!System.IO.Directory.Exists(l_PathApp))
{
System.IO.Directory.CreateDirectory(l_PathApp);
}
//khai bao thiet bi du lieu phuc hoi
BackupDeviceItem deviceItem = new BackupDeviceItem(p_FileName, DeviceType.File);
//khai bao doi tuong server
ServerConnection connection = new ServerConnection(p_confItem.StrServerName, p_confItem.StrUserName, p_confItem.StrPassword);
Server sqlServer = new Server(connection);
//khai bao doi tuong database
Database db = sqlServer.Databases[p_confItem.StrDBName];
if (db != null)
{
sqlServer.KillAllProcesses(p_confItem.StrDBName);
}
//khai bao doi tuong phuc hoi du lieu
Restore sqlRestore = new Restore();
sqlRestore.Devices.Add(deviceItem);
sqlRestore.Database = p_confItem.StrDBName;
sqlRestore.Action = RestoreActionType.Database;
String dataFileLocation = l_PathApp + "\\" + p_confItem.StrDBName + ".mdf";
String logFileLocation = l_PathApp + "\\" + p_confItem.StrDBName + "_Log.ldf";
RelocateFile rf = new RelocateFile(p_confItem.StrDBName, dataFileLocation);
sqlRestore.RelocateFiles.Add(new RelocateFile(p_confItem.StrDBName, dataFileLocation));
sqlRestore.RelocateFiles.Add(new RelocateFile(p_confItem.StrDBName + "_log", logFileLocation));
sqlRestore.ReplaceDatabase = true;
sqlRestore.Complete += new ServerMessageEventHandler(sqlRestore_Complete);
sqlRestore.PercentCompleteNotification = 10;
sqlRestore.PercentComplete += new PercentCompleteEventHandler(sqlRestore_PercentComplete);
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_014");
sqlRestore.SqlRestore(sqlServer);
db = sqlServer.Databases[p_confItem.StrDBName];
db.SetOnline();
sqlServer.Refresh();
}
catch (Exception ex)
{
if (objFormCall != null)
{
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_010");
objFormCall.Enabled = true;
LogUtils.Logger.AppLog.Debug(objFormCall.Name, p_confItem.Login_UserName,
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text, ex);
}
}
}
public static bool LoginUser(COMMAND.Config.ConfigItem _confItem, string strUserName, string strPassword)
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
string[] arrParaName = new string[] { "@Name", "@Password" };
object[] arrParaValue = new string[] { strUserName, strPassword };
DataTable tb = _sql.GetDataByStoredProcedure("Usp_Login", arrParaName, arrParaValue);
if (tb.Rows.Count > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// Phuong thuc thuc hien backup du lieu
/// </summary>
/// <param name="p_FileName"></param>
/// <param name="p_confItem"></param>
/// <param name="p_objCall"></param>
public static void CreateBackUp(string p_FileName, COMMAND.Config.ConfigItem p_confItem, object p_objCall)
{
try
{
objFormCall = (Form)p_objCall;
objFormCall.Enabled = false;
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_005");// "Dang khoi dong qua trinh sao luu du lieu";
//WriteToLogAndConsole("Backup the {0} database!", databaseName);
//khai bao thong tin device backup
BackupDeviceItem deviceItem = new BackupDeviceItem(p_FileName, DeviceType.File);
//thiet lap thong tin sql backup
Backup sqlBackup = new Backup();
sqlBackup.Action = BackupActionType.Database;
sqlBackup.Database = p_confItem.StrDBName;
sqlBackup.BackupSetDescription = "ArchiveDataBase:" + DateTime.Now.ToShortDateString();
sqlBackup.BackupSetName = "Archive";
sqlBackup.Initialize = true;
sqlBackup.Checksum = true;
sqlBackup.ContinueAfterError = true;
sqlBackup.Devices.Add(deviceItem);
sqlBackup.Incremental = false;
sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);
sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;
sqlBackup.FormatMedia = false;
sqlBackup.PercentComplete += new PercentCompleteEventHandler(sqlBackup_PercentComplete);
sqlBackup.Complete += new ServerMessageEventHandler(sqlBackup_Complete);
//thiet lap thong tin server va connection den server
ServerConnection connection = new ServerConnection(p_confItem.StrServerName, p_confItem.StrUserID, p_confItem.StrPassword);
Server sqlServer = new Server(connection);
//Database db = sqlServer.Databases[p_confItem.StrDBName];
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_004");
sqlBackup.SqlBackup(sqlServer);
}
catch (Exception ex)
{
if (objFormCall != null)
{
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_000");
objFormCall.Enabled = true;
LogUtils.Logger.AppLog.Debug(objFormCall.Name, p_confItem.Login_UserName,
objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text, ex);
}
}
}
public static bool ketchuyen(COMMAND.Config.ConfigItem _confItem)
{
try
{
string[] arrParaName = new string[] { "@Crt_By" };
object[] arrParaValue = new object[] { _confItem.Login_UserName };
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(_confItem);
if (_sql.ExecuteNonQuery("usp_vpp_ketchuyenkho", arrParaName, arrParaValue) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
//TODO: Ghi log cho nay.
throw ex;
}
}
public static DataTable ListWareHouse(COMMAND.Config.ConfigItem _confItem)
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_WARE_HOUSE"));
}
public static DataTable ListUser(COMMAND.Config.ConfigItem _confItem)
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_USER"));
}
/// <summary>
/// Luu thong tin cau hinh xuong file config
/// </summary>
/// <param name="configItem"></param>
protected void UpdateConfigFileInfo(COMMAND.Config.ConfigItem configItem)
{
COMMAND.Config.Config _Config = new COMMAND.Config.Config();
_Config.WriteSetting("ActiveKey", configItem.StrActiveKey);
_Config.WriteSetting("Serial", configItem.StrSerial);
_Config.WriteSetting("AppName", configItem.StrAppName);
_Config.WriteSetting("Author", configItem.StrAuthor);
_Config.WriteSetting("VersionApp", configItem.StrVersion);
//Ngon ngu dang su dung
_Config.WriteSetting("CurrLang", configItem.StrCurrLang);
//Email
_Config.WriteSetting("Email", configItem.StrEmail);
//Ten hien thi
_Config.WriteSetting("DisplayName", configItem.StrDisplayName);
//Server mail dang smtp
_Config.WriteSetting("MailServerName", configItem.StrMailServerName);
//Port cua server mail
_Config.WriteSetting("MailPort", configItem.StrMailPort);
//Password cua mail
_Config.WriteSetting("MailPass", configItem.StrMailPass);
_Config.WriteSetting("UserName", configItem.StrUserName);
_Config.WriteSetting("Server", configItem.StrServerName);
_Config.WriteSetting("Port", configItem.StrPort);
_Config.WriteSetting("DataBase", configItem.StrDBName);
_Config.WriteSetting("UserID", configItem.StrUserID);
_Config.WriteSetting("Password", configItem.StrPassword);
_Config.WriteSetting("Trusted_Connection", configItem.StrTrustedConnection);
//Duong dan mac dinh cua log file
_Config.WriteSetting("PathLogDefault", configItem.StrPathLog);
//Duong dan mac dinh cua file export
_Config.WriteSetting("PathExPortDefault", configItem.StrPathExport);
//Duong dan mac dinh cua file report bang pdf
_Config.WriteSetting("PathReportDefault", configItem.StrReport);
//Duong dan mac dinh cua file backup
_Config.WriteSetting("PathBackUpDataDefault", configItem.StrPathBackup);
_Config.WriteSetting("thousand_separator", configItem.StrThousandSeparator);
//D?u th?p phân
_Config.WriteSetting("decimal_separator", configItem.StrDecimalSeparator);
//dinh dang ngay thang
_Config.WriteSetting("DateFormat", configItem.StrDateFormat);
//Bat tinh Scroll form cho ung dung hay khong? ==> 1 = Enable; 0 = Disable
_Config.WriteSetting("ScrollMDIChild", CnvToString(configItem.BScrollMDIChild));
// Key ma hoa mat khau
_Config.WriteSetting("SecurityKey", configItem.StrSecurityKey);
////DefaultPageSettings.Margins.Top
//_Config.WriteSetting("DefaultPageSettings.Margins.Top");
////DefaultPageSettings.Margins.Left
//_Config.WriteSetting("DefaultPageSettings.Margins.Left");
////DefaultPageSettings.Margins.Right
//_Config.WriteSetting("DefaultPageSettings.Margins.Right");
////DefaultPageSettings.Margins.Bottom
//_Config.WriteSetting("DefaultPageSettings.Margins.Bottom");
////add data to center page
//_Config.WriteSetting("CenterPartition");
////fit column to page
//_Config.WriteSetting("FitColumnsToPage");
//_Config.WriteSetting("LevelByLevel");
//_Config.WriteSetting("AllowCurrentPage");
//_Config.WriteSetting("AllowPrintToFile");
//_Config.WriteSetting("AllowSelection");
//_Config.WriteSetting("AllowSomePages");
//_Config.WriteSetting("PrintToFile");
//_Config.WriteSetting("ShowHelp");
//_Config.WriteSetting("ShowNetwork");
_Config.WriteSetting("xpdfrc", configItem.Xpdfrc);
}
