public it_log GetById(int id)
{
using (MySqlConnection conn = new MySqlConnection(connStr))
{
conn.Open();
string query = "SELECT * FROM it_log WHERE it_log_id = @id";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
it_log log = new it_log();
log.id = Convert.ToInt32(dt.Rows[0]["it_log_id"]);
log.Name = dt.Rows[0]["name"].ToString();
log.Office = dt.Rows[0]["office"].ToString();
log.Date = Convert.ToDateTime(dt.Rows[0]["date"]);
log.Time = TimeSpan.Parse(dt.Rows[0]["time"].ToString());
log.Service_Request = dt.Rows[0]["service_request"].ToString();
log.IT_Personnel_id = Convert.ToInt32(dt.Rows[0]["it_personnel_id"]);
return(log);
}
}
public void Update(it_log obj)
{
using (ittransactionlogEntities db = new ittransactionlogEntities())
{
db.it_log.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public it_log Insert(it_log obj)
{
using (ittransactionlogEntities db = new ittransactionlogEntities())
{
db.it_log.Add(obj);
db.SaveChanges();
return(obj);
}
}
public FormAddEdit(int?id)
{
InitializeComponent();
if (id == null)
{
IsNew = true;
}
else
{
this.updateObj = ITLogServices.GetById((int)id);
IsNew = false;
textBoxName.Text = updateObj.name;
textBoxOffice.Text = updateObj.office;
dateTimePickerDate.Text = Convert.ToDateTime(updateObj.date).ToString();
dateTimePickerTime.Text = updateObj.time.ToString();
textBoxServiceRequest.Text = updateObj.service_request;
comboBoxITPersonnel.SelectedIndex = (int)updateObj.it_personnel_id;
}
}
public static void Update(it_log obj)
{
repository.Update(obj);
}
public static it_log Insert(it_log obj)
{
return(repository.Insert(obj));
}
private void FormAddEdit_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (string.IsNullOrEmpty(textBoxName.Text))
{
MessageBox.Show("Please Enter Name!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxName.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(textBoxOffice.Text))
{
MessageBox.Show("Please Enter Office Name!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxOffice.Focus();
e.Cancel = true;
return;
}
if ((string.IsNullOrEmpty(dateTimePickerDate.Text)))
{
MessageBox.Show("Please Enter the Date!");
dateTimePickerDate.Focus();
e.Cancel = true;
return;
}
if ((string.IsNullOrEmpty(dateTimePickerTime.Text)))
{
MessageBox.Show("Please Enter the Date!");
dateTimePickerTime.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(textBoxServiceRequest.Text))
{
MessageBox.Show("Please Enter the Service Requested!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxServiceRequest.Focus();
e.Cancel = true;
return;
}
if (IsNew)
{
var log = new it_log()
{
name = textBoxName.Text.ToString(),
office = textBoxOffice.Text.ToString(),
date = Convert.ToDateTime(dateTimePickerDate.Text),
time = TimeSpan.Parse(dateTimePickerTime.Text),
service_request = textBoxServiceRequest.Text.ToString(),
it_personnel_id = comboBoxITPersonnel.SelectedIndex
};
ITLogServices.Insert(log);
MessageBox.Show("Added!");
}
else
{
updateObj.name = textBoxName.Text.ToString();
updateObj.office = textBoxOffice.Text.ToString();
updateObj.date = Convert.ToDateTime(dateTimePickerDate.Text);
updateObj.time = TimeSpan.Parse(dateTimePickerTime.Text);
updateObj.service_request = textBoxServiceRequest.Text.ToString();
updateObj.it_personnel_id = comboBoxITPersonnel.SelectedIndex;
ITLogServices.Update(updateObj);
MessageBox.Show("Saved!");
}
}
}
