public SalesLead readFromDatabase(int salesLeadsID)
{
DBLink.openConnection();
string sqlUser = "******" + salesLeadsID + ";";
MySqlDataReader salesleadData = DBLink.executeReadQuarry(sqlUser);
if (salesleadData.Read())
{
int customerID = salesleadData.GetInt32(1);
int productID = salesleadData.GetInt32(2);
SalesLead existingSalesLead = new SalesLead(null, null, null);
existingSalesLead.SalesID = salesleadData.GetInt32(0);
existingSalesLead.getSalesActivity(ActivityType.SalesIssue).ActivityDate = Rules.dbNullDateField(salesleadData, 3);
existingSalesLead.RevenueType = salesleadData.GetString(4);
existingSalesLead.MonthlyRevenue = salesleadData.GetDecimal(5);
existingSalesLead.HadTest = Rules.yesnoToBoolean(salesleadData.GetString(6));
existingSalesLead.ProjectRevenue = salesleadData.GetDecimal(7);
existingSalesLead.ProjectPaid = salesleadData.GetDecimal(8);
existingSalesLead.getSalesActivity(ActivityType.CustomerConfirm).ActivityDate = Rules.dbNullDateField(salesleadData, 9);
existingSalesLead.getSalesActivity(ActivityType.AgreementSign).ActivityDate = Rules.dbNullDateField(salesleadData, 11);
existingSalesLead.getSalesActivity(ActivityType.DSP).ActivityDate = Rules.dbNullDateField(salesleadData, 12);
existingSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDetails = salesleadData.GetString(13);
existingSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDate = Rules.dbNullDateField(salesleadData, 14);
existingSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDetails = salesleadData.GetString(15);
existingSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDate = Rules.dbNullDateField(salesleadData, 16);
existingSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDate = Rules.dbNullDateField(salesleadData, 17);
existingSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDetails = salesleadData.GetString(18);
existingSalesLead.CustomerFeedBack = salesleadData.GetString(19);
existingSalesLead.Discount = salesleadData.GetDecimal(20);
existingSalesLead.Notes = salesleadData.GetString(21);
int purchaseOrderFileSize = salesleadData.GetInt32(22);
byte[] binaryData = new byte[purchaseOrderFileSize];
if (purchaseOrderFileSize > 0)
{
salesleadData.GetBytes(10, 0, binaryData, 0, purchaseOrderFileSize);
}
existingSalesLead.PurchaseOrderData = binaryData;
Administration.Customer.Customer customer = Administration.Customer.CustomerDA.getInstance().readFromDatabase(customerID);
Administration.Product.Product product = Administration.Product.ProductDA.getInstance().readFromDatabase(productID);
Administration.User.User accManager = Administration.User.UserDA.getInstance().readFromDatabase(customer.AccountManager);
existingSalesLead.Customer = customer;
existingSalesLead.Product = product;
existingSalesLead.AccountManager = accManager;
return(existingSalesLead);
}
return(null);
}
private void btnLogin_Click(object sender, EventArgs e)
{
#if DevoloperMode
MessageBox.Show("Elaz..(y)");
General.frmMain mainForm = new General.frmMain();
Administration.User.User devUser = new Administration.User.User();
devUser.Permissions = 3;
devUser.Name = "Developer";
devUser.UserName = "******";
General.frmMain.AppUser = devUser;
mainForm.Show();
this.Hide();
#else
UserLogin user = new UserLogin(txtUsername.Text.Trim(), txtPassword.Text.Trim());
if (user.Login())
{
MessageBox.Show("Login Success.", "Welcome", MessageBoxButtons.OK, MessageBoxIcon.Information);
General.frmMain mainForm = new General.frmMain();
General.frmMain.AppUser = Administration.User.UserDA.getInstance().readFromDatabase(txtUsername.Text.Trim());
mainForm.Show();
this.Hide();
}
else
{
if (user.hasLoginError())
{
if (MessageBox.Show(this, user.ErrorDetails(), "Login Failed", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.Yes)
{
user.resetPassword();
}
}
else
{
MessageBox.Show(this, user.ErrorDetails(), "Login Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
#endif
}
