private void commands_datagrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 2)
{
/*try
* {*/
DialogResult delete = new DialogResult();
delete = MessageBox.Show(resourceManager.GetString("msgIscommandDeleted", GlobalVariables.uiLanguage), resourceManager.GetString("msgWarning", GlobalVariables.uiLanguage), MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (delete == DialogResult.Yes)
{
GlobalVariables.Command_ID = Guid.Parse(commands_datagrid.Rows[e.RowIndex].Cells[0].Value.ToString());
using (VivosEntities db = new VivosEntities())
{
AssetCommand command = db.AssetCommands.First(x => x.Id == GlobalVariables.Command_ID);
db.AssetCommands.Remove(command);
db.SaveChanges();
//string key = null;
fill_datagrid();
DialogResult information = new DialogResult();
information = MessageBox.Show(resourceManager.GetString("msgCommandDeleted", GlobalVariables.uiLanguage), resourceManager.GetString("msgInformation", GlobalVariables.uiLanguage), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//}
/*catch (Exception)
* {
*
*
* }*/
}
}
public void add_scenarios(string file, Image image)
{
try
{
using (VivosEntities db = new VivosEntities())
{
string asset_imformation1 = null;
string[] asset_imformation = null;
asset_imformation1 = file;
asset_imformation = asset_imformation1.Split(new char[] { '\n' });
for (int i = 0; i < asset_imformation.Length - 1; i++)
{
asset_imformation[i] = asset_imformation[i].Remove(asset_imformation[i].Length - 1);
}
List <Asset> AssetList = (from x in db.Assets select x).ToList();
List <AssetThumbnail> AssetThumbnailList = (from x in db.AssetThumbnails select x).ToList();
List <AssetCommand> AssetCommandList = (from x in db.AssetCommands select x).ToList();
int command_count = 0;
for (int i = 0; i < asset_imformation.Length; i++)
{
var splitted = asset_imformation[i].Split(new char[] { ',' });
if (splitted[0].Contains("Komutlar") == true)
{
command_count++;
}
}
Asset new_asset = new Asset();
AssetThumbnail new_asset_thumbnail = new AssetThumbnail();
AssetCommand[] new_asset_command = new AssetCommand[command_count];
for (int i = 0; i < new_asset_command.Length; i++)
{
new_asset_command[i] = new AssetCommand();
}
Guid new_asset_id = Guid.NewGuid();
new_asset.Id = new_asset_id;
new_asset.GroupId = new Guid("00000000-0000-0000-0000-000000000000");
new_asset.EntryDate = DateTime.Now;
int command_add_number = 0;
for (int i = 0; i < asset_imformation.Length; i++)
{
var splitted = asset_imformation[i].Split(new char[] { ',' });
if (splitted[0].Contains("Ad") == true)
{
new_asset.Name = splitted[1];
new_asset.EnName = splitted[2];
new_asset.ArabicName = splitted[3];
}
else if (splitted[0].Contains("Açıklama") == true)
{
new_asset.Description = splitted[1];
new_asset.EnDescription = splitted[2];
new_asset.ArabicDescription = splitted[3];
}
else if (splitted[0].Contains("Aktif") == true)
{
if (splitted[1].Contains("True") == true)
{
new_asset.Available = true;
}
else
{
new_asset.Available = false;
}
}
else if (splitted[0].Contains("Senaryo Dizini") == true)
{
new_asset.Url = splitted[1];
}
else if (splitted[0].Contains("Senaryo Exe") == true)
{
new_asset.Exe = splitted[1];
}
else if (splitted[0].Contains("Komutlar") == true)
{
Guid new_asset_command_id = Guid.NewGuid();
new_asset_command[command_add_number].Id = new_asset_command_id;
new_asset_command[command_add_number].AssetId = new_asset_id;
new_asset_command[command_add_number].Description = splitted[1];
new_asset_command[command_add_number].EnDescription = splitted[2];
new_asset_command[command_add_number].ArabicDescription = splitted[3];
new_asset_command[command_add_number].CommandText = splitted[4];
try
{
new_asset_command[command_add_number].Step = Convert.ToByte(splitted[5]);
}
catch (Exception)
{
new_asset_command[command_add_number].Step = Convert.ToByte(0);
}
db.AssetCommands.Add(new_asset_command[command_add_number]);
command_add_number++;
}
}
try
{
Image img = image;
Bitmap bmp = new Bitmap(img);
ImageConverter converter = new ImageConverter();
new_asset_thumbnail.Thumbnail = (byte[])converter.ConvertTo(img, typeof(byte[]));
new_asset_thumbnail.AssetId = new_asset_id;
}
catch (Exception)
{
}
db.Assets.Add(new_asset);
db.AssetThumbnails.Add(new_asset_thumbnail);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
private void scenarios_datagrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 4)
{
try
{
using (VivosEntities db = new VivosEntities())
{
GlobalVariables.Asset_Start_ID = Guid.Parse(scenarios_datagrid.Rows[e.RowIndex].Cells[1].Value.ToString());
Asset exported_asset = (from x in db.Assets where x.Id == GlobalVariables.Asset_Start_ID select x).SingleOrDefault();
List <AssetCommand> exported_asset_commands = (from x in db.AssetCommands where x.AssetId == GlobalVariables.Asset_Start_ID orderby x.Step select x).ToList();
AssetThumbnail exported_asset_thumbnail = (from x in db.AssetThumbnails where x.AssetId == GlobalVariables.Asset_Start_ID select x).SingleOrDefault();
SaveFileDialog file1 = new SaveFileDialog();
file1.InitialDirectory = ".\\desktop";
file1.Filter = "Text|*.txt";
file1.FileName = exported_asset.Name;
if (file1.ShowDialog() == DialogResult.OK)
{
data = data + resourceManager.GetString("lblName", GlobalVariables.uiLanguage) + "," + exported_asset.Name + "," + exported_asset.EnName + "," + exported_asset.ArabicName + Environment.NewLine;
data = data + resourceManager.GetString("lblDescription", GlobalVariables.uiLanguage) + "," + exported_asset.Description + "," + exported_asset.EnDescription + "," + exported_asset.ArabicDescription + Environment.NewLine;
data = data + resourceManager.GetString("lblScenarioPath", GlobalVariables.uiLanguage) + "," + exported_asset.Url + Environment.NewLine;
data = data + resourceManager.GetString("lblScenarioExe", GlobalVariables.uiLanguage) + "," + exported_asset.Exe + Environment.NewLine;
data = data + resourceManager.GetString("lblAvailable", GlobalVariables.uiLanguage) + "," + exported_asset.Available + Environment.NewLine;
for (int i = 0; i < exported_asset_commands.Count; i++)
{
data = data + resourceManager.GetString("lblCommands", GlobalVariables.uiLanguage) + i + "," + exported_asset_commands[i].Description + "," + exported_asset_commands[i].EnDescription + "," + exported_asset_commands[i].ArabicDescription + "," + exported_asset_commands[i].CommandText + "," + exported_asset_commands[i].Step + Environment.NewLine;
}
/*byte[] thumbnail= exported_asset_thumbnail.Thumbnail;
* data = data + resourceManager.GetString("headerThumbnail", GlobalVariables.uiLanguage) + ",";
* for (int i = 0; i < thumbnail.Length; i++)
* {
* data = data + thumbnail[i] + "-";
* }
* data = data + Environment.NewLine;*/
/* using (MemoryStream memoryStream = new MemoryStream(exported_asset_thumbnail.Thumbnail))
* {
* Bitmap bmp = new Bitmap(memoryStream);
* data = data + resourceManager.GetString("headerThumbnail", GlobalVariables.uiLanguage) + "," + bmp + Environment.NewLine;
* }*/
data = data.Replace("\r\n,", ",");
data = data.Replace("\r\n\r\n", "\r\n");
System.IO.File.WriteAllText(file1.FileName, data);
MessageBox.Show(resourceManager.GetString("msgScenarioExported", GlobalVariables.uiLanguage));
data = null;
}
}
}
catch (Exception)
{
}
}
else if (e.ColumnIndex == 5)
{
try
{
DialogResult delete = new DialogResult();
delete = MessageBox.Show(resourceManager.GetString("msgIsScenarioDeleted", GlobalVariables.uiLanguage), resourceManager.GetString("msgWarning", GlobalVariables.uiLanguage), MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (delete == DialogResult.Yes)
{
GlobalVariables.Asset_Start_ID = Guid.Parse(scenarios_datagrid.Rows[e.RowIndex].Cells[1].Value.ToString());
using (VivosEntities db = new VivosEntities())
{
List <AssetCommand> AssetCommandList = (from x in db.AssetCommands where x.AssetId == GlobalVariables.Asset_Start_ID select x).ToList();
AssetCommand[] asset_command = new AssetCommand[AssetCommandList.Count];
for (int i = 0; i < asset_command.Length; i++)
{
asset_command[i] = AssetCommandList[i];
db.AssetCommands.Remove(asset_command[i]);
}
Asset asset = db.Assets.First(x => x.Id == GlobalVariables.Asset_Start_ID);
try
{
AssetThumbnail asset_thumbnail = db.AssetThumbnails.First(x => x.AssetId == GlobalVariables.Asset_Start_ID);
db.AssetThumbnails.Remove(asset_thumbnail);
}
catch (Exception)
{
}
db.Assets.Remove(asset);
db.SaveChanges();
GlobalVariables.NewSessions_Search_Flag = 0;
string key = null;
fill_datagrid(key);
DialogResult information = new DialogResult();
information = MessageBox.Show(resourceManager.GetString("msgScenarioDeleted", GlobalVariables.uiLanguage), resourceManager.GetString("msgInformation", GlobalVariables.uiLanguage), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception)
{
}
}
else if (e.ColumnIndex == 6)
{
try
{
GlobalVariables.Asset_Start_ID = Guid.Parse(scenarios_datagrid.Rows[e.RowIndex].Cells[1].Value.ToString());
GlobalVariables.Is_Edit = true;
New_Scenario_Page new_scenario = new New_Scenario_Page();
this.Hide();
new_scenario.Show();
}
catch (Exception)
{
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (GlobalVariables.Is_Edit == false)
{
using (VivosEntities db = new VivosEntities())
{
List <Asset> AssetList = (from x in db.Assets select x).ToList();
List <AssetThumbnail> AssetThumbnailList = (from x in db.AssetThumbnails select x).ToList();
List <AssetCommand> AssetCommandList = (from x in db.AssetCommands select x).ToList();
Asset new_asset = new Asset();
AssetThumbnail new_asset_thumbnail = new AssetThumbnail();
AssetCommand[] new_asset_command = new AssetCommand[commandsLayout.RowCount - 1];
for (int i = 0; i < new_asset_command.Length; i++)
{
new_asset_command[i] = new AssetCommand();
}
Guid new_asset_id = Guid.NewGuid();
new_asset.Id = new_asset_id;
new_asset.GroupId = new Guid("00000000-0000-0000-0000-000000000000");
new_asset.Name = txtTurkishName.Text;
new_asset.EnName = txtEnglishName.Text;
new_asset.ArabicName = txtArabicName.Text;
new_asset.Description = txtTurkishDescription.Text;
new_asset.EnDescription = txtEnglishDescription.Text;
new_asset.ArabicDescription = txtArabicDescription.Text;
if (cbAvaliable.Checked == true)
{
new_asset.Available = true;
}
else
{
new_asset.Available = false;
}
new_asset.Url = txtScenarioPath.Text;
new_asset.Exe = txtScenarioExe.Text;
new_asset.EntryDate = DateTime.Now;
try
{
if (pictureBox2.Image != null)
{
Image img = pictureBox2.Image;
Bitmap bmp = new Bitmap(img);
ImageConverter converter = new ImageConverter();
new_asset_thumbnail.Thumbnail = (byte[])converter.ConvertTo(img, typeof(byte[]));
new_asset_thumbnail.AssetId = new_asset_id;
}
else
{
new_asset_thumbnail.Thumbnail = null;
new_asset_thumbnail.AssetId = new_asset_id;
}
}
catch (Exception)
{
}
for (int i = 0; i < commandsLayout.RowCount - 2; i++)
{
Guid new_asset_command_id = Guid.NewGuid();
new_asset_command[i].Id = new_asset_command_id;
new_asset_command[i].AssetId = new_asset_id;
new_asset_command[i].CommandText = txtCommand[i].Text;
new_asset_command[i].Description = txtTurkishExplanation[i].Text;
new_asset_command[i].EnDescription = txtEnglishExplanation[i].Text;
new_asset_command[i].ArabicDescription = txtArabicExplanation[i].Text;
try
{
new_asset_command[i].Step = Convert.ToByte(txtStep[i].Text);
}
catch (Exception)
{
new_asset_command[i].Step = Convert.ToByte(0);
}
db.AssetCommands.Add(new_asset_command[i]);
}
db.Assets.Add(new_asset);
db.AssetThumbnails.Add(new_asset_thumbnail);
db.SaveChanges();
DialogResult information = new DialogResult();
information = MessageBox.Show(resourceManager.GetString("msgScenarioAdded", GlobalVariables.uiLanguage));
if (information == DialogResult.OK)
{
Admin_Page admin_page = new Admin_Page();
this.Hide();
admin_page.Show();
}
}
}
else
{
using (VivosEntities db = new VivosEntities())
{
List <Asset> AssetList = (from x in db.Assets select x).ToList();
List <AssetThumbnail> AssetThumbnailList = (from x in db.AssetThumbnails select x).ToList();
List <AssetCommand> AssetCommandList = (from x in db.AssetCommands select x).ToList();
AssetCommand[] new_asset_command = new AssetCommand[commandsLayout.RowCount - 1];
for (int i = 0; i < new_asset_command.Length; i++)
{
new_asset_command[i] = new AssetCommand();
}
Asset edit_asset = (from x in db.Assets where x.Id == GlobalVariables.Asset_Start_ID select x).SingleOrDefault();
if (edit_asset != null)
{
edit_asset.Name = txtTurkishName.Text;
edit_asset.EnName = txtEnglishName.Text;
edit_asset.ArabicName = txtArabicName.Text;
edit_asset.Description = txtTurkishDescription.Text;
edit_asset.EnDescription = txtEnglishDescription.Text;
edit_asset.ArabicDescription = txtArabicDescription.Text;
edit_asset.Url = txtScenarioPath.Text;
edit_asset.Exe = txtScenarioExe.Text;
edit_asset.ModifyDate = DateTime.Now;
if (cbAvaliable.Checked == true)
{
edit_asset.Available = true;
}
else
{
edit_asset.Available = false;
}
}
AssetThumbnail edit_asset_thumbnail = (from x in db.AssetThumbnails where x.AssetId == GlobalVariables.Asset_Start_ID select x).SingleOrDefault();
if (edit_asset_thumbnail != null)
{
if (pictureBox2.Image != null)
{
Image img = pictureBox2.Image;
Bitmap bmp = new Bitmap(img);
ImageConverter converter = new ImageConverter();
try
{
edit_asset_thumbnail.Thumbnail = (byte[])converter.ConvertTo(img, typeof(byte[]));
}
catch
{
}
}
}
for (int i = 0; i < commandsLayout.RowCount - 2; i++)
{
int flag = 0;
for (int j = 0; j < AssetCommandList.Count; j++)
{
if (AssetCommandList[j].Id == Guid.Parse(txtID[i].Text))
{
AssetCommandList[j].CommandText = txtCommand[i].Text;
AssetCommandList[j].Description = txtTurkishExplanation[i].Text;
AssetCommandList[j].EnDescription = txtEnglishExplanation[i].Text;
AssetCommandList[j].ArabicDescription = txtArabicExplanation[i].Text;
AssetCommandList[j].Step = Convert.ToByte(txtStep[i].Text);
flag = 1;
break;
}
}
if (flag == 0)
{
Guid new_asset_command_id = Guid.NewGuid();
new_asset_command[i].Id = new_asset_command_id;
new_asset_command[i].AssetId = GlobalVariables.Asset_Start_ID;
new_asset_command[i].CommandText = txtCommand[i].Text;
new_asset_command[i].Description = txtTurkishExplanation[i].Text;
new_asset_command[i].EnDescription = txtEnglishExplanation[i].Text;
new_asset_command[i].ArabicDescription = txtArabicExplanation[i].Text;
new_asset_command[i].Step = Convert.ToByte(txtStep[i].Text);
db.AssetCommands.Add(new_asset_command[i]);
}
}
db.SaveChanges();
DialogResult information = new DialogResult();
information = MessageBox.Show(resourceManager.GetString("msgScenarioEdited", GlobalVariables.uiLanguage));
if (information == DialogResult.OK)
{
Admin_Page admin_page = new Admin_Page();
this.Hide();
admin_page.Show();
}
}
}
}