private void btnAdd_Click(object sender, EventArgs e)


        {
            dc.c_name        = txtcname.Text;
            dc.c_email       = txtcemail.Text;
            dc.c_mobile      = txtcmobile.Text;
            dc.c_location    = txtclocation.Text;
            dc.c_category    = txtccatogary.Text;
            dc.subend_date   = txtcsubend.Text;
            dc.substart_date = "vaibhav";

            pDAL.Insert(dc);
            bool success = pDAL.Insert(dc);

            if (success == true)
            {
                MessageBox.Show("company added sucessfully");
                clear();
            }
            else
            {
                MessageBox.Show("company can not be added");
            }
        }
Exemple #2
0
        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");
                    }
                }
            }
        }