public void BindData(Contact contact)
{
this.contact = contact;
this.lblImieNazwisko.Text = contact.FirstName + " " + contact.LastName;
this.lblPhone.Text = "Tel: "+contact.Phone;
this.lblEmail.Text = "Email: "+contact.Email;
}
public FieldCall(Guid fieldcallid, Dictionary fieldcallstatus, Employee employee, Contact contact, CustomerFacility customerfacility)
{
this.fieldcallid= fieldcallid;
this.fieldcallstatus= fieldcallstatus;
this.employee= employee;
this.contact= contact;
this.customerfacility= customerfacility;
}
public FieldCall(Guid fieldcallid, Dictionary fieldcallstatus, Employee employee, Contact contact, CustomerFacility customerfacility, string fulldescription, DateTime? date, DateTime? starttime, DateTime? endtime)
{
this.fieldcallid= fieldcallid;
this.fieldcallstatus= fieldcallstatus;
this.employee= employee;
this.contact= contact;
this.customerfacility= customerfacility;
this.fulldescription= fulldescription;
this.date= date;
this.starttime= starttime;
this.endtime= endtime;
}
public static Contact InsertContact(Contact contact)
{
string sqlQuery = "INSERT INTO Contact(ContactID,FirstName,LastName,Email,Phone) " +
" VALUES(@ContactID,@FirstName,@LastName,@Email,@Phone)";
if (contact.ContactID == Guid.Empty)
contact.ContactID = Guid.NewGuid();
else
return null;
DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery);
DBHelper.AddInParameter(dbCommand, "ContactID", DbType.Guid, contact.ContactID);
DBHelper.AddInParameter(dbCommand, "FirstName", DbType.String, contact.FirstName);
DBHelper.AddInParameter(dbCommand, "LastName", DbType.String, contact.LastName);
DBHelper.AddInParameter(dbCommand, "Email", DbType.String, contact.Email);
DBHelper.AddInParameter(dbCommand, "Phone", DbType.String, contact.Phone);
return contact;
}
private void btnZapisz_Click(object sender, EventArgs e)
{
if (employee != null)
{
try
{
Contact contact = null;
if (employee.Contact == null)
contact = new Contact();
else
contact = employee.Contact;
contact.Email = txtEmail.Text;
contact.FirstName = txtImie.Text;
contact.LastName = txtNazwisko.Text;
contact.Phone = txtNrTelefonu.Text;
if (employee.Contact == null)
{
contact = ContactManager.InsertContact(contact);
employee.ContactID = contact.ContactID;
}
else
ContactManager.UpdateContact(contact);
if (employee.CreationDate == DateTime.MinValue)
employee.CreationDate = DateTime.Now;
if (employee.LastActivityDate == DateTime.MinValue)
employee.LastActivityDate = DateTime.Now;
if (employee.LastLoginDate == DateTime.MinValue)
employee.LastLoginDate = DateTime.Now;
EmployeeManager.UpdateEmployee(employee);
UIHelper.ShowInfo("Zmiany wprowadzone");
}
catch (Exception ex)
{
UIHelper.ShowError("Błąd : " + ex.Message);
}
}
}
public static void UpdateContact(Contact contact)
{
string sqlQuery = "UPDATE Contact SET FirstName=@FirstName,LastName=@LastName,Email=@Email,Phone=@Phone WHERE ContactID='" + contact.ContactID+"'";
DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery);
DBHelper.AddInParameter(dbCommand, "FirstName", DbType.String, contact.FirstName);
DBHelper.AddInParameter(dbCommand, "LastName", DbType.String, contact.LastName);
DBHelper.AddInParameter(dbCommand, "Email", DbType.String, contact.Email);
DBHelper.AddInParameter(dbCommand, "Phone", DbType.String, contact.Phone);
DBHelper.ExecuteNonQuery(dbCommand);
}
private static Contact GetContactFromReader(IDataReader dataReader)
{
Contact contact = new Contact();
contact.ContactID = DBHelper.GetGuid(dataReader, "ContactID");
contact.FirstName = DBHelper.GetString(dataReader, "FirstName");
contact.LastName = DBHelper.GetString(dataReader, "LastName");
contact.Phone = DBHelper.GetString(dataReader, "Phone");
contact.Email = DBHelper.GetString(dataReader, "Email");
return contact;
}
public static void UpdateContact(Contact contact)
{
ContactDB.UpdateContact(contact);
}
public static Contact InsertContact(Contact contact)
{
return ContactDB.InsertContact(contact);
}