예제 #1
0
        public void mailSender(sellPipe data, string billNo)
        {
            try
            {
                MailMessage mail       = new MailMessage();
                SmtpClient  SmtpServer = new SmtpClient("smtp.gmail.com");

                mail.From = new MailAddress("*****@*****.**");
                mail.To.Add("*****@*****.**");
                mail.Subject = "Sells Bill No:" + billNo;
                mail.Body    = "\nSold By: " + data.UserName + " \n\n\nCustomer Name:   " + data.CustomerName + "\nCustomer Email: " + data.CustomerEmail + "\nCustomer PhoneNumber: " + data.CustomerPhoneNumber + "\n\nPipe Name:    " + data.PipeName + "\nPipe Size:   " + data.PipeSize + "\nQuantity:   " + data.Quantity + "\n\nTotal Price:  " + data.TotalPrice + "\n\nPaid Amount: " + data.PaidAmount + "\n\nDue Amount: " + data.DueAmount + "\n\nDiscount: " + discountField.Text;

                //[email protected]", "tonmoydotzone$$$"


                SmtpServer.Port        = 587;
                SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "tonmoydotzone$$$");
                SmtpServer.EnableSsl   = true;

                SmtpServer.Send(mail);
                //MessageBox.Show("mail Send");
                notifyIcon1.ShowBalloonTip(1000, "Sending Sell Report As Mail", "Mail has been send to admin", ToolTipIcon.Info);
            }
            catch (Exception ex)
            {
                //  MessageBox.Show(ex.ToString());
                // notifyIcon1.ShowBalloonTip(1000, "Sending Sell Mail failed", ex.ToString(), ToolTipIcon.Info);
                //  MessageBox.Show(""+ex);
            }
        }
예제 #2
0
        public void mailSender(sellPipe data, string billNo)
        {
            try
            {
                MailMessage mail       = new MailMessage();
                SmtpClient  SmtpServer = new SmtpClient("smtp.gmail.com");

                mail.From = new MailAddress("*****@*****.**");
                mail.To.Add("*****@*****.**");
                mail.Subject = "Purchase Bill No:" + billNo;
                mail.Body    = "\nPurchase By:   " + data.UserName + " \n\n\nBought From:   " + textBox3.Text + "\n\nPipe Name:    " + data.PipeName + "\nPipe Size:   " + data.PipeSize + "\nQuantity Bought:    " + textBox4.Text + "\nPresent Quantity:   " + data.Quantity + "\n\nUnit price:    " + textBox5.Text + "\n\nTotal Price:  " + data.TotalPrice;

                SmtpServer.Port        = 587;
                SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "tonmoydotzone$$$");
                SmtpServer.EnableSsl   = true;

                SmtpServer.Send(mail);
                //MessageBox.Show("mail Send");
                notifyIcon1.ShowBalloonTip(1000, "Sending Report As Mail", "Mail has been send to admin", ToolTipIcon.Info);
            }
            catch (Exception ex)
            {
                //  MessageBox.Show(ex.ToString());
                // notifyIcon1.ShowBalloonTip(1000, "Sending Purchase report Mail failed", ex.ToString(), ToolTipIcon.Info);
            }
        }
예제 #3
0
 public void createPdf(string billNo, sellPipe sp)
 {
     this.sp   = sp;
     this.data = new List <string>();
     this.data.Add(this.sp.PipeName);            //0
     this.data.Add(this.sp.PipeSize);            //1
     this.data.Add(this.sp.Quantity);            //2
     this.data.Add(this.sp.PricePerPipe);        //3
     this.data.Add(this.sp.TotalPrice);          //4
     this.data.Add(this.sp.CustomerName);        //5
     this.data.Add(this.sp.CustomerPhoneNumber); //6
     this.data.Add(this.sp.CustomerEmail);       //7
     this.data.Add(this.sp.PaidAmount);          //8
     this.data.Add(this.sp.DueAmount);           //9
     this.data.Add(this.sp.Discount);            //10
     this.data.Add(this.sp.UserName);            //11
     this.data.Add(this.sp.TotalPrize);          //12
     this.data.Add(billNo);                      //13
     this.billNo = billNo;
     if (!this.ad.dataAddToDb(this.data))
     {
         MessageBox.Show("Check Internet Connection\n\nOr Report to admin");
     }
     else
     {
         MakePdf();
     }
 }
예제 #4
0
 public PdfMaker()
 {
     this.data  = null;
     this.sp    = null;
     ad         = new addData();
     this.alert = new Alert();
 }
예제 #5
0
        private void proceedButton_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            if (String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrEmpty(cEmail.Text) || String.IsNullOrEmpty(phoneNumber.Text) || String.IsNullOrEmpty(paidAmount.Text) || quantityField.Text.Equals("0"))
            {
                MessageBox.Show("Enter all information\nEnter \'no-email\' if customer doesn't have any email-address.\nPipe Quanity must be more then 0");
            }
            else if ((int.Parse(paidAmount.Text)) == 0)
            {
                this.alert.Show(alert.Error, "Customer must pay");
            }
            else
            {
                if ((Double.Parse(totalPrice.Text) / 2) > (Double.Parse(paidAmount.Text)))
                {
                    this.alert.Show(alert.Error, "Customer should may more then half");
                }
                else
                {
                    if (discountField.Text.Equals(""))
                    {
                        discountField.Text = "0";
                        ddval.Text         = "0";
                    }
                    string billNo = DateTime.Now.ToString("MM") + DateTime.Now.ToString("dd") + DateTime.Now.ToString("yy") + DateTime.Now.ToString("hh") + DateTime.Now.ToString("mm") + DateTime.Now.ToString("ss");
                    var    data   = new sellPipe()
                    {
                        PipeName            = comboBox1.Text,
                        PipeSize            = comboBox2.Text,
                        Quantity            = quantityField.Text,
                        CustomerName        = textBox1.Text,
                        Discount            = discountField.Text,
                        CustomerEmail       = cEmail.Text,
                        CustomerPhoneNumber = (comboBox3.Text + phoneNumber.Text),
                        TotalPrize          = (Double.Parse(totalPrice.Text) - Double.Parse(ddval.Text)).ToString(),
                        PricePerPipe        = pricePerUnit.Text,
                        DueAmount           = dueAmount.Text,
                        UserName            = this.UserName,
                        PaidAmount          = this.paidAmount.Text,
                        TotalPrice          = totalPrice.Text
                    };

                    new PdfMaker().createPdf(billNo, data);
                    this.Cursor = Cursors.Default;
                    mailSender(data, billNo);
                }
            }

            this.Cursor = Cursors.Default;
        }
