예제 #1
0
        //This is to save the GRN cheque details together
        //START
        public void SaveGRNChequeeDetails()
        {
            try
            {
                int rows = ChequeGRN.GRNChequeDataGridView.Count;
                for (int i = 0; rows - 1 > i; i++)

                {
                    ProjectConnection Newconnection = new ProjectConnection();
                    Newconnection.Connection_Today();
                    SqlCommand comm = new SqlCommand();
                    comm.Connection  = ProjectConnection.conn;
                    comm.CommandType = CommandType.StoredProcedure;
                    comm.CommandText = "GRN.Save_GRN_Bank_Cheque_Details";

                    string[] StringArrayData = new string[4];
                    StringArrayData = ((IEnumerable)ChequeGRN.GRNChequeDataGridView[i]).Cast <object>().Select(X => X == null ? null : X.ToString()).ToArray();

                    comm.Parameters.AddWithValue("@Doc_No", Documentid.ToString());
                    comm.Parameters.AddWithValue("@Cheque_No", (StringArrayData[0]).ToString());
                    comm.Parameters.AddWithValue("@Amount", Convert.ToDecimal((StringArrayData[1]).ToString()));
                    comm.Parameters.AddWithValue("@Bank_Ac_Name", ((StringArrayData[2]).ToString()));
                    comm.Parameters.AddWithValue("@Note", ((StringArrayData[3]).ToString()));
                    comm.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Code GRN-01 \nTry Again with Correct Inputs \n" + ex.Message);
            }
        }
예제 #2
0
        public void BankAccountGrid()
        {
            try
            {
                ProjectConnection Newconnection = new ProjectConnection();
                Newconnection.Connection_Today();
                SqlCommand comm = new SqlCommand();
                comm.Connection  = ProjectConnection.conn;
                comm.CommandType = CommandType.StoredProcedure;
                comm.CommandText = "Finance.Load_bank_acount_details";
                comm.Parameters.AddWithValue("@Search_Condition", textBoxSearch.Text);
                SqlDataAdapter da = new SqlDataAdapter(comm);
                DataTable      dt = new DataTable();
                da.Fill(dt);
                dataGridViewBankAccount.DataSource         = dt;
                dataGridViewBankAccount.Columns[0].Visible = false;
                dataGridViewBankAccount.Columns[2].Visible = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            DataGridViewColumn column = dataGridViewBankAccount.Columns[1];

            column.Width = 150;
        }
예제 #3
0
        //------------------------Other FN END-------------------//


        public void SaveInvoiceDetails()
        {
            try
            {
                int rows = dataGridView1.Rows.Count;
                for (int i = 0; rows - 1 > i; i++)

                {
                    ProjectConnection Newconnection = new ProjectConnection();
                    Newconnection.Connection_Today();
                    SqlCommand comm = new SqlCommand();
                    comm.Connection  = ProjectConnection.conn;
                    comm.CommandType = CommandType.StoredProcedure;
                    comm.CommandText = "dbo.SRN_Save_Srn_Details";
                    comm.Parameters.AddWithValue("@ID", Documentid.ToString());
                    comm.Parameters.AddWithValue("@Item_Code", (dataGridView1.Rows[i].Cells["ItemCode"].Value).ToString());
                    comm.Parameters.AddWithValue("@Selling_Price", Convert.ToDecimal((dataGridView1.Rows[i].Cells["ItemCost"].Value).ToString()));
                    comm.Parameters.AddWithValue("@Quentity", Convert.ToDecimal((dataGridView1.Rows[i].Cells["ItemQuentity"].Value).ToString()));
                    comm.Parameters.AddWithValue("@Amount", Convert.ToDecimal((dataGridView1.Rows[i].Cells["Amount"].Value).ToString()));
                    comm.ExecuteNonQuery();
                }
                SaveInvoice();
            }
            catch (Exception ex)
            {
                MessageBox.Show("SRN DETAILS ERROR \nTry Again with Correct Inputs \n" + ex.Message);
            }
        }
예제 #4
0
        public void SaveDelete()
        {
            try
            {
                ProjectConnection Newconnection = new ProjectConnection();
                Newconnection.Connection_Today();
                SqlCommand comm = new SqlCommand();
                comm.Connection  = ProjectConnection.conn;
                comm.CommandType = CommandType.StoredProcedure;
                comm.CommandText = "dbo.Create_User";
                comm.Parameters.AddWithValue("@Save_type", SaveType);
                comm.Parameters.AddWithValue("@Name", textBoxUserFullName.Text);
                comm.Parameters.AddWithValue("@Nic", textBoxNic.Text);
                comm.Parameters.AddWithValue("@User_name", textBoxUserName.Text);
                comm.Parameters.AddWithValue("@Password", textBoxConformPassword.Text);
                comm.Parameters.AddWithValue("@Type", comboBox1.Text);

                comm.ExecuteNonQuery();
                if (SaveType == 1)
                {
                    MessageBox.Show("User Created");
                }
                else if (SaveType == 2)
                {
                    MessageBox.Show("User Deleted");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
예제 #5
0
 public void grid()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "stock.Get_List_of_Stock_details";
         comm.Parameters.AddWithValue("@Search_Condition", textBoxSearch.Text);
         SqlDataAdapter da = new SqlDataAdapter(comm);
         DataTable      dt = new DataTable();
         da.Fill(dt);
         dataGridView1.DataSource = dt;
         DataGridViewColumn column  = dataGridView1.Columns[0];
         DataGridViewColumn column2 = dataGridView1.Columns[4];
         column.Width  = 255;
         column2.Width = 150;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
예제 #6
0
        public void gridBanking()
        {
            try
            {
                ProjectConnection Newconnection = new ProjectConnection();
                Newconnection.Connection_Today();
                SqlCommand comm = new SqlCommand();
                comm.Connection  = ProjectConnection.conn;
                comm.CommandType = CommandType.StoredProcedure;
                comm.CommandText = "Finance.Load_Banking_Transactions_To_Grid_View";
                comm.Parameters.AddWithValue("@Search_Condition", textBoxSearch.Text);
                SqlDataAdapter da = new SqlDataAdapter(comm);
                DataTable      dt = new DataTable();
                da.Fill(dt);
                dataGridViewBanking.DataSource = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            DataGridViewColumn column1 = dataGridViewBanking.Columns[1];

            column1.Width = 250;
            DataGridViewColumn column2 = dataGridViewBanking.Columns[2];

            column2.Width = 150;
            DataGridViewColumn column6 = dataGridViewBanking.Columns[6];

            column6.Width = 170;
        }
예제 #7
0
 public void LoadCustomer()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "Customer.Load_Customer_Code_And_Name_Using_Vehicle_No";
         comm.Parameters.AddWithValue("@Vehicle_No", "");
         SqlDataReader dr;
         dr = comm.ExecuteReader();
         if (dr.HasRows == true)
         {
             dr.Read();
             textBoxCSID.Text   = dr["Doc_No"].ToString();
             textBoxCSName.Text = dr["Name"].ToString();
             dr.Close();
         }
     }
     catch (Exception)
     {
         MessageBox.Show("Error Loading Customer Details");
     }
 }
예제 #8
0
 public void LoadInvoice()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "dbo.SRN_Load_Invoice_Details";
         comm.Parameters.AddWithValue("@Invoice", textBoxInvoice.Text);
         SqlDataAdapter da = new SqlDataAdapter(comm);
         DataTable      dt = new DataTable();
         da.Fill(dt);
         dataGridView1.DataSource = dt;
         DataGridViewColumn column = dataGridView1.Columns[0];
         column.Width = 310;
     }
     catch (Exception ex)
     {
         Documentid      = Guid.NewGuid().ToString();
         labelDocID.Text = Documentid;
         MessageBox.Show(ex.Message);
     }
 }
예제 #9
0
        private void buttonSave_Click(object sender, EventArgs e)
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "dbo.Update_Permission  ";
            comm.Parameters.AddWithValue("@Setting_Name", labelSettingName.Text);
            if (checkBoxSetting.Checked == true)
            {
                comm.Parameters.AddWithValue("@Value", "ACTIVE");
            }
            else
            {
                comm.Parameters.AddWithValue("@Value", "DEACTIVE");
            }

            comm.ExecuteNonQuery();
            Form1.LoadPermission();
            LoadSettings();
            MessageBox.Show("Successfully");
        }
예제 #10
0
 public void OtherGeneralDetails()
 {
     try {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "dbo.SRN_Load_Invoice_Header";
         comm.Parameters.AddWithValue("@Invoice", textBoxInvoice.Text);
         SqlDataReader dr;
         dr = comm.ExecuteReader();
         if (dr.HasRows == true)
         {
             dr.Read();
             textBoxCSID.Text        = dr["Customer_Code"].ToString();
             textBoxCSName.Text      = dr["Name"].ToString();
             textBoxItemAmount.Text  = dr["Total_Amount"].ToString();
             textBoxSelectedInv.Text = dr["Doc_No"].ToString();
             dr.Close();
         }
     }
     catch (Exception)
     {
         MessageBox.Show("Faild Loading Details");
     }
 }
예제 #11
0
 public void LoadItemDetailsBarcode()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "Stock.Search_Items";
         comm.Parameters.AddWithValue("@Search_Condition", textBoxItemCode.Text);
         SqlDataReader dr;
         dr = comm.ExecuteReader();
         if (dr.HasRows == true)
         {
             dr.Read();
             textBoxItemCode.Text = dr["Item Code"].ToString();
             textBoxItemName.Text = dr["Item Name"].ToString();
             textBoxCost.Text     = dr["Selling_Price"].ToString();
             dr.Close();
         }
     }
     catch (Exception)
     {
         MessageBox.Show("Error Loading Customer Details");
     }
 }
