public int BackupDatabaseSetting(int userid)
{
try
{
var datapath = _context.CONFIG_SAVE_DATA.Where(x => x.Type == 1).FirstOrDefault();
string filepath = "F:\\POSEZ2U_" + DateTime.Now.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture) + ".Bak";
if (datapath != null)
{
filepath = datapath.LinkPath + "POSEZ2U_" + DateTime.Now.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture) + ".Bak";
}
string dbname = _context.Database.Connection.Database;
string sqlCommand = @"BACKUP DATABASE POSEZ2U TO DISK = '" + filepath + "'";
_context.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbname, filepath));
var datatable = new DATABASE_BACKUP();
datatable.FileName = filepath;
datatable.Notes = filepath;
datatable.CreateBy = userid;
datatable.CreateDate = DateTime.Now;
_context.Entry(datatable).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
return(0);
}
}
public int BackupDatabaseSetting(int userid)
{
try
{
var datapath = _context.CONFIG_SAVE_DATA.Where(x => x.Type == 1).FirstOrDefault();
string filepath = "F:\\POSEZ2U_" + DateTime.Now.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture) + ".Bak";
if (datapath != null)
{
filepath = datapath.LinkPath + "POSEZ2U_" + DateTime.Now.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture) + ".Bak";
}
string dbname = _context.Database.Connection.Database;
string sqlCommand = @"BACKUP DATABASE POSEZ2U TO DISK = '" + filepath + "'";
_context.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbname, filepath));
var datatable = new DATABASE_BACKUP();
datatable.FileName = filepath;
datatable.Notes = filepath;
datatable.CreateBy = userid;
datatable.CreateDate = DateTime.Now;
_context.Entry(datatable).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
return 1;
}
catch (Exception)
{
return 0;
}
}
