private void btnAdd_Click(object sender, EventArgs e)
{
string error = ValidateFields();
if (string.IsNullOrEmpty(error))
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
try
{
var result = context.INS_Company(txtCompanyName.Text,
txtDealerName.Text,
txtAddress.Text,
Convert.ToInt64(txtMobile.Text)
);
FillCompanyList();
txtCompanyName.Clear();
txtAddress.Clear();
txtDealerName.Clear();
txtMobile.Clear();
MessageBox.Show(Constants.COMPANY_ADD_SUCCESS);
}
catch (Exception ex)
{
MessageBox.Show(Constants.COMPANY_FAILURE);
}
}
}
else
{
MessageBox.Show(error);
}
}
private void btnAddStock_Click(object sender, EventArgs e)
{
string error = ValidateFields();
if (string.IsNullOrEmpty(error))
{
try
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var result = context.INS_StockIn(txtSItem.Text, Constants.ADD, Convert.ToInt32(txtSQuantity.Text),
Convert.ToInt32(txtSPrice.Text), Convert.ToInt32(cmbCompanies.SelectedValue.ToString()), Convert.ToDateTime(dtEdate.Value.ToShortDateString()), Convert.ToDateTime(DateTime.Now), LoginUC.employeeName);
MessageBox.Show(Constants.STOCK_ADD);
ClearAddStockFields();
BindStocks();
txtIQuantity.Text = GetQuantity(Convert.ToInt32(((System.Collections.Generic.KeyValuePair <string, string>)cboIName.SelectedItem).Key)).ToString();
txtItemQuantity.Text = GetQuantity(Convert.ToInt32(((System.Collections.Generic.KeyValuePair <string, string>)cboItemName.SelectedItem).Key)).ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(Constants.STOCK_ADD_FAIL);
}
}
else
{
MessageBox.Show(error);
}
}
private void FillCompanyList()
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var companyList = context.GET_Companies().ToList();
if (companyList.Count > 0)
{
dgCompanyList.DataSource = companyList;
dgCompanyList.Columns[0].Visible = false;
dgCompanyList.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
Dictionary <string, string> item = new Dictionary <string, string>();
foreach (var c in companyList)
{
item.Add(c.Id.ToString(), c.CompanyName);
}
cmbCompanies.DataSource = new BindingSource(item, null);
cmbCompanies.DisplayMember = "Value";
cmbCompanies.ValueMember = "Key";
}
else
{
cmbCompanies.DataSource = null;
dgCompanyList.DataSource = null;
}
}
}
private void btnUpdateStock_Click(object sender, EventArgs e)
{
if (cboItemName.Items.Count > 0)
{
string error = ValidateUpdateFields();
if (string.IsNullOrEmpty(error))
{
MessageBox.Show(Constants.STOCK_UPDATE_WARNING);
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var text = ((System.Collections.Generic.KeyValuePair <string, string>)cboIName.SelectedItem).Value;
var result = context.UPD_StockIn(Convert.ToInt32(cboIName.SelectedValue.ToString()), text, Convert.ToInt32(txtItQuantity.Text), Convert.ToInt32(txtItPrice.Text)
, Constants.UPDATE, Convert.ToDateTime(DateTime.Now), LoginUC.employeeName);
}
MessageBox.Show(Constants.STOCK_UPDATE_SUCCESS);
BindStocks();
txtItQuantity.Clear();
txtItPrice.Clear();
}
else
{
MessageBox.Show(error);
}
}
else
{
MessageBox.Show(Constants.NO_STOCK);
}
}
private void BindStocks()
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
stockDetails = context.GET_StockDetails().ToList();
if (stockDetails.Count > 0)
{
Dictionary <string, string> item = new Dictionary <string, string>();
foreach (var s in stockDetails)
{
item.Add(s.S_Id.ToString(), s.S_Name);
}
cboIName.DataSource = new BindingSource(item, null);
cboIName.DisplayMember = "Value";
cboIName.ValueMember = "Key";
cboItemName.DataSource = new BindingSource(item, null);
cboItemName.DisplayMember = "Value";
cboItemName.ValueMember = "Key";
this.cboIName.SelectedIndexChanged += new System.EventHandler(cboIName_SelectedIndexChanged);
this.cboItemName.SelectedIndexChanged += new System.EventHandler(cboItemName_SelectedIndexChanged);
dgViewStock.DataSource = stockDetails;
dgViewStock.Columns[0].Visible = false;
}
else
{
cboIName.DataSource = null;
cboItemName.DataSource = null;
dgViewStock.DataSource = null;
}
}
}
private void GetAllEmployees()
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var employeeList = context.GET_Employees().ToList();
dgViewEmp.DataSource = employeeList;
dgViewEmp.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
}
private void BindStocks()
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
stockdetails = context.GET_StockDetails().ToList();
Dictionary <string, string> item = new Dictionary <string, string>();
foreach (var s in stockdetails)
{
item.Add(s.S_Id.ToString(), s.S_Name);
}
cmbItemName.DataSource = new BindingSource(item, null);
cmbItemName.DisplayMember = "Value";
cmbItemName.ValueMember = "Key";
this.cmbItemName.SelectedIndexChanged += new System.EventHandler(cmbItemName_SelectedIndexChanged);
}
}
public void GetAllEmployeeLookUpData()
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var employyeLookUp = context.GET_Employee_LookUp().ToList();
Dictionary <string, string> item = new Dictionary <string, string>();
foreach (var c in employyeLookUp)
{
item.Add(c.Id.ToString(), c.Type);
}
cmbDesignation.DataSource = new BindingSource(item, null);
cmbDesignation.DisplayMember = "Value";
cmbDesignation.ValueMember = "Key";
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
string error = ValidateFields();
if (string.IsNullOrEmpty(error))
{
try
{
int employeeId = 0;
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
System.Data.Entity.Core.Objects.ObjectParameter objParam = new System.Data.Entity.Core.Objects.ObjectParameter("eid", typeof(Int32));
var eid = context.INS_Employee(txtFName.Text, txtLName.Text, txtAddress.Text, Convert.ToInt64(txtMobile.Text), Convert.ToInt32(cmbDesignation.SelectedValue)
, Convert.ToInt32(txtSalary.Text), objParam);
employeeId = Convert.ToInt32(objParam.Value);
}
if (employeeId > 0)
{
using (MedicalDBEntityModelConnection loginContext = new MedicalDBEntityModelConnection())
{
string loginId = txtFName.Text + CommonHelper.GenerateRandomNo();
string password = Constants.PASS + CommonHelper.GenerateRandomNo();
var aaa = loginContext.INS_Login(loginId, password, employeeId);
MessageBox.Show(Constants.REGISTRATION_SUCCESS + Environment.NewLine +
Constants.LOGIN_ID + loginId + Environment.NewLine +
Constants.PASSWORD + password + Environment.NewLine);
}
GetAllEmployees();
}
else
{
MessageBox.Show(Constants.REGISTRATION_FAILED);
}
ClearAllFields();
}
catch (Exception ex)
{
ClearAllFields();
MessageBox.Show(Constants.REGISTRATION_FAILED);
}
}
else
{
MessageBox.Show(error);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtUName.Text) || String.IsNullOrEmpty(txtPass.Text))
{
MessageBox.Show(Constants.INVALID_LOGIN);
}
else
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var loginResult = context.GET_ValidateLogin(txtUName.Text, txtPass.Text).FirstOrDefault();
if (loginResult == null)
{
MessageBox.Show(Constants.INVALID_LOGIN);
}
else
{
employeeType = loginResult.Designation_Id;
employeeName = loginResult.FirstName;
MasterFrom masterForm = (MasterFrom)this.Parent.Parent;
Label lblUserName = masterForm.Controls["lblUserName"] as Label;
lblUserName.Text = Constants.WELCOME + " " + employeeName;
if (parentFormName == null)
{
return;
}
else
{
parentFormName = masterForm;
}
Panel panelMaster = masterForm.Controls["pnlMaster"] as Panel;
panelMaster.Controls.Remove(LoginUC.Instance);
HomePage.Instance = null;
panelMaster.Controls.Add(HomePage.Instance);
HomePage.Instance.BringToFront();
BuildMenu(masterForm, employeeType);
}
}
}
}
private void btnDelStock_Click(object sender, EventArgs e)
{
if (cboItemName.Items.Count > 0)
{
MessageBox.Show(Constants.STOCK_DEL_WARNING);
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var text = ((System.Collections.Generic.KeyValuePair <string, string>)cboItemName.SelectedItem).Value;
var result = context.DEL_Stock(text, Constants.DELETE, Convert.ToDateTime(DateTime.Now), LoginUC.employeeName);
}
MessageBox.Show(Constants.STOCK_DEL_SUCCESS);
BindStocks();
}
else
{
cboIName.DataSource = null;
cboItemName.DataSource = null;
dgViewStock.DataSource = null;
MessageBox.Show(Constants.NO_STOCK);
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (cmbCompanies.Items.Count > 0)
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
try
{
var result = context.DEL_Company(Convert.ToInt32(cmbCompanies.SelectedValue.ToString()));
FillCompanyList();
MessageBox.Show(Constants.COMPANY_DEL_SUCCESS);
}
catch (Exception ex)
{
MessageBox.Show(Constants.COMPANY_FAILURE);
}
}
}
else
{
MessageBox.Show(Constants.COMPANY_NONE);
}
}
private void FillCompanyList()
{
using (MedicalDBEntityModelConnection context = new MedicalDBEntityModelConnection())
{
var companyList = context.GET_Companies().ToList();
if (companyList.Count > 0)
{
Dictionary <string, string> item = new Dictionary <string, string>();
foreach (var c in companyList)
{
item.Add(c.Id.ToString(), c.CompanyName);
}
cmbCompanies.DataSource = new BindingSource(item, null);
cmbCompanies.DisplayMember = "Value";
cmbCompanies.ValueMember = "Key";
}
else
{
dgViewStock.DataSource = null;
cmbCompanies.DataSource = null;
MessageBox.Show(Constants.COMPANY_NONE);
}
}
}
