private void import_Click(object sender, EventArgs e)
{
queryBLL q = new queryBLL();
companysBLL b = new companysBLL();
companysDAL dc = new companysDAL();
int i = dataGridView1.Rows.Count;
i--;
string add = "";
string name;
string mobile;
string sub;
string email;
string subend = "12/12/2009";
string cat = "na";
for (int j = 1; j < i; j++)
{
name = dataGridView1.Rows[j].Cells[11].Value.ToString();
bool sucess = dc.chkcompanybyname(name);
if (sucess == false)
{
add = dataGridView1.Rows[j].Cells[6].Value.ToString();
add = add + dataGridView1.Rows[j].Cells[7].Value.ToString();
add = add + dataGridView1.Rows[j].Cells[3].Value.ToString();
add = add + dataGridView1.Rows[j].Cells[8].Value.ToString();
b.c_location = add;
name = dataGridView1.Rows[j].Cells[11].Value.ToString();
mobile = dataGridView1.Rows[j].Cells[1].Value.ToString();
sub = dataGridView1.Rows[j].Cells[2].Value.ToString();
email = dataGridView1.Rows[j].Cells[0].Value.ToString();
sub = dataGridView1.Rows[j].Cells[2].Value.ToString();
b.c_name = name;
b.c_mobile = mobile;
b.c_email = email;
b.subend_date = sub;
b.substart_date = subend;
b.c_category = cat;
bool suck = dc.Insert(b);
add = " ";
if (suck != true)
{
MessageBox.Show("nhi add hui");
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
companysBLL tc = new companysBLL();
custBLL c = new custBLL();
string keyword = textcompany.Text;
bool sucess = pDAL.chkcompanybyname(keyword);
if (sucess == true)
{
MessageBox.Show("company found");
tc = pDAL.GetcompanysForTransaction(keyword);
int id = tc.id;
c.cid = id;
c.nquery = 0;
}
else
{
addcompanys ca = new addcompanys();
ca.Show();
}
c.name = txtu_Name.Text;
c.mobile = textmobile.Text;
c.type = texttyp.Text;
c.email = textemail.Text;
tc = pDAL.Search(textcompany.Text);
sucess = tDAL.Insert(c);
if (sucess == true)
{
MessageBox.Show("costumer added sucessfully");
clear();
}
else
{
MessageBox.Show("costumer can not be added");
}
}
private void button3_Click(object sender, EventArgs e)
{
string keyword = txtu_Name.Text;
queryBLL q = new queryBLL();
bool qsucess = tDAL.chkcustumer(keyword);
custBLL dc = tDAL.searchcustumer(keyword);
if (qsucess == true)
{
keyword = txtcompany.Text;
companysBLL c = pDAL.Search(keyword);
q.ques = textqry.Text;
q.soln = textsoln.Text;
q.cu_id = dc.id;
q.c_id = dc.cid;
q.u_name = dc.name;
emailname = q.u_name;
q.u_mobile = dc.mobile;
dc.nquery = dc.nquery++;
bool incquery = tDAL.Increasenoofquery(dc); if (incquery == true)
{
MessageBox.Show("user and query updated");
}
else
{
MessageBox.Show("user and query not updated");
}
q.status = 1;
bool success = dcDAL.Insert(q);
q = dcDAL.Getqueryforsearch(q);
qid = q.q_id;
qid1 = q.q_id;
}
if (qsucess == false)
{
keyword = txtcompany.Text;
bool csucess = pDAL.chkcompanybyname(keyword);
if (csucess == true)
{
keyword = txtcompany.Text;
companysBLL c = pDAL.Search(keyword);
custBLL ca = new custBLL();
ca.name = txtu_Name.Text;
emailname = q.u_name;
ca.mobile = txtu_Contact.Text;
string type = "user";
ca.type = type;
ca.email = txtemail.Text;
bool isadded = false;
int id = c.id;
ca.cid = id;
ca.nquery = 0;
isadded = tDAL.Insert(ca);
if (isadded == true)
{
MessageBox.Show("new user added");
}
else
{
MessageBox.Show("new user can not be added");
}
}
else
{
MessageBox.Show("plz add new company");
addcompanys ca = new addcompanys();
ca.Show();
}
//space to add new user(custumer)
//addnewcostumer costumer = new addnewcostumer();
//costumer.Show();
//this.Hide();
//MessageBox.Show("plz add new costumer");
//Failed to Add New product
//MessageBox.Show("new user added");
}
//if the product is added successfully then the value of success will be true else it will be false
if (qsucess == true)
{
//Product Inserted Successfully
MessageBox.Show("query Added Successfully");
emailsBLL email = new emailsBLL();
email.to = txtemail.Text;
email.subject = "solidworks support query " + qid;
string body = "<h3>" + "query- \n " + "</h3>" + "<b>" + textqry.Text + "</b>" + "<h3>" + " \n\n solution- \n" + "</h3>" + "<b>" + textsoln.Text + "</b>" + "\n\n\n\n\n";
email.body = body;
email.name = txtu_Name.Text;
bool sucess = eDAL.sendemail(email);
if (sucess == true)
{
MessageBox.Show("email sent sucessfully");
}
else
{
MessageBox.Show("email not sent");
}
//Calling the Clear Method
}
}