private void dgvTempRecs_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
int Id = Convert.ToInt32(dgvTempRecs.SelectedRows[0].Cells["tmp_Id"].Value.ToString());
TempRecords thisTmpRec = tempRecList.Where(i => i.Id == Id).First();
if (thisTmpRec.Url.Trim() != "")
{
System.Diagnostics.Process.Start(thisTmpRec.Url);
}
else
{
MessageBox.Show("Δεν υπάρχει καταχωρημένο Url για τη συγκεκριμένη εγγραφή!");
}
}
}
private void tsmiViewTM_Click(object sender, EventArgs e)
{
//Select
if (dgvAlerts.SelectedRows.Count > 0)
{
int dgvIndex = dgvAlerts.SelectedRows[0].Index;
int Id = Convert.ToInt32(dgvAlerts.SelectedRows[0].Cells["tmp_Id"].Value.ToString());
TempRecords thisTmpRec = new TempRecords(Id);
QuickInsert frmViewTmpRec = new QuickInsert(thisTmpRec);
frmViewTmpRec.MakeAllControlsReadOnly(frmViewTmpRec);
frmViewTmpRec.GetFromGridOnlyChecked();
frmViewTmpRec.btnSave.Enabled = false;
frmViewTmpRec.ShowDialog();
}
}
private void tsmiUpdate_Click(object sender, EventArgs e)
{
// Update
if (dgvTempRecs.SelectedRows.Count > 0)
{
int dgvIndex = dgvTempRecs.SelectedRows[0].Index;
int Id = Convert.ToInt32(dgvTempRecs.SelectedRows[0].Cells["tmp_Id"].Value.ToString());
TempRecords thisTmpRec = tempRecList.Where(i => i.Id == Id).First();
QuickInsert frmUpdateTmpRec = new QuickInsert(thisTmpRec);
frmUpdateTmpRec.ShowDialog();
if (frmUpdateTmpRec.success)
{
//refresh
tempRecList[tempRecList.FindIndex(w => w.Id == Id)] = frmUpdateTmpRec.NewRecord;
FillDataGridView(dgvTempRecs, frmUpdateTmpRec.NewRecord, dgvIndex);
}
}
}
public List <TempRecords> SelectTempRecs()
{
List <TempRecords> ret = new List <TempRecords>();
SqlConnection sqlConn = new SqlConnection(SqlDBInfo.connectionString);
string SelectSt = "SELECT [Id], [TMNo], [TMName], [DepositDt], [RenewalDt], " +
"[NationalPowerId], [TMGrNo], [CompanyId], [ResponsibleLawyerId], [FileContents], " +
"[FileName], [Description], [Fees], [DecisionNo], [PublicationDate], [FinalizationDate], [Url] " +
"FROM [dbo].[TempRecords] " +
"WHERE NationalPowerId = 1 " +
"ORDER BY Id "; //??
SqlCommand cmd = new SqlCommand(SelectSt, sqlConn);
try
{
sqlConn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DateTime dtRenewal = new DateTime();
bool HasRenewalDt = false;
if (reader["RenewalDt"] != DBNull.Value)
{
HasRenewalDt = true;
dtRenewal = Convert.ToDateTime(reader["RenewalDt"].ToString());
}
TempRecords tmpRec = new TempRecords();
tmpRec.Id = Convert.ToInt32(reader["Id"].ToString());
tmpRec.TMNo = reader["TMNo"].ToString();
tmpRec.TMName = reader["TMName"].ToString();
tmpRec.DepositDt = Convert.ToDateTime(reader["DepositDt"].ToString());
tmpRec.HasRenewal = HasRenewalDt;
if (HasRenewalDt)
{
tmpRec.RenewalDt = dtRenewal;
}
tmpRec.NationalPowerId = Convert.ToInt32(reader["NationalPowerId"].ToString());
tmpRec.TMGrNo = reader["TMGrNo"].ToString();
tmpRec.CompanyId = Convert.ToInt32(reader["CompanyId"].ToString());
tmpRec.ResponsibleLawyerId = Convert.ToInt32(reader["ResponsibleLawyerId"].ToString());
if (reader["FileContents"] != DBNull.Value)
{
tmpRec.FileContents = (byte[])reader["FileContents"];
}
tmpRec.FileName = reader["FileName"].ToString();
tmpRec.Description = reader["Description"].ToString();
tmpRec.Fees = reader["Fees"].ToString();
tmpRec.DecisionNo = reader["DecisionNo"].ToString();
tmpRec.PublicationDate = Convert.ToDateTime(reader["PublicationDate"].ToString());
tmpRec.FinalizationDate = Convert.ToDateTime(reader["FinalizationDate"].ToString());
tmpRec.Url = reader["Url"].ToString();
tmpRec.TMTypeIds = Type.getTM_TypesList(Convert.ToInt32(reader["Id"].ToString()));
tmpRec.ClassIds = Class.getTM_ClassList(Convert.ToInt32(reader["Id"].ToString()));
tmpRec.CountryIds = Country.getTM_CountriesList(Convert.ToInt32(reader["Id"].ToString()));
ret.Add(tmpRec);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show("The following error occurred: " + ex.Message);
}
sqlConn.Close();
return(ret);
}
public void FillDataGridView(DataGridView dgv, TempRecords tmpRec, int dgvIndex)
{
List <dgvDictionary> dgvDictList = new List <dgvDictionary>();
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.Id, dgvColumnHeader = "tmp_Id"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.TMNo, dgvColumnHeader = "tmp_No"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.TMName, dgvColumnHeader = "tmp_Name"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.DepositDt.ToString("dd.MM.yyyy HH:mm"), dgvColumnHeader = "tmp_DepositDt"
});
if (tmpRec.HasRenewal)
{
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.RenewalDt.ToString("dd.MM.yyyy HH:mm"), dgvColumnHeader = "tmp_RenewalDt"
});
}
else
{
dgvDictList.Add(new dgvDictionary()
{
dbfield = "", dgvColumnHeader = "tmp_RenewalDt"
});
}
dgvDictList.Add(new dgvDictionary()
{
dbfield = NationalPower.getNationalPowerName(tmpRec.NationalPowerId), dgvColumnHeader = "tmp_NatPower"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.TMGrNo, dgvColumnHeader = "tmp_GrNo"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Company.getCompanyName(tmpRec.CompanyId), dgvColumnHeader = "tmp_Com"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Responsible.getResponsibleName(tmpRec.ResponsibleLawyerId), dgvColumnHeader = "tmp_RespLawyer"
});
dgv.Columns["tmp_Pic"].DefaultCellStyle.NullValue = null;
string fn = System.IO.Path.GetExtension(tmpRec.FileName);
if ((tmpRec.FileContents != null) && (fn == ".gif" || fn == ".jpg" || fn == ".jpeg" || fn == ".bmp" || fn == ".wmf" || fn == ".png"))
{
dgvDictList.Add(new dgvDictionary()
{
dbfield = tmpRec.FileContents, dgvColumnHeader = "tmp_Pic"
}); //???
}
object[] obj = new object[dgv.Columns.Count];
for (int i = 0; i < dgv.Columns.Count; i++)
{
if (dgvDictList.Exists(z => z.dgvColumnHeader == dgv.Columns[i].Name))
{
obj[i] = dgvDictList.Where(z => z.dgvColumnHeader == dgv.Columns[i].Name).First().dbfield;
}
dgv.Rows[dgvIndex].Cells[i].Value = obj[i];
}
dgv.Rows[dgvIndex].Selected = true;
}