예제 #12
0
        public void SaveInvoice()
        {
            try
            {
                ProjectConnection Newconnection = new ProjectConnection();
                Newconnection.Connection_Today();
                SqlCommand comm = new SqlCommand();
                comm.Connection  = ProjectConnection.conn;
                comm.CommandType = CommandType.StoredProcedure;
                comm.CommandText = "dbo.SRN_Save_Srn_header";
                comm.Parameters.AddWithValue("@ID", Documentid.ToString());
                comm.Parameters.AddWithValue("@Invoice", textBoxInvoice.Text);
                comm.Parameters.AddWithValue("@Total_Amount", Convert.ToDecimal(textBoxItemAmount.Text));
                comm.Parameters.AddWithValue("@Remark ", textBoxRemark.Text);
                comm.Parameters.AddWithValue("@Customer_Code", textBoxCSID.Text);
                comm.Parameters.AddWithValue("@Date", Convert.ToDateTime(dateTimePickerTranDate.Text));

                comm.ExecuteNonQuery();
                MessageBox.Show("Sales Return Saved");
            }
            catch (Exception ex)
            {
                MessageBox.Show("SRN HEADER ERROR \nTry Again with Correct Inputs \n" + ex.Message);
            }
        }
예제 #13
0
        public void SaveDelete()
        {
            try
            {
                if (radioButtonCashOut.Checked == true || radioButtonCashIn.Checked == true)
                {
                    ProjectConnection Newconnection = new ProjectConnection();
                    Newconnection.Connection_Today();
                    SqlCommand comm = new SqlCommand();
                    comm.Connection  = ProjectConnection.conn;
                    comm.CommandType = CommandType.StoredProcedure;
                    comm.CommandText = "finance.Save_Cash_transaction";
                    comm.Parameters.AddWithValue("@Save_Type", SaveType);
                    comm.Parameters.AddWithValue("@Doc_No", labelDoc_No.Text);
                    if (textBoxAmount.Text == "")
                    {
                        comm.Parameters.AddWithValue("@Amount", 0);
                    }
                    else
                    {
                        comm.Parameters.AddWithValue("@Amount", Convert.ToDecimal(textBoxAmount.Text));
                    }

                    if (radioButtonCashIn.Checked == true)
                    {
                        comm.Parameters.AddWithValue("@Type", "Debit");
                    }
                    else if (radioButtonCashOut.Checked == true)
                    {
                        comm.Parameters.AddWithValue("@Type", "Credit");
                    }
                    if (checkBoxBankTransfer.Checked == true)
                    {
                        comm.Parameters.AddWithValue("@Account_Name", "Bank Trasnfer");
                    }
                    else
                    {
                        comm.Parameters.AddWithValue("@Account_Name", textBoxDirection.Text);
                    }
                    comm.Parameters.AddWithValue("@Note", textBoxNote.Text);

                    comm.Parameters.AddWithValue("@Transaction_Date", Convert.ToDateTime(dateTimePickerTransactionDate.Text));
                    comm.ExecuteNonQuery();
                    gridCash();
                    if (SaveType == 1)
                    {
                        MessageBox.Show("Saved Successfully");
                    }
                    else if (SaveType == 2)
                    {
                        MessageBox.Show("Deleted Successfully");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
예제 #14
0
        private void buttonBackup_Click(object sender, EventArgs e)
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "dbo.Backup_Database";
            comm.ExecuteNonQuery();
            MessageBox.Show("Back up Done successfully", "SQLDB Backup", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
예제 #15
0
 public void SaveUpdateDelete()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "Suppliers.Save_Update_Delete_Supplier_Details";
         comm.Parameters.AddWithValue("@Save_Type", SaveType);
         comm.Parameters.AddWithValue("@Doc_No", textBoxSupCode.Text);
         comm.Parameters.AddWithValue("@Name", textBoxName.Text);
         comm.Parameters.AddWithValue("@Company_Name", textBoxCompanyName.Text);
         comm.Parameters.AddWithValue("@Address", textBoxAddress.Text);
         comm.Parameters.AddWithValue("@Nic", textBoxNic.Text);
         comm.Parameters.AddWithValue("@Mobile_2", textBoxMobile02.Text);
         comm.Parameters.AddWithValue("@Mobile_1", textBoxMobile01.Text);
         comm.Parameters.AddWithValue("@Email", textBoxEmail.Text);
         comm.Parameters.AddWithValue("@Website", textBoxWebsite.Text);
         comm.Parameters.AddWithValue("@Other_Contact_Details", textBoxOtherContact.Text);
         comm.Parameters.AddWithValue("@Supplier_Since", Convert.ToDateTime(dateTimePickerSince.Text));
         comm.Parameters.AddWithValue("@Note", textBoxNote.Text);
         comm.ExecuteNonQuery();
         if (SaveType == 1)
         {
             LoadSupplierCode();
             Clear();
             grid();
             MessageBox.Show("Updated");
         }
         else if (SaveType == 2)
         {
             LoadSupplierCode();
             Clear();
             grid();
             MessageBox.Show("Deleted");
         }
         else if (SaveType == 3)
         {
             LoadSupplierCode();
             Clear();
             grid();
             MessageBox.Show("Saved");
         }
     }
     catch (Exception EX)
     {
         MessageBox.Show(EX.Message);
     }
 }
예제 #16
0
        public void LoadSettings()
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "dbo.Load_Permission";
            comm.Parameters.AddWithValue("@Search_Condition", textBoxSearch.Text);
            SqlDataAdapter da = new SqlDataAdapter(comm);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            dataGridView1.DataSource = dt;
        }
예제 #17
0
 private void buttonDelete_Click(object sender, EventArgs e)
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "dbo.SRN_Delete_SRN";
         comm.Parameters.AddWithValue("@Doc_No", textBoxSearch.Text);
         comm.ExecuteNonQuery();
         grid();
     }
     catch (Exception)
     {
         MessageBox.Show("Fail Delete");
     }
 }
