private async void OnStartSearchCommandsExcuted(object obj)
{
await Task.Run(() =>
{
try
{
DetailsInfo.Clear();
FileContentMatchEngine.Instance.MatchesCount = 0;
SkinAssistanceCommands.StartRealTimerCommand.ExcuteCommand(true);
var options = FileMatcheOptions.Where(o => o.IsSelected);
var fileList = Directory.GetFiles(FindDir, "*.cs", SearchOption.AllDirectories);
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"Analyze Start");
foreach (var file in fileList)
{
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"analyze {file} start");
FileContentMatchEngine.Instance.Match(file, options, matchoption);
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"analyze {file} end");
}
SkinAssistanceCommands.StartRealTimerCommand.ExcuteCommand(false);
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"Analyze End");
}
catch (Exception e)
{
this.Error(e);
}
});
}
private void ThumbnailList_Loaded(object sender, RoutedEventArgs args)
{
if (_currentTransition != null)
{
DetailsInfo info = (DetailsInfo)_currentTransition.Payload;
GridViewItem item = (GridViewItem)ThumbnailList.ContainerFromItem(info.thumbanil);
CompositionImage image = VisualTreeHelperExtensions.GetFirstDescendantOfType <CompositionImage>(item);
ScrollViewer scrollViewer = VisualTreeHelperExtensions.GetFirstDescendantOfType <ScrollViewer>(ThumbnailList);
// Kick off the transition now that the page has loaded
_currentTransition.Start(MyGrid, image, scrollViewer, ThumbnailList);
}
}
private static int EnterNewDetailsindb(DetailsInfo NewDetails)
{
int returnVal = 0;
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "INSERT INTO details(id,presentdate,name,address,adresscont,city,state,zip,phone,fax,website,emailconvention,datasource,status,facility,uniquecntctid,firstmame,lastname,position) "
+ "VALUES(@id,@presentdate,@name,@address,@adresscont,@city,@state,@zip,@phone,@fax,@website,@emailconvention,@datasource,@status,@facility,@uniquecntctid,@firstmame,@lastname,@position)";
msqlCommand.Parameters.AddWithValue("@id", NewDetails.id);
msqlCommand.Parameters.AddWithValue("@presentdate", NewDetails.presentdate);
msqlCommand.Parameters.AddWithValue("@name", NewDetails.name);
msqlCommand.Parameters.AddWithValue("@address", NewDetails.address);
msqlCommand.Parameters.AddWithValue("@adresscont", NewDetails.adresscont);
msqlCommand.Parameters.AddWithValue("@city", NewDetails.city);
msqlCommand.Parameters.AddWithValue("@state", NewDetails.state);
msqlCommand.Parameters.AddWithValue("@zip", NewDetails.zip);
msqlCommand.Parameters.AddWithValue("@phone", NewDetails.phone);
msqlCommand.Parameters.AddWithValue("@fax", NewDetails.fax);
msqlCommand.Parameters.AddWithValue("@website", NewDetails.website);
msqlCommand.Parameters.AddWithValue("@emailconvention", NewDetails.emailconvention);
msqlCommand.Parameters.AddWithValue("@datasource", NewDetails.datasource);
msqlCommand.Parameters.AddWithValue("@status", NewDetails.status);
msqlCommand.Parameters.AddWithValue("@facility", NewDetails.facility);
msqlCommand.Parameters.AddWithValue("@uniquecntctid", NewDetails.uniquecntctid);
msqlCommand.Parameters.AddWithValue("@firstmame", NewDetails.firstmame);
msqlCommand.Parameters.AddWithValue("@lastname", NewDetails.lastname);
msqlCommand.Parameters.AddWithValue("@position", NewDetails.position);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return(returnVal);
}
public int DetailsAdd(DetailsInfo infoDetails)
{
int retunvalue = 0;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sqlcmd = new SqlCommand("DetailsAdd", base.sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@masterId", SqlDbType.Int).Value = infoDetails.MasterId;
sqlcmd.Parameters.Add("@name", SqlDbType.VarChar).Value = infoDetails.Name;
sqlcmd.Parameters.Add("@text", SqlDbType.VarChar).Value = infoDetails.Text;
sqlcmd.Parameters.Add("@row", SqlDbType.Int).Value = infoDetails.Row;
sqlcmd.Parameters.Add("@columns", SqlDbType.Int).Value = infoDetails.Columns;
sqlcmd.Parameters.Add("@width", SqlDbType.Int).Value = infoDetails.Width;
sqlcmd.Parameters.Add("@dbf", SqlDbType.VarChar).Value = infoDetails.DBF;
sqlcmd.Parameters.Add("@DorH", SqlDbType.VarChar).Value = infoDetails.DorH;
sqlcmd.Parameters.Add("@repeat", SqlDbType.VarChar).Value = infoDetails.Repeat;
sqlcmd.Parameters.Add("@align", SqlDbType.VarChar).Value = infoDetails.Align;
sqlcmd.Parameters.Add("@repeatAll", SqlDbType.VarChar).Value = infoDetails.RepeatAll;
sqlcmd.Parameters.Add("@footerRepeatAll", SqlDbType.VarChar).Value = infoDetails.FooterRepeatAll;
sqlcmd.Parameters.Add("@textWrap", SqlDbType.VarChar).Value = infoDetails.TextWrap;
sqlcmd.Parameters.Add("@wrapLineCount", SqlDbType.VarChar).Value = infoDetails.WrapLineCount;
sqlcmd.Parameters.Add("@fieldsForExtra", SqlDbType.VarChar).Value = infoDetails.FieldsForExtra;
sqlcmd.Parameters.Add("@extraFieldName", SqlDbType.VarChar).Value = infoDetails.ExtraFieldName;
retunvalue = int.Parse(sqlcmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "DetailsAdd", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
finally
{
base.sqlcon.Close();
}
return(retunvalue);
}
private async void OnStartSearchCommandsExcuted(object obj)
{
await Task.Run(() =>
{
try
{
ResourceManager.Default.Initialize(AppName);
matchoption.ResourceCulture = UICultrues.Where(o => o.IsSelected).Select(o => o.MatchName).ToList();
DetailsInfo.Clear();
FileContentMatchEngine.Instance.MatchesCount = 0;
if (matchoption.ResourceCulture.Any())
{
SkinAssistanceCommands.StartRealTimerCommand.ExcuteCommand(true);
var options = FileMatcheOptions.Where(o => o.IsSelected);
var fileList = Directory.GetFiles(FindDir, "*.cs", SearchOption.AllDirectories);
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"Analyze Start");
foreach (var file in fileList)
{
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"analyze {file} start");
FileContentMatchEngine.Instance.Match(file, options, matchoption);
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"analyze {file} end");
}
matchoption.ResourceCulture.ForEach(o =>
{
SkinAssistanceCommands.ShowDetailsInformationCommand.ExcuteCommand <string>($"build resource {o} start");
ResourceManager.Default.SaveAs(CultureInfo.GetCultureInfo(o));
SkinAssistanceCommands.ShowDetailsInformationCommand.ExcuteCommand <string>($"build resource {o} end");
});
SkinAssistanceCommands.StartRealTimerCommand.ExcuteCommand(false);
SkinAssistanceCommands.ShowInformationCommand.ExcuteCommand <string>($"Analyze End");
}
}
catch (Exception e)
{
this.Error(e);
}
});
}
private void OnShowDetailsInformationCommandsExcuted(string obj)
{
this.Info(obj);
DetailsInfo.Add(obj);
}
public static int EnterNewDetails(DetailsInfo NewDetails)
{
return(EnterNewDetailsindb(NewDetails));
}
