public override void add()
{
try
{
Customer Customer = new Customer();
// Setting the default company
Customer.CompanyID = getDefaultCompany().Id;
CustomerForm CustomerViewer = new CustomerForm();
CustomerViewer.mainEntity = Customer;
CustomerViewer.controller = this;
if (CustomerViewer.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
db.Customer.Add(Customer);
db.SaveChanges();
}
}
catch (System.InvalidOperationException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string userName = textBoxName.Text;
string password = Cryptology.MD5Sifrele(textBoxPassword.Text);
connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM TblLoginCustomer", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (userName == reader["UserName"].ToString() && password == reader["Password"].ToString())
{
isThere = true;
break;
}
else
{
isThere = false;
}
}
connection.Close();
if (isThere)
{
this.Hide();
CustomerForm CF = new CustomerForm();
CF.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Hatalı kullanıcı adı veya şifre!");
}
}
private void lnlkLabelCustomerName_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
try
{
CustomerForm form = new CustomerForm();
form.IsFromPurchaseForm = true;
form.ShowDialog();
if (form.PurchaseForCustomerId > 0)
{
using (InventoryDataContext context = new InventoryDataContext())
{
CustomerId = form.PurchaseForCustomerId;
CustomerManager manager = new CustomerManager();
GetCustomerByIdResult obj = new GetCustomerByIdResult();
obj = manager.GetCustomerById(context, CustomerId).Single();
txtBoxMetroCustomerName.Text = obj.LastName + ", " + obj.FirstName;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string userName = textBoxName.Text;
string password = Cryptology.MD5Sifrele(textBoxPassword.Text);
connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM TblLoginCustomer WHERE UserName='******'", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (userName == reader["UserName"].ToString() && password == reader["Password"].ToString() && reader["Counter"].ToString() != "3")
{
isThere = true;
label1.Text = reader["id"].ToString();
break;
}
else
{
isThere = false;
}
}
connection.Close();
CustomerForm cf = new CustomerForm();
if (isThere)
{
cf.etc = label1.Text;
this.Hide();
cf.ShowDialog();
this.Close();
}
else
{
connection.Open();
SqlCommand komut = new SqlCommand("SELECT * FROM TblLoginCustomer WHERE UserName='******'", connection);
SqlDataReader read = komut.ExecuteReader();
if (read.Read())
{
if (read["Counter"].ToString() == "3")
{
MessageBox.Show("Hesabınız bloke olmuştur. Lütfen sistem yöneticimizle [email protected] adresi üzerinden iletişime geçiniz..");
}
else
{
connection.Close();
connection.Open();
SqlCommand commandd = new SqlCommand("UPDATE TblLoginCustomer SET Counter = Counter +1 WHERE UserName='******'", connection);
commandd.ExecuteNonQuery();
MessageBox.Show("Hatalı kullanıcı adı veya şifre!");
}
}
connection.Close();
}
}
private void customer_Click(object sender, EventArgs e)
{
CustomerForm customerForm = new CustomerForm();
customerForm.ShowDialog();
}
/// <summary>
/// Customer
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CustomerMenuItem_Click(object sender, EventArgs e)
{
CustomerForm form = new CustomerForm();
form.ShowDialog();
}
private void customer_button_Click(object sender, System.EventArgs e)
{
Form selectedForm = new CustomerForm();
selectedForm.ShowDialog(this);
}