예제 #18
0
        public void SaveDeleteUpdate()
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "Finance.Save_Update_Delete_Bank_Account_Details";
            comm.Parameters.AddWithValue("@Save_Type", SaveType);
            comm.Parameters.AddWithValue("@Doc_No", textBoxDoc_No.Text);
            comm.Parameters.AddWithValue("@Bank_Or_Act", textBoxBankAccount.Text);
            comm.Parameters.AddWithValue("@Account_No", textBoxAccountNo.Text);
            comm.Parameters.AddWithValue("@Account_Type", comboBoxAccountType.Text);
            comm.ExecuteNonQuery();
            LoadBnkCode();
            grid();
        }
예제 #19
0
        public void SaveInvoice()
        {
            try
            {
                ProjectConnection Newconnection = new ProjectConnection();
                Newconnection.Connection_Today();
                SqlCommand comm = new SqlCommand();
                comm.Connection  = ProjectConnection.conn;
                comm.CommandType = CommandType.StoredProcedure;
                comm.CommandText = "Sales.Save_Invoice_Details";
                comm.Parameters.AddWithValue("@ID", Documentid.ToString());
                comm.Parameters.AddWithValue("@CS_Code", textBoxCSID.Text);
                comm.Parameters.AddWithValue("@Doc_Date", Convert.ToDateTime(dateTimePickerTranDate.Text));
                comm.Parameters.AddWithValue("@Total_Amount ", Convert.ToDecimal(textBoxItemAmount.Text));
                if (textBoxCSPaidCash.Text == "")
                {
                    comm.Parameters.AddWithValue("@Cash_Payment", 0);
                }
                else
                {
                    comm.Parameters.AddWithValue("@Cash_Payment", Convert.ToDecimal(textBoxCSPaidCash.Text));
                }
                if (textBoxChequeAmount.Text == "")
                {
                    comm.Parameters.AddWithValue("@Cheque_Payment", 0);
                }
                else
                {
                    comm.Parameters.AddWithValue("@Cheque_Payment", Convert.ToDecimal(textBoxChequeAmount.Text));
                }

                comm.Parameters.AddWithValue("@Remark", textBoxRemark.Text);

                comm.ExecuteNonQuery();
                LoadPrintInvoiceCode();
                ClearInvoice();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Code INVH-01 \nTry Again with Correct Inputs \n" + ex.Message);
            }
        }
예제 #20
0
        public void LoadSupplierCode()
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "Suppliers.Load_Supplier_Codes";
            SqlDataReader dr;

            dr = comm.ExecuteReader();
            if (dr.HasRows == true)
            {
                dr.Read();
                textBoxSupCode.Text = dr["Doc_No"].ToString();
                dr.Close();
            }
        }
예제 #21
0
        public void LoadBnkCode()
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "Finance.Bank_Account_Doc_No";
            SqlDataReader dr;

            dr = comm.ExecuteReader();
            if (dr.HasRows == true)
            {
                dr.Read();
                textBoxDoc_No.Text = dr["Doc_No"].ToString();
                dr.Close();
            }
        }
예제 #22
0
        public void LoadCashTranDocNo()
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "finance.Cash_Transaction_Doc_No";
            SqlDataReader dr;

            dr = comm.ExecuteReader();
            if (dr.HasRows == true)
            {
                dr.Read();
                labelDoc_No.Text = dr["Doc_No"].ToString();
                dr.Close();
            }
        }
예제 #23
0
        public void LoadBalance()
        {
            ProjectConnection Newconnection = new ProjectConnection();

            Newconnection.Connection_Today();
            SqlCommand comm = new SqlCommand();

            comm.Connection  = ProjectConnection.conn;
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "Finance.Load_Cash_Balance";
            SqlDataReader dr;

            dr = comm.ExecuteReader();
            if (dr.HasRows == true)
            {
                dr.Read();
                labelBalance.Text = dr["Amount"].ToString();
                dr.Close();
            }
        }
예제 #24
0
        public void SaveDelete()
        {
            if (radioButtonBankOut.Checked == true || radioButtonBankIn.Checked == true)
            {
                ProjectConnection Newconnection = new ProjectConnection();
                Newconnection.Connection_Today();
                SqlCommand comm = new SqlCommand();
                comm.Connection  = ProjectConnection.conn;
                comm.CommandType = CommandType.StoredProcedure;
                comm.CommandText = "Finance.Save_Delete_Bank_Transaction";
                comm.Parameters.AddWithValue("@Save_Type", SaveType);
                comm.Parameters.AddWithValue("@Doc_No", labelDoc_No.Text);
                comm.Parameters.AddWithValue("@Account_Doc_No", textBoxAccountDoc_No.Text);
                comm.Parameters.AddWithValue("@Account", textBoxDirection.Text);
                if (textBoxAmount.Text == "")
                {
                    comm.Parameters.AddWithValue("@Amount", 0);
                }
                else
                {
                    comm.Parameters.AddWithValue("@Amount", Convert.ToDecimal(textBoxAmount.Text));
                }

                comm.Parameters.AddWithValue("@Date", Convert.ToDateTime(dateTimePickerTranBanking.Text));

                if (radioButtonBankIn.Checked == true)
                {
                    comm.Parameters.AddWithValue("@Type", "Debit");
                }
                else if (radioButtonBankOut.Checked == true)
                {
                    comm.Parameters.AddWithValue("@Type", "Credit");
                }
                comm.Parameters.AddWithValue("@Note", textBoxNote.Text);

                comm.ExecuteNonQuery();
                LoadBankTranDocNo();
                gridBanking();
                clear();
            }
        }
예제 #25
0
 public static void LoadPermission()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "dbo.Load_Permission_For_User";
         SqlDataAdapter da = new SqlDataAdapter(comm);
         DataTable      dt = new DataTable();
         da.Fill(dt);
         //MessageBox.Show(dt.Rows[0][1].ToString());
         //MessageBox.Show(dt.Rows[1][1].ToString());
         Permission.InvoiceSave               = dt.Rows[0][1].ToString();
         Permission.InvoiceDisount            = dt.Rows[1][1].ToString();
         Permission.InvoiceCustomerSelect     = dt.Rows[2][1].ToString();
         Permission.InvoiceDateSelect         = dt.Rows[3][1].ToString();
         Permission.InvoiceSellingPriceChange = dt.Rows[4][1].ToString();
         Permission.GRNCostChange             = dt.Rows[5][1].ToString();
         Permission.GRNDiscountChange         = dt.Rows[6][1].ToString();
         Permission.GRNOldView         = dt.Rows[7][1].ToString();
         Permission.GRNSave            = dt.Rows[8][1].ToString();
         Permission.ItemSave           = dt.Rows[9][1].ToString();
         Permission.ItemUpdate         = dt.Rows[10][1].ToString();
         Permission.ItemDelete         = dt.Rows[11][1].ToString();
         Permission.CustomerSave       = dt.Rows[12][1].ToString();
         Permission.CustomerUpdate     = dt.Rows[13][1].ToString();
         Permission.CustomerDelete     = dt.Rows[14][1].ToString();
         Permission.SupplierSave       = dt.Rows[15][1].ToString();
         Permission.SupplierUpadate    = dt.Rows[16][1].ToString();
         Permission.SupplierDelete     = dt.Rows[17][1].ToString();
         Permission.StockView          = dt.Rows[18][1].ToString();
         Permission.BarcodePrintAccess = dt.Rows[19][1].ToString();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
예제 #26
0
 public void gridCash()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "finance.Load_Cash_Transactions";
         comm.Parameters.AddWithValue("@Search_Condition", textBoxSearch.Text);
         SqlDataAdapter da = new SqlDataAdapter(comm);
         DataTable      dt = new DataTable();
         da.Fill(dt);
         dataGridViewBanking.DataSource = dt;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