예제 #6
0
        public void stockUpdate()
        {
            if (check(pName.Text))
            {
                this.Cursor = Cursors.Default;
                this.alert.Show(this.alert.Warning, "Pipe Name Not Given ");
            }
            else if (check(label21.Text))
            {
                this.Cursor = Cursors.Default;
                this.alert.Show(this.alert.Warning, "Pipe Size Not Given ");
            }
            else if (check(label26.Text))
            {
                this.Cursor = Cursors.Default;
                this.alert.Show(this.alert.Warning, "Seller Information Not Given ");
            }
            else
            {
                string sql;
                string sql2;
                string billNo = DateTime.Now.ToString("mm") + DateTime.Now.ToString("dd") + DateTime.Now.ToString("yy") + DateTime.Now.ToString("hh") + DateTime.Now.ToString("MM") + DateTime.Now.ToString("ss");
                var    data   = new sellPipe()
                {
                    PipeName     = pName.Text,
                    PipeSize     = label21.Text,
                    Quantity     = label23.Text,
                    PricePerPipe = label24.Text,
                    TotalPrice   = label25.Text,
                    UserName     = this.UserName
                };

                if (!pname && !psize)
                {
                    this.pc.getPrice(data.PipeName, data.PipeSize);
                    int quantity = int.Parse(this.pc.Quantity);
                    data.Quantity = (quantity + int.Parse(label23.Text)).ToString();
                    sql           = String.Format("update stock set quantity={0} where pipe_name='{1}' and pipe_size='{2}'", data.Quantity, data.PipeName, data.PipeSize);
                    sql2          = sql2 = string.Format("INSERT INTO `transection`(`billNo`,`item_date`, `pipe_name`, `pipe_size`, `quantity`, `amount` ,`paid_amount`,`due_amount`,`done_by`, `status`) VALUES ('{0}','{1}',\'" + data.PipeName + "\',\'" + data.PipeSize + "\'," + data.Quantity + "," + data.TotalPrice + ",{2},{3},'{4}',\'purchase\')", billNo, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), data.TotalPrice, 0, data.UserName);
                    // MessageBox.Show(sql);
                    if (this.pda.addToDb(sql))
                    {
                        if (this.pda.addToDb(sql2))
                        {
                            this.Cursor = Cursors.Default;
                            this.alert.Show(alert.Success, "Purchase report done");
                            mailSender(data, billNo);
                        }
                        else
                        {
                            this.Cursor = Cursors.Default;
                            this.alert.Show(alert.Error, "Transection error\nNet Connection problem");
                        }
                    }
                    else
                    {
                        this.Cursor = Cursors.Default;
                        this.alert.Show(alert.Error, "update error\nNet Connection problem");
                    }
                }
                else
                {
                    if (!String.IsNullOrEmpty(textBox5.Text))
                    {
                        if (!this.pda.CheckStock(data.PipeName, data.PipeSize))
                        {
                            sql = String.Format("insert into stock(`pipe_name`,`pipe_size`,`quantity`,`price_per_unit`)values('{0}','{1}',{2},{3})", data.PipeName, data.PipeSize, data.Quantity, data.PricePerPipe);
                        }
                        else
                        {
                            this.pc.getPrice(data.PipeName, data.PipeSize);
                            int quantity = int.Parse(this.pc.Quantity);
                            data.Quantity = (quantity + int.Parse(label23.Text)).ToString();
                            sql           = String.Format("update stock set quantity={0} where pipe_name='{1}' and pipe_size='{2}'", data.Quantity, data.PipeName, data.PipeSize);
                        }
                        // MessageBox.Show(sql);
                        sql2 = sql2 = string.Format("INSERT INTO `transection`(`billNo`,`item_date`, `pipe_name`, `pipe_size`, `quantity`, `amount` ,`paid_amount`,`due_amount`,`done_by`, `status`) VALUES ('{0}','{1}',\'" + data.PipeName + "\',\'" + data.PipeSize + "\'," + data.Quantity + "," + data.TotalPrice + ",{2},{3},'{4}',\'purchase\')", billNo, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), data.TotalPrice, 0, data.UserName);
                        if (this.pda.addToDb(sql))
                        {
                            if (this.pda.addToDb(sql2))
                            {
                                mailSender(data, billNo);
                                this.Cursor = Cursors.Default;
                                this.alert.Show(alert.Success, "Purchase report done");
                            }
                            else
                            {
                                this.Cursor = Cursors.Default;
                                this.alert.Show(alert.Error, "Transection error\nNet Connection problem");
                            }
                        }
                        else
                        {
                            this.Cursor = Cursors.Default;
                            this.alert.Show(alert.Error, "update error\nNet Connection problem");
                        }
                    }
                    else
                    {
                        this.Cursor = Cursors.Default;
                        this.alert.Show(alert.Error, "Enter price per unit ");
                    }
                }
            }
        }