/// <summary>
/// First call after backup operation is failing.
/// </summary>
/// <param name="counter">Repeating counter</param>
/// <returns><see cref="CfcDbChangesDbo"/></returns>
public static CfcDbChangesDbo GetFirstCfcDbChanges(int counter = 3)
{
const string queryString = "EXEC GetFirst_CFC_DB_Changes";
CfcDbChangesDbo rzlt = null;
try
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var da = new SqlDataAdapter(queryString, connection);
da.TableMappings.Add("Table", "CFC_DB_Changes");
var ds = new DataSet();
da.Fill(ds);
DataTable changeList = ds.Tables["CFC_DB_Changes"];
rzlt = (
from chng in changeList.AsEnumerable()
select new CfcDbChangesDbo()
{
DB_Change_GUID = chng.Field <Guid>("DB_Change_GUID"),
CFC_DB_Name = chng.Field <string>("CFC_DB_Name"),
CFC_DB_Major_Version = chng.Field <short>("CFC_DB_Major_Version"),
CFC_DB_Minor_Version = chng.Field <short>("CFC_DB_Minor_Version"),
Seq_No = chng.Field <int>("Seq_No"),
Table_Name = chng.Field <string>("Table_Name"),
Change_Description = chng.Field <string>("Change_Description"),
Created_By = chng.Field <string>("Created_By"),
Created_Date = chng.Field <DateTime>("Created_Date"),
Last_Update_By = chng.Field <string>("Last_Update_By"),
Last_Update = chng.Field <DateTime>("Last_Update"),
}).FirstOrDefault();
connection.Close();
}
}
catch (Exception ex)
{
string msg = ex.Message;
if (counter-- > 0)
{
Thread.Sleep(100);
return(GetFirstCfcDbChanges(counter));
}
}
return(rzlt ?? new CfcDbChangesDbo()
{
DB_Change_GUID = Guid.NewGuid(),
CFC_DB_Name = DatabaseName,
CFC_DB_Major_Version = 1,
CFC_DB_Minor_Version = 0,
Seq_No = 0,
Table_Name = String.Empty,
Change_Description = String.Empty,
Created_By = UserName,
Created_Date = DateTime.Now,
Last_Update_By = UserName,
Last_Update = DateTime.Now,
});
}
public void SetupPage()
{
this.txtServerName2.Text = CfcWebService.SqlServerName;
this.txtDatabaseName2.Text = CfcWebService.DatabaseName;
CfcDbChangesDbo dbo = CfcWebService.GetFirstCfcDbChanges();
txtMajorDbVersion2.Text = Math.Max((short)1, dbo.CFC_DB_Major_Version).ToString();
txtMinorDbVersion2.Text = dbo.CFC_DB_Minor_Version.ToString();
txtTable2.Text = dbo.Table_Name;
}
public void SetupPage()
{
this.txtServerName4.Text = CfcWebService.SqlServerName;
this.txtDatabaseName4.Text = currentDatabase = CfcWebService.DatabaseName;
this.lstTableList4.DataSource = tableList = CfcWebService.GetAllTables();
this.lblErrorMessage4.Text = String.Empty;
this.lstTableList4.DataBind();
CfcDbChangesDbo dbo = CfcWebService.GetFirstCfcDbChanges();
txtMajorDbVersion4.Text = Math.Max((short)1, dbo.CFC_DB_Major_Version).ToString();
txtMinorDbVersion4.Text = dbo.CFC_DB_Minor_Version.ToString();
}