예제 #27
0
 private void buttonDelete_Click(object sender, EventArgs e)
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "dbo.Delete_Service_List";
         comm.Parameters.AddWithValue("@Doc_No", textBoxDocNo.Text);
         comm.ExecuteNonQuery();
         grid();
         textBoxDocNo.Clear();
         MessageBox.Show("Deleted");
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
예제 #28
0
 public void SaveGRNHeader()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "GRN.Save_GRN_Details ";
         comm.Parameters.AddWithValue("@ID", Documentid.ToString());
         comm.Parameters.AddWithValue("@Sup_Code", textBoxSUPID.Text);
         comm.Parameters.AddWithValue("@Doc_Date", Convert.ToDateTime(dateTimePickerTranDate.Text));
         comm.Parameters.AddWithValue("@Total_Amount ", Convert.ToDecimal(textBoxItemAmount.Text));
         if (textBoxPaidCash.Text == "")
         {
             comm.Parameters.AddWithValue("@Cash_Payment", 0);
         }
         else
         {
             comm.Parameters.AddWithValue("@Cash_Payment", Convert.ToDecimal(textBoxPaidCash.Text));
         }
         if (textBoxChequeAmount.Text == "")
         {
             comm.Parameters.AddWithValue("@Cheque_Payment", 0);
         }
         else
         {
             comm.Parameters.AddWithValue("@Cheque_Payment", Convert.ToDecimal(textBoxChequeAmount.Text));
         }
         comm.ExecuteNonQuery();
         MessageBox.Show("Successfully");
         Clear();
     }
     catch (Exception ex)
     {
         MessageBox.Show("Error Code GRNH-01 \nTry Again with Correct Inputs \n" + ex.Message);
     }
 }
예제 #29
0
 private void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         if (textBoxName.Text == "")
         {
             MessageBox.Show("Required Name Field");
         }
         else
         {
             ProjectConnection Newconnection = new ProjectConnection();
             Newconnection.Connection_Today();
             SqlCommand comm = new SqlCommand();
             comm.Connection  = ProjectConnection.conn;
             comm.CommandType = CommandType.StoredProcedure;
             comm.CommandText = "Customer.Save_Customer_Details";
             comm.Parameters.AddWithValue("@Name", textBoxName.Text);
             comm.Parameters.AddWithValue("@Address", textBoxAddress.Text);
             comm.Parameters.AddWithValue("@Nic", textBoxNic.Text);
             comm.Parameters.AddWithValue("@Mobile_2", textBoxMobile02.Text);
             comm.Parameters.AddWithValue("@Mobile_1", textBoxMobile01.Text);
             comm.Parameters.AddWithValue("@Email", textBoxEmail.Text);
             comm.Parameters.AddWithValue("@Website", textBoxWebsite.Text);
             comm.Parameters.AddWithValue("@Other_Contact_Details", textBoxOtherContact.Text);
             comm.Parameters.AddWithValue("@Customer_Since", Convert.ToDateTime(dateTimePickerSince.Text));
             comm.Parameters.AddWithValue("@Note", textBoxNote.Text);
             comm.Parameters.AddWithValue("@User_Code", "");
             comm.ExecuteNonQuery();
             grid();
             LoadCustomerCode();
             Clear();
             MessageBox.Show("Saved");
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString() + "Do not enter duplicate value");
     }
 }
예제 #30
0
 public void gridDetails()
 {
     try
     {
         ProjectConnection Newconnection = new ProjectConnection();
         Newconnection.Connection_Today();
         SqlCommand comm = new SqlCommand();
         comm.Connection  = ProjectConnection.conn;
         comm.CommandType = CommandType.StoredProcedure;
         comm.CommandText = "dbo.[SRN_Load_SRN_DETAILS] ";
         comm.Parameters.AddWithValue("@Search_Condition", textBoxSearch.Text);
         SqlDataAdapter da = new SqlDataAdapter(comm);
         DataTable      dt = new DataTable();
         da.Fill(dt);
         //dataGridViewDetails.DataSource = dt;
         //DataGridViewColumn column = dataGridViewDetails.Columns[2];
         //column.Width = 255;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }