private void CustomerEdit_Load(object sender, EventArgs e)
{
try
{
string strfill2 = "select [State_Code] FROM [State_Code_Master] order by [State_Code] asc";
dr = ObjCon.getData(strfill2);
if (dr.HasRows)
{
while (dr.Read())
{
cmbState.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string strfill3 = "select [CustName] FROM [Customer] order by [CustId] asc ";
dr = ObjCon.getData(strfill3);
if (dr.HasRows)
{
while (dr.Read())
{
cmbName.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
private void SupplierEdit_Load(object sender, EventArgs e)
{
try
{
string strfill2 = "select [State_Code] FROM [State_Code_Master] order by [State_Code] asc";
dr = ObjCon.getData(strfill2);
if (dr.HasRows)
{
while (dr.Read())
{
cmbState.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string strfill3 = "select [SupName] FROM [Supplier] order by [SupId] asc";
dr = ObjCon.getData(strfill3);
if (dr.HasRows)
{
while (dr.Read())
{
comboBox2.Items.Add(dr[0].ToString());
}
}
dr.Close();
}
catch { }
}
public bool Validation()
{
try
{
string strfill = "select [User_Name] FROM [User_Master] where [User_Name] = '" + txtusername.Text + "'";
dr = ObjCon.getData(strfill);
if (dr.HasRows)
{
while (dr.Read())
{
user = dr[0].ToString();
}
}
dr.Close();
string strfill1 = "select [Password] FROM [User_Master] where [Password] = '" + txtpassword.Text + "'";
dr = ObjCon.getData(strfill1);
if (dr.HasRows)
{
while (dr.Read())
{
pass = dr[0].ToString();
}
}
dr.Close();
}
catch { }
if (txtusername.Text == user)
{
MessageBox.Show("User already exists.");
this.ActiveControl = txtusername;
return(false);
}
if (txtpassword.Text == pass)
{
MessageBox.Show("Password already exixts for another user.");
this.ActiveControl = txtpassword;
return(false);
}
if (txtusername.Text == "")
{
MessageBox.Show("User Name cannot be blank.");
this.ActiveControl = txtusername;
return(false);
}
if (txtpassword.Text == "")
{
MessageBox.Show("Password cannot be blank.");
this.ActiveControl = txtpassword;
return(false);
}
if (cmbrole.Text == "")
{
MessageBox.Show("Select Role for user.");
this.ActiveControl = cmbrole;
return(false);
}
return(true);
}
private void Rack_Master_Load(object sender, EventArgs e)
{
string query = "select [Name] from [WareHouse_Master]";
dr = objCon.getData(query);
if (dr.HasRows)
{
while (dr.Read())
{
CmbWarehouse.Items.Add(dr["Name"].ToString().ToUpper());
}
}
dr.Close();
}
private void Saleable_Item_Screen_Load(object sender, EventArgs e)
{
string str9 = "select [Name] FROM [WareHouse_Master] order by [GID] asc";
dr = ObjCon.getData(str9);
if (dr.HasRows)
{
while (dr.Read())
{
cmbwarehouse.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
private void Size_Modify_Load(object sender, EventArgs e)
{
string str2 = "SELECT [size_name] FROM [Item_size_Master] order by [size_pk] asc";
dr = objCon.getData(str2);
if (dr.HasRows)
{
while (dr.Read())
{
cmbName.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
cmbName.SelectedIndex = -1;
}
private void ItemGroup_modify_Load(object sender, EventArgs e)
{
string str2 = "SELECT distinct [group_name] FROM [Item_Group_Master]";
dr = objCon.getData(str2);
if (dr.HasRows)
{
while (dr.Read())
{
comboBox1.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
comboBox1.SelectedIndex = -1;
}
public void fillArea()
{
string strfill2 = "select [State_Code] FROM [State_Code_Master] order by [State_Code] asc";
dr = ObjCon.getData(strfill2);
if (dr.HasRows)
{
while (dr.Read())
{
cmbState.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
cmbState.SelectedIndex = 26;
}
private void Set_MRP_for_Customer_Load(object sender, EventArgs e)
{
try
{
string commandT = "select distinct [CustName] FROM [Customer]";
dr = ObjCon.getData(commandT);
if (dr.HasRows)
{
while (dr.Read())
{
comboBox1.Items.Add(dr[0].ToString());
}
}
dr.Close();
}
catch { }
}
private void Size_Master_Load(object sender, EventArgs e)
{
string cmd2 = "select [size_name] from [Item_size_Master]";
dr = ObjCon.getData(cmd2);
if (dr.HasRows)
{
while (dr.Read())
{
sizename.Add(dr[0].ToString());
}
}
dr.Close();
txtSize.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtSize.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSize.AutoCompleteCustomSource = sizename;
}
private void Unit_master_Load(object sender, EventArgs e)
{
string str = "SELECT [unit_name] FROM [Unit_Master]";
dr = objCon.getData(str);
if (dr.HasRows)
{
while (dr.Read())
{
unitname1.Add(dr[0].ToString());
}
}
dr.Close();
txtunit.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtunit.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtunit.AutoCompleteCustomSource = unitname1;
}
private void Tax_Master_Load(object sender, EventArgs e)
{
string str5 = "select [Tax_Name] FROM [Tax_Master]";
dr = objCon.getData(str5);
if (dr.HasRows)
{
while (dr.Read())
{
tax.Add(dr[0].ToString());
}
}
dr.Close();
txtName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtName.AutoCompleteCustomSource = tax;
}
private void WareHouse_Master_Load(object sender, EventArgs e)
{
string str5 = "select [Name] from [WareHouse_Master] ";
dr = objCon.getData(str5);
if (dr.HasRows)
{
while (dr.Read())
{
warehuse.Add(dr[0].ToString());
}
}
dr.Close();
txtName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtName.AutoCompleteCustomSource = warehuse;
}
private void Salesman_Edit_Load(object sender, EventArgs e)
{
try
{
string strfill = "select [Name] from [Salesman_Master] where [DeleteFlag] = 'No' order by [ID] asc";
dr = ObjCon.getData(strfill);
if (dr.HasRows)
{
while (dr.Read())
{
cmbName.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch { }
}
private void Kit_Production_Process_Load(object sender, EventArgs e)
{
try
{
string str1 = "select distinct [kit_name] from [BOM_Master]";
dr = ObjCon.getData(str1);
if (dr.HasRows)
{
while (dr.Read())
{
cmbKitName.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch
{ }
try
{
string str1 = "select [Name] FROM [WareHouse_Master] order by [GID] asc";
dr = ObjCon.getData(str1);
if (dr.HasRows)
{
while (dr.Read())
{
cmbwarehouse.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch
{ }
}
private void TaxMasterEdit_Load(object sender, EventArgs e)
{
try
{
string Command = "select [Tax_Name] from Tax_Master order by [Pk] asc ";
dr = objCon.getData(Command);
if (dr.HasRows == true)
{
while (dr.Read())
{
comboBox1.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch { }
}
private void Unit_Modify_Load(object sender, EventArgs e)
{
try
{
string str1 = "SELECT [unit_name] FROM [Unit_Master] order by [unit_pk] asc";
dr = objCon.getData(str1);
if (dr.HasRows)
{
while (dr.Read())
{
comboBox1.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch { }
comboBox1.SelectedIndex = -1;
}
private void Single_Barcode_Printing_Load(object sender, EventArgs e)
{
try
{
string str7 = "select [EAC_Code] from [Kit_Master] union select [EAC_Code] from [Item]";
dr = ObjCon.getData(str7);
if (dr.HasRows)
{
while (dr.Read())
{
barcode1.Add(dr[0].ToString());
}
}
dr.Close();
txtEac_code.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtEac_code.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtEac_code.AutoCompleteCustomSource = barcode1;
}
catch { }
}
public bool Validation()
{
if (txtGroup.Text == "")
{
MessageBox.Show("Please Enter Group Name!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.ActiveControl = txtGroup;
return(false);
}
string strfill = "SELECT [group_name] FROM [Item_Group_Master] where [group_name] = '" + txtGroup.Text + "'";
dr = objCon.getData(strfill);
if (dr.HasRows)
{
MessageBox.Show("Item Group already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.ActiveControl = txtGroup;
return(false);
}
dr.Close();
return(true);
}
private void USerMaster_Edit_Load(object sender, EventArgs e)
{
try
{
string strfill = "select distinct [User_Name] FROM [User_Master] where [company] = '" + company + "'";
dr = ObjCon.getData(strfill);
if (dr.HasRows)
{
while (dr.Read())
{
username1.Add(dr[0].ToString());
}
}
dr.Close();
txtusername.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtusername.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtusername.AutoCompleteCustomSource = username1;
}
catch
{ }
}
private void button3_Click(object sender, EventArgs e)
{
login = txtLogin.Text.ToString();
password = txtPass.Text.ToString();
if (comboBox1.Text == "")
{
MessageBox.Show("Please Enter Company Name!", "Error");
comboBox1.Focus();
}
else
{
commandT = "select [Company_ID], [Company_Name] from [Company_Master] where [Company_Name] = '" + comboBox1.Text + "'";
String name = null;
dr = obj.getData(commandT);
if (dr.HasRows == true)
{
while (dr.Read())
{
company = dr["company_Id"].ToString();
name = dr["Company_Name"].ToString();
}
dr.Close();
userLogin();
}
else
{
MessageBox.Show("Invalid Company Name!");
comboBox1.Text = "";
comboBox1.Focus();
dr.Close();
}
}
txtLogin.Clear();
txtPass.Clear();
comboBox1.Clear();
}
private void Supplier_Load(object sender, EventArgs e)
{
try
{
string strfill2 = "select [State_Code] FROM [State_Code_Master] order by [State_Code] asc";
dr = ObjCon.getData(strfill2);
if (dr.HasRows)
{
while (dr.Read())
{
cmbState.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
cmbState.SelectedIndex = 26;
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
private void Purchase_Load(object sender, EventArgs e)
{
try
{
string str5 = "select [State],[Company_Name] FROM [Company_Master] where [Company_ID] = '" + company + "'";
dr = ObjCon.getData(str5);
if (dr.HasRows)
{
while (dr.Read())
{
company_state = dr[0].ToString().ToUpper();
companyname = dr[1].ToString().ToUpper();
}
}
dr.Close();
commandT = "select [SupName] from [Supplier] order by [SupId] asc";
dr = ObjCon.getData(commandT);
if (dr.HasRows == true)
{
while (dr.Read())
{
cmbSupName.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string commandT1 = "select [State_Code] from [State_Code_Master] order by [State_Code] asc";
dr = ObjCon.getData(commandT1);
if (dr.HasRows == true)
{
while (dr.Read())
{
cmbState.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
cmbState.SelectedIndex = 26;
}
catch
{ }
}
private void Purchase_ReturrnScreen_Load(object sender, EventArgs e)
{
try
{
string str5 = "select [State] FROM [Company_Master] where [Company_ID] = '" + company + "'";
dr = ObjCon.getData(str5);
if (dr.HasRows)
{
while (dr.Read())
{
company_state = dr[0].ToString().ToUpper();
}
}
dr.Close();
fillParty();
}
catch
{ }
}
private void Sale_Bill_PrintingScreen_Load(object sender, EventArgs e)
{
try
{
string str = "select [Challan_no] from [Sales] where [DeleteFlag] = 'No' order by [SalesBillPk] desc";
dr = objCon.getData(str);
if (dr.HasRows)
{
while (dr.Read())
{
comboBox1.Items.Add(dr[0].ToString());
}
}
dr.Close();
}
catch
{}
}
private void Main_Screen_Load(object sender, EventArgs e)
{
commandT = "select Company_Name from Company_Master where company_Id = '" + company + "'";
dr = objCon.getData(commandT);
if (dr.HasRows == true)
{
while (dr.Read())
{
try
{
lblcname.Text = dr[0].ToString();
}
catch (Exception ex)
{
}
}
}
dr.Close();
toolStripStatusLabel.Text = System.DateTime.Now.ToString("dd/MM/yyyy");
}
private void Bill_Of_Master_Load(object sender, EventArgs e)
{
try
{
string strfill1 = "select [Kit_Name] FROM [Kit_Master] where [Kit_Name] not in(select [kit_name] from [BOM_Master])";
dr = obj.getData(strfill1);
if (dr.HasRows)
{
while (dr.Read())
{
txtkitname.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
}
catch
{
}
}
private void Company_Edit_Load(object sender, EventArgs e)
{
try
{
string str = "select Company_Name from Company_Master";
dr = objCon.getData(str);
if (dr.HasRows == true)
{
while (dr.Read())
{
CompanyName.Add(dr[0].ToString());
}
}
else
{
}
dr.Close();
compname.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
compname.AutoCompleteSource = AutoCompleteSource.CustomSource;
compname.AutoCompleteCustomSource = CompanyName;
string strfill2 = "select [sate_name] FROM [State_Code_Master] order by [State_Code] asc";
dr = objCon.getData(strfill2);
if (dr.HasRows)
{
while (dr.Read())
{
state.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
txtState.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtState.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtState.AutoCompleteCustomSource = state;
string strfill3 = "select [code] FROM [State_Code_Master] order by [State_Code] asc";
dr = objCon.getData(strfill3);
if (dr.HasRows)
{
while (dr.Read())
{
state.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
txtState.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtState.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtState.AutoCompleteCustomSource = state;
string strfill4 = "select distinct [city_name] FROM [pincode_city_master] order by [city_name] asc";
dr = objCon.getData(strfill4);
if (dr.HasRows)
{
while (dr.Read())
{
juri.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
juris.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
juris.AutoCompleteSource = AutoCompleteSource.CustomSource;
juris.AutoCompleteCustomSource = juri;
city.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
city.AutoCompleteSource = AutoCompleteSource.CustomSource;
city.AutoCompleteCustomSource = juri;
compname.Focus();
txtState.Text = "";
rbtnAssesse.Checked = true;
rbtnnonassesse.Checked = false;
}
catch { }
}
private void Sales_Return_Load(object sender, EventArgs e)
{
try
{
string str1 = "select distinct [CustName] FROM [Sales]";
dr = ObjCon.getData(str1);
if (dr.HasRows)
{
while (dr.Read())
{
cmbCustName.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string str5 = "select [State],[Company_Name] FROM [Company_Master] where [Company_ID] = '" + company + "'";
dr = ObjCon.getData(str5);
if (dr.HasRows)
{
while (dr.Read())
{
company_state = dr[0].ToString().ToUpper();
companyname = dr[1].ToString().ToUpper();
}
}
dr.Close();
string commandT1 = "select [State_Code] from [State_Code_Master] order by [State_Code] asc";
dr = ObjCon.getData(commandT1);
if (dr.HasRows == true)
{
while (dr.Read())
{
cmbstate.Items.Add(dr[0].ToString().ToUpper().ToUpper());
}
}
dr.Close();
cmbstate.SelectedIndex = 26;
string str9 = "select [Name] FROM [WareHouse_Master] order by [GID] asc";
dr = ObjCon.getData(str9);
if (dr.HasRows)
{
while (dr.Read())
{
cmbwarehouse.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string str10 = "select [Name] from [Salesman_Master]";
dr = ObjCon.getData(str10);
if (dr.HasRows)
{
while (dr.Read())
{
cmbMarketPlace.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
this.ActiveControl = cmbCustName;
}
catch { }
}
private void Item_Master_Load(object sender, EventArgs e)
{
try
{
string str1 = "SELECT [unit_name] FROM [Unit_Master] order by [unit_pk] asc";
dr = ObjCon.getData(str1);
if (dr.HasRows)
{
while (dr.Read())
{
cmbUnit.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string str2 = "SELECT [group_name] FROM [Item_Group_Master] order by [grp_pk] asc";
dr = ObjCon.getData(str2);
if (dr.HasRows)
{
while (dr.Read())
{
cmbGroup.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string str3 = "SELECT [Tax_Name] FROM [Tax_Master] order by [Pk] asc";
dr = ObjCon.getData(str3);
if (dr.HasRows)
{
while (dr.Read())
{
cmbTax.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string str4 = "SELECT [size_name] FROM [Item_size_Master] order by [size_pk] asc";
dr = ObjCon.getData(str4);
if (dr.HasRows)
{
while (dr.Read())
{
cmbsize.Items.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
string str111 = "select [EAC_Code] FROM [Item]";
dr = ObjCon.getData(str111);
if (dr.HasRows)
{
while (dr.Read())
{
eaccode1.Add(dr[0].ToString().ToUpper());
}
}
dr.Close();
txtbarcodeno.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtbarcodeno.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtbarcodeno.AutoCompleteCustomSource = eaccode1;
this.ActiveControl = txtbarcodeno;
}
catch { }
}