public static int Add(Kisayol kisayol)
{
int retInt = -1;
try
{
retInt = Execute(Crud.InsertQuery(),//en son isactive eklenecek.
new DbParam {
Name = "@KisayolAdi", Value = kisayol.KisayolAdi
},
new DbParam {
Name = "@Yol", Value = kisayol.Yol
},
new DbParam {
Name = "@Tarih", Value = kisayol.Tarih
});
// return string.Format("{0}", obj).Str2Int();
}
catch (Exception)
{
throw;
}
return(retInt);
}
public static int Update(Kisayol kisayol)
{
int retInt = -1;
try
{
retInt = Execute(Crud.UpdateQuery(),
new DbParam {
Name = "@KisayolAdi", Value = kisayol.KisayolAdi
},
new DbParam {
Name = "@Yol", Value = kisayol.Yol
},
new DbParam {
Name = "@Tarih", Value = kisayol.Tarih
},
new DbParam {
Name = "@Id", Value = kisayol.Id
});
}
catch (Exception)
{
throw;
}
return(retInt);
}
public static void Add(Kisayol _kisayol)
{
if (_kisayol == null || _kisayol == default(Kisayol))
{
return;
}
_AllList.Add(_kisayol);
return;
}
public static int Delete(Kisayol kisayol)
{
int retInt = -1;
try
{
retInt = Execute(Crud.DeleteQuery(), new DbParam {
Name = "@Id", Value = kisayol.Id
});
}
catch (Exception)
{
throw;
}
return(retInt);
}
public static void Delete(Kisayol _kisayol)
{
if (_kisayol == null || _kisayol == default(Kisayol))
{
return;
}
int indx = -1;
indx = _AllList.IndexOf(_kisayol);
if (indx == -1)
{
return;
}
_AllList.RemoveAt(indx);
}
public static void Update(Kisayol _kisayol)
{
if (_kisayol == null || _kisayol == default(Kisayol))
{
return;
}
int indx = -1;
indx = _AllList.IndexOf(_kisayol);
if (indx == -1)
{
return;
}
_AllList[indx] = _kisayol;
}
private void Delete()
{
try
{
if (lstShortCuts.Items.Count > 0 && lstShortCuts.SelectedItems.Count > 0)
{
System.Windows.Forms.DialogResult dr = MessageBox.Show(string.Format("This shortcut will be deleted, Are you sure?\nName : {0}\nPath : {1}",
lstShortCuts.SelectedItems[0].SubItems[0].Text,
lstShortCuts.SelectedItems[0].SubItems[1].Text),
"Warning", MessageBoxButtons.YesNo);
if (dr != System.Windows.Forms.DialogResult.Yes)
{
return;
}
Kisayol ks = new Kisayol(shortCutList[lstShortCuts.SelectedIndices[0]].Id);
int ix = SQLiteManager.Delete(ks);
//ks.Delete();
AppVariables.Delete(ks);
string s = string.Empty;
switch (ix)
{
case 1:
s = "Delete Process is succesfull.";
break;
default:
s = "Delete Process is not succesfull.";
break;
}
MessageBox.Show(s, "Result");
}
shortCutList = AppVariables.AllList;
Utility.List2ListView(lstShortCuts, shortCutList);
return;
}
catch (Exception ex)
{
MessageUtil.Error("An Error occured at Deleting shortcut!..");
Logger.WriteException(ex, "An error occured at deleting shortcut.", "ERR_DELETE");
}
}
private void elementsAtListToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (lstShortCuts.Items.Count == 0)
{
MessageUtil.Warn("Shortcut List must contain one item at leats.");
return;
}
List <Kisayol> list = new List <Kisayol>();
Kisayol ks = null;
for (int counter = 0; counter < lstShortCuts.Items.Count; counter++)
{
ks = null;
ks = new Kisayol()
{
KisayolAdi = lstShortCuts.Items[counter].SubItems[0].Text,
Yol = lstShortCuts.Items[counter].SubItems[1].Text
};
list.Add(ks);
}
bool result = ExportToFile(list);
if (result)
{
MessageUtil.Info("Export Operation successed.");
}
else
{
MessageUtil.Error("Export Operation failed.");
}
}
catch (Exception ex)
{
MessageUtil.Error("Export Operation Failed.");
Logger.WriteException(ex, "Selected ShortCut Export", "Export Operation Failed.");
}
}
public FrmShortCut(int shortcut_id)
{
try
{
InitializeComponent();
shortcutId = shortcut_id;
if (shortcutId != -1)
{
Kisayol ks = AppVariables.GetById(shortcut_id);
if (null != ks)
{
txtName.Text = ks.KisayolAdi;
txtPath.Text = ks.Yol;
this.Text = "Shortcut Update";
}
}
}
catch (Exception ex)
{
MessageUtil.Error("ShortCut Operation failed.");
Logger.WriteException(ex, "ShortCutFormInitiliaze", "ShortCut Operation failed.");
}
}
public static List <Kisayol> ToList(DataTable dt)
{
try
{
List <Kisayol> list = new List <Kisayol>();
Kisayol ks = null;
foreach (DataRow row in dt.Rows)
{
ks = new Kisayol()
{
Id = ObjectUtility.Str2Int(row["Id"].ToString()),
KisayolAdi = row["KisayolAdi"].ToString(),
Yol = row["Yol"].ToString(),
Tarih = ObjectUtility.Str2Date(row["Tarih"].ToString())
};
list.Add(ks);
}
return(list);
}
catch (Exception)
{
throw;
}
}
void Save(Object sender, EventArgs e)
{
try
{
if (String.IsNullOrWhiteSpace(txtName.Text))
{
MessageUtil.Warn("Invalid ShortCut Name!..");
return;
}
if (String.IsNullOrWhiteSpace(txtPath.Text))
{
MessageUtil.Warn("Invalid ShortCut Path!..");
return;
}
if (shortcutId > 0)
{
Kisayol ks = AppVariables.GetById(shortcutId);
ks.Yol = txtPath.Text;
ks.KisayolAdi = txtName.Text;
int i = SQLiteManager.Update(ks);
//ks.Update();
AppVariables.Update(ks);
if (i == 1)
{
this.DialogResult = DialogResult.OK;
return;
}
MessageUtil.Error("Update is failed.");
this.DialogResult = DialogResult.Abort;
return;
}
else
{
Kisayol ks = AppVariables.GetByName(txtName.Text);
if (ks != null)
{
MessageUtil.Warn("There is already a Shortcut with given name, please write another name!..");
return;
}
ks = new Kisayol();
ks.Yol = txtPath.Text;
ks.KisayolAdi = txtName.Text;
ks.Tarih = DateTime.Now;
int _retInt = SQLiteManager.Add(ks);
//ks.Add();
if (_retInt == 1)
{
ks.Id = SQLiteManager.GetIdentity();
AppVariables.Add(ks);
this.DialogResult = DialogResult.OK;
return;
}
this.DialogResult = DialogResult.Abort;
return;
}
}
catch (Exception ex)
{
MessageUtil.Error("ShortCut could not be saved.");
Logger.WriteException(ex, "ShortCutSave", "ShortCut could not be saved.");
}
}
