private void btnSave_Click(object sender, EventArgs e) { bool result = false; if (string.IsNullOrEmpty(txtExpAmount.Text) || string.IsNullOrEmpty(comboBox1.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (btnSave.Text == "Add") { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into Pcard(CardNumber,CreatedBy,IsActive) values" + "('" + txtExpAmount.Text + "'," + GlobalData.UserID + ",'" + comboBox1.Text + "')"); } else { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("UPDATE Pcard SET CardNumber='" + txtExpAmount.Text + "',IsActive='" + comboBox1.Text + "' where " + "PSNo=" + PSNo + ""); } if (result == true) { FrmMessage.Show("Transaction Success"); btnTbSearch_Click(sender, e); Cat_ItemGrid.DataSource = null; Cat_ItemGrid.Columns.Clear(); } } }
private void btnSearch_Click(object sender, EventArgs e) { EmpGrid.Visible = true; string EmpRole = ""; if (SrchddlRole.SelectedValue.ToString() == "0") { EmpRole = "%"; } else { EmpRole = SrchddlRole.SelectedValue.ToString(); } ds = new DataSet(); ds = sqlhelp.ExecuteQueries("Select U.UserID,R.RoleID,U.LoginID,R.RoleName,U.Name,U.Address,U.Email," + "U.Mobile,U.IsActive as [Status] from Users U, Roles R where U.RoleID=R.RoleID and U.Name like '" + txtSrchName.Text + "%'" + " and U.RoleID like '" + EmpRole + "'"); if (ds.Tables[0].Rows.Count > 0) { EmpGrid.DataSource = ds.Tables[0]; EmpGrid.Columns["UserID"].Visible = false; EmpGrid.Columns["RoleID"].Visible = false; } else { FrmMessage.Show("No Records Found !!!"); EmpGrid.DataSource = null; EmpGrid.Columns.Clear(); } }
private void btnSave_Click(object sender, EventArgs e) { bool result = false; if (string.IsNullOrEmpty(txtRackNo.Text) || string.IsNullOrEmpty(cmbbxStatus.Text) || string.IsNullOrEmpty(txtNoOfSelfs.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (btnSave.Text == "Add") { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into RACK(RACKNO,NOOFSELFS,CreatedBy,STATUS) values" + "('" + txtRackNo.Text + "','" + txtNoOfSelfs.Text + "'," + GlobalData.UserID + ",'" + cmbbxStatus.Text + "')"); } else { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("UPDATE RACK SET RACKNO='" + txtRackNo.Text + "', NOOFSELFS='" + txtNoOfSelfs.Text + "', STATUS='" + cmbbxStatus.Text + "' where " + "RNO=" + RNO + ""); } if (result == true) { FrmMessage.Show("Transaction Success"); btnTbSearch_Click(sender, e); Cat_ItemGrid.DataSource = null; Cat_ItemGrid.Columns.Clear(); FillRack(); } } }
private void btnSave_Click(object sender, EventArgs e) { bool result = false; if (string.IsNullOrEmpty(txtExpDesc.Text) || string.IsNullOrEmpty(txtExpName.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (btnSave.Text == "Add") { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into ExpenseTypes(ExpenseName,Description,CreatedBy) values" + "('" + txtExpName.Text + "','" + txtExpDesc.Text + "'," + GlobalData.UserID + ")"); } else { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("UPDATE ExpenseTypes SET ExpenseName='" + txtExpName.Text + "',Description='" + txtExpDesc.Text + "' where " + "ExpTypeID=" + ExpTypeID + ""); } if (result == true) { FrmMessage.Show("Transaction Success"); btnTbSearch_Click(sender, e); } } }
private void btnSave_Click(object sender, EventArgs e) { bool result = false; if (string.IsNullOrEmpty(textBox4.Text) || string.IsNullOrEmpty(textBox5.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into comissionpaid(ANO, PAIDAMOUNT) values" + "(" + textBox5.Text + "," + textBox1.Text + ")"); } if (result == true) { FrmMessage.Show("Transaction Success"); dataGridView1.DataSource = null; dataGridView1.Columns.Clear(); textBox1.Text = "0"; textBox2.Text = "0"; textBox6.Text = "0"; txtAddr.Text = string.Empty; txtEmpName.Text = string.Empty; txtMobile.Text = string.Empty; } } }
private void textBox4_Leave(object sender, EventArgs e) { sqlhelp = new SQLHelper(); DataSet ds = new DataSet(); DataSet DS1 = new DataSet(); DataSet DS2 = new DataSet(); ds = sqlhelp.ExecuteQueries("select * from AGENT where memberno = '" + textBox4.Text + "'"); if (ds.Tables[0].Rows.Count > 0) { txtEmpName.Text = ds.Tables[0].Rows[0]["DNAME"].ToString(); txtMobile.Text = ds.Tables[0].Rows[0]["MOBILE"].ToString(); txtAddr.Text = ds.Tables[0].Rows[0]["ADDRESS"].ToString(); textBox5.Text = ds.Tables[0].Rows[0]["ANO"].ToString(); } DS1 = sqlhelper.ExecuteQueries("Select ANO, [Agent Name],Mobile, Address,Email,DOB,[AgentNo],transactionno as [Bill No],[comission %],comissionearned as [Comission],[Comission Date] FROM AGENTCOMISSIONEARNEDQUERY where AGENTNO = '" + textBox4.Text + "'"); if (DS1.Tables[0].Rows.Count > 0) { dataGridView1.DataSource = DS1.Tables[0]; dataGridView1.Columns["ANO"].Visible = false; } DS2 = sqlhelper.ExecuteQueries("Select * FROM COMISSIONBALANCE where ANO = " + textBox5.Text + ""); if (DS2.Tables[0].Rows.Count > 0) { textBox6.Text = DS2.Tables[0].Rows[0]["BALANCE"].ToString(); } else { FrmMessage.Show("No AGENT Records Found", caption, OkButton, InformationIcon); } }
private void btnSearch_Click(object sender, EventArgs e) { try { DataSetReports dsr = new DataSetReports(); da = new OleDbDataAdapter("select * from GetServicesDone where cdate(format(ServiceDate,'dd-MMMM-yyyy')) between cdate(format('" + ddlFromDate.Text + "','dd-MMM-yyyy')) and cdate(format('" + ddlToDate.Text + "','dd-MMM-yyyy')) ", sqlhelp.Con); da.Fill(dsr.Tables["ServiceRpt"]); if (dsr.Tables["ServiceRpt"].Rows.Count > 0) { reportViewer1.LocalReport.ReportEmbeddedResource = "Inventory.ServiceRpts.rdlc"; reportViewer1.LocalReport.DataSources.Clear(); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ServiceRpt", dsr.Tables["ServiceRpt"])); reportViewer1.DocumentMapCollapsed = true; reportViewer1.RefreshReport(); reportViewer1.Visible = true; } else { reportViewer1.Visible = false; FrmMessage.Show("No Records Found"); } } catch (Exception ex) { } finally { } }
private void btnSearch_Click(object sender, EventArgs e) { try { sqlhelp = new SQLHelper(); ds = new DataSet(); string ExpTypeSrchID = ""; if (SrchddlExpTypes.SelectedIndex == 0) { ExpTypeSrchID = "%"; } else { ExpTypeSrchID = SrchddlExpTypes.SelectedValue.ToString(); } ds = sqlhelp.ExecuteQueries("select ExpenseID,ExpTypeID,[ExpenseName],[ExpenseDate],Amount,Description from GetExpense where ExpTypeID like '" + ExpTypeSrchID + "'"); if (ds.Tables[0].Rows.Count > 0) { ExpenseGrid.DataSource = ds.Tables[0]; ExpenseGrid.Columns["ExpenseID"].Visible = false; ExpenseGrid.Columns["ExpTypeID"].Visible = false; } else { FrmMessage.Show("No records found !!!"); } } catch (Exception ex) { } finally { } }
private void btnClear_Click(object sender, EventArgs e) { if (btnClear.Text == "Clear") { txtImage.Text = string.Empty; txtServiceName.Text = string.Empty; BtnImageupld.Enabled = true; if (PriviewPic.Image != null) { PriviewPic.Image.Dispose(); } this.PriviewPic.InitialImage = global::Inventory.Properties.Resources.Noimage; PriviewPic.Image = PriviewPic.InitialImage; ImageName = string.Empty; txtDesc.Text = string.Empty; txtSrChrg.Text = string.Empty; btnTbAdd.Text = "Add"; BtnAdd.Text = "Add"; } else { if (DialogResult.Yes == FrmMessage.Show("Are you Sure. You want to Delete this Service ?", caption, YesNoButton, QuestionIcon)) { if (Int32.Parse(sqlhelp.ExecuteScalar("select count(serviceID) from STransDetails where serviceID=" + ServicesGrid.CurrentRow.Cells["ServiceID"].Value + "")) == 0) { sqlhelp.ExecuteNonQuery("delete from Service where ServiceID=" + ServicesGrid.CurrentRow.Cells["ServiceID"].Value + ""); } else { FrmMessage.Show("You cannot delete this service as it is referred in ServiceAccounts"); } } } }
private void btnSave_Click(object sender, EventArgs e) { bool result = true; if (string.IsNullOrEmpty(txtExpAmount.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!"); } else { if (btnSave.Text == "Add") { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into Tax (tax) values" + "(" + txtExpAmount.Text + ")"); } else { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("UPDATE Tax SET Tax=" + txtExpAmount.Text + " where " + "TaxID=" + PSNo + ""); } if (result == true) { FrmMessage.Show("Transaction Success"); btnTbSearch_Click(sender, e); // btnTbAdd.Visible = false; //Cat_ItemGrid.DataSource = null; //Cat_ItemGrid.Columns.Clear(); } } }
private void button1_Click(object sender, EventArgs e) { try { //else if (GlobalData.ReportName == "MemberCardReport") //{ string ddlcategory; dsr = new DataSetReports(); da = new OleDbDataAdapter("select * from COMISSIONQUERY", sqlhelp.Con); da.Fill(dsr.Tables["AGENTCOMISSIONREPORT"]); if (dsr.Tables["AGENTCOMISSIONREPORT"].Rows.Count > 0) { reportViewer1.LocalReport.ReportEmbeddedResource = "Inventory.AGENTCOMISSIONREPORT.rdlc"; reportViewer1.LocalReport.DataSources.Clear(); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", dsr.Tables["AGENTCOMISSIONREPORT"])); reportViewer1.DocumentMapCollapsed = true; reportViewer1.RefreshReport(); } else { reportViewer1.LocalReport.DataSources.Clear(); FrmMessage.Show("No Records Found"); } } //} //} catch (Exception ex) { } }
//private void txtRePwd_KeyDown(object sender, KeyEventArgs e) //{ // if (e.KeyCode == Keys.Enter) // { // if (txtPwd.Text == txtRePwd.Text) // { // btnSave_Click(sender, e); // } // else // { // lblmsg.Visible = true; // txtRePwd.Text = string.Empty; // } // } //} //private void txtRePwd_TextChanged(object sender, EventArgs e) //{ // if (txtPwd.Text != txtRePwd.Text) // { // lblmsg.Visible = true; // } // else // { // lblmsg.Visible = false; // } //} private void btnSearch_Click(object sender, EventArgs e) { EmpGrid.Visible = true; string EmpRole = ""; //if (SrchddlRole.SelectedValue.ToString() == "0") //{ // EmpRole = "%"; //} //else //{ // EmpRole = SrchddlRole.SelectedValue.ToString(); //} ds = new DataSet(); ds = sqlhelp.ExecuteQueries("Select * from Company where CName like '" + txtSrchName.Text + "%'"); if (ds.Tables[0].Rows.Count > 0) { EmpGrid.DataSource = ds.Tables[0]; EmpGrid.Columns["CID"].Visible = false; //EmpGrid.Columns["RoleID"].Visible = false; } else { FrmMessage.Show("No Records Found !!!"); EmpGrid.DataSource = null; EmpGrid.Columns.Clear(); } }
private void btngetpwd_Click(object sender, EventArgs e) { try { sqlhelp = new SQLHelper(); dt = new DataTable(); dt = sqlhelp.ExecuteTables("SELECT U.[LoginID],U.[Password] " + "FROM Users U,Roles R WHERE R.RoleID=U.RoleID AND " + "U.LoginID = '" + txtFrgLoginID.Text + "'"); if (dt.Rows.Count > 0) { txtFrgPwd.Text = dt.Rows[0]["Password"].ToString(); } else { FrmMessage.Show("Invalid LoginID.Please Re-Enter the LoginID"); } } catch (Exception ex) { } finally { } }
private void textBox64_KeyPress(object sender, KeyPressEventArgs e) { try { if (Convert.ToInt32(e.KeyChar) == 13) { sqlhelper = new SQLHelper(); DataSet ds = new DataSet(); DataSet dsAmer2 = new DataSet(); ds = sqlhelper.ExecuteQueries("select * FROM Dealer where MemberNo = '" + textBox64.Text + "'"); if (ds.Tables[0].Rows.Count > 0) { textBox63.Text = ds.Tables[0].Rows[0]["DNAME"].ToString(); DEALERID = Int32.Parse(ds.Tables[0].Rows[0]["DEALERID"].ToString()); dsAmer2 = sqlhelper.ExecuteQueries("select * FROM CREDITCHECK where MemberNo = '" + textBox64.Text + "'"); textBox62.Text = dsAmer2.Tables[0].Rows[0]["DUE"].ToString(); } else { FrmMessage.Show("No Records Found"); } } else { } } catch (Exception) { } }
private void btnClear_Click(object sender, EventArgs e) { if (btnClear.Text == "Clear") { clear(); } else { bool result; int count; sqlhelp = new SQLHelper(); count = int.Parse(sqlhelp.ExecuteScalar("select count(*) from Expenses where ExpTypeID= " + ExpTypeID + "")); if (count == 0) { if (DialogResult.OK == FrmMessage.Show("Are you Sure. You want to Delete this ExpenseType ?", caption, OkCancelButton, QuestionIcon)) { result = sqlhelp.ExecuteNonQuery("delete from ExpenseTypes where ExpTypeID=" + ExpTypeID + ""); if (result == true) { FrmMessage.Show("ExpenseType Deleted Successfully", caption, OkButton, InformationIcon); btnClear.Text = "Clear"; btnSave.Text = "Add"; btnTbSearch_Click(sender, e); } } } else { FrmMessage.Show("You Cannnot Delete this Category. First Delete the Items of this Category", caption, OkButton, InformationIcon); btnClear.Text = "Clear"; btnSave.Text = "Add"; btnTbSearch_Click(sender, e); } } }
private void btnAddRacks_Click_1(object sender, EventArgs e) { bool result = false; if (string.IsNullOrEmpty(textBox1.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (btnSave.Text == "Add") { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into RACKPOSITION(RNO,ITEMID,SELFPOSITION,CreatedBy) values" + "(" + comboBox3.SelectedValue + "," + comboBox5.SelectedValue + ",'" + textBox1.Text + "'," + GlobalData.UserID + ")"); } else { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("UPDATE RACKPOSITION SET ITEMID='" + comboBox5.SelectedValue + "', SELFPOSITION='" + textBox1.Text + "' where " + "RPNO=" + RPNO + ""); } if (result == true) { FrmMessage.Show("Transaction Success"); btnTbSearch_Click(sender, e); Cat_ItemGrid.DataSource = null; Cat_ItemGrid.Columns.Clear(); } } }
private void btnSearch_Click(object sender, EventArgs e) { try { ServicesGrid.DataSource = null; ServicesGrid.Columns.Clear(); ServicesGrid.Visible = true; DataTable dt = new DataTable(); dt = sqlhelp.ExecuteTables("select ServiceID,ServiceName,ServiceCharge,Description,[Image] from Services where ServiceName like'" + txtServiceName.Text.Trim() + "%'"); if (dt.Rows.Count > 0) { ServicesGrid.DataSource = dt; ServicesGrid.Columns["ServiceID"].Visible = false; ServicesGrid.Columns["Image"].Visible = false; } else { FrmMessage.Show("No Records Found !!"); } } catch (Exception ex) { } finally { } }
private void StockGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { stockId = int.Parse(StockGrid.CurrentRow.Cells["POID"].Value.ToString()); string wherecondition = "CategoryID like " + ddlSrchCategory.SelectedValue + "" + " and SupplierID like " + ddlsrchSupp.SelectedValue + " and POID Like '" + stockId + "'"; ds = sqlhelp.ExecuteQueries("Select * from ItemSplit where " + wherecondition + ""); if (ds.Tables[0].Rows.Count > 0) { FrmMessage.Show("This Item Has Already Splited, You Can not split this item Again !!"); } else { stockId = int.Parse(StockGrid.CurrentRow.Cells["POID"].Value.ToString()); stockId1 = int.Parse(StockGrid.CurrentRow.Cells["SupplierID"].Value.ToString()); stockId2 = int.Parse(StockGrid.CurrentRow.Cells["CategoryID"].Value.ToString()); txtSrchBarcode.Text = StockGrid.CurrentRow.Cells["ItemName"].Value.ToString(); textBox1.Text = StockGrid.CurrentRow.Cells["QTY"].Value.ToString(); textBox5.Text = StockGrid.CurrentRow.Cells["QtyType"].Value.ToString(); } } }
private void btnSave_Click(object sender, EventArgs e) { bool result = false; if (string.IsNullOrEmpty(txtExpAmount.Text) || string.IsNullOrEmpty(textBox1.Text)) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (btnSave.Text == "Add") { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("insert into PCardPointSetting(PerPointAmount, Points,RedeemPoints, RedeemAmount,CreatedBy) values" + "('" + txtExpAmount.Text + "','" + textBox1.Text + "'," + textBox2.Text + "," + textBox3.Text + "," + GlobalData.UserID + ")"); } else { sqlhelp = new SQLHelper(); result = sqlhelp.ExecuteNonQuery("UPDATE PCardPointSetting SET PerPointAmount='" + txtExpAmount.Text + "',Points='" + textBox1.Text + "',RedeemPoints=" + textBox2.Text + ",RedeemAmount=" + textBox3.Text + " where " + "PCSNo=" + PSNo + ""); } if (result == true) { FrmMessage.Show("Transaction Success"); btnTbSearch_Click(sender, e); Cat_ItemGrid.DataSource = null; Cat_ItemGrid.Columns.Clear(); } } }
private void btnaddcategory_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtnewCategory.Text.Trim())) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (btnaddcategory.Text == "Add") { Result = sqlhelp.ExecuteNonQuery("insert into Categories (CategoryName,CategoryDescription,Createdby) " + "values('" + txtnewCategory.Text.Trim() + "','" + rtbDescCategory.Text + "'," + GlobalData.UserID + ")"); if (Result == true) { FrmMessage.Show("Category Added successfully", caption, OkButton, InformationIcon); fillSearchCategory(); ClearCategoryTextBoxes(); } } else { Result = sqlhelp.ExecuteNonQuery("Update Categories Set CategoryName = '" + txtnewCategory.Text + "'," + "CategoryDescription='" + rtbDescCategory.Text + "',UpdatedBy=" + GlobalData.UserID + "" + " where CategoryID= " + CatID + ""); if (Result == true) { FrmMessage.Show("Category Updated successfully", caption, OkButton, InformationIcon); fillSearchCategory(); btnTbSearch_Click(sender, e); } } } }
private void btnClear_Click(object sender, EventArgs e) { if (btnClear.Text == "Clear") { ClearTextboxes(); } else if (btnClear.Text == "DeActivate") { if (DialogResult.Yes == FrmMessage.Show("Are You Sure You want to Deactivate", caption, YesNoButton, QuestionIcon)) { if (EmpId == 1) { FrmMessage.Show("You can't De-activate the Main Admin User !!!", caption, OkButton, InformationIcon); } else if (EmpId != 1) { if (int.Parse(GlobalData.UserID) == EmpId) { FrmMessage.Show("You can't De-activate the loggedin User !!!", caption, OkButton, InformationIcon); } else { sqlhelp = new SQLHelper(); bool result = sqlhelp.ExecuteNonQuery("Update Users set IsActive=False where UserID= " + EmpId + ""); if (result == true) { FrmMessage.Show("Deactivated the user Successfully !!", caption, OkButton, InformationIcon); } } } } SearchGroup.Visible = true; AddGroup.Visible = false; btnTbAdd.Text = "Add"; EmpGrid.Visible = false; txtSrchName.Text = string.Empty; //SrchddlRole.SelectedIndex = 0; } else if (btnClear.Text == "Activate") { sqlhelp = new SQLHelper(); bool result = sqlhelp.ExecuteNonQuery("Update Users set IsActive=True where UserID= " + EmpId + ""); if (result == true) { FrmMessage.Show("Activated the user Successfully", caption, OkButton, InformationIcon); } SearchGroup.Visible = true; AddGroup.Visible = false; btnTbAdd.Text = "Add"; EmpGrid.Visible = false; txtSrchName.Text = string.Empty; //SrchddlRole.SelectedIndex = 0; } }
private void button3_Click(object sender, EventArgs e) { textBox7.Text = "0"; try { searchid = 0; StockGrid.Visible = true; ds = new DataSet(); StockGrid.DataSource = null; StockGrid.Columns.Clear(); sqlhelp = new SQLHelper(); string srchBarcode = ""; //string wherecondition = "ItemName Like '" + textBox6.Text + "'"; string wherecondition = "CategoryID like " + ddlSrchCategory.SelectedValue + "" + " and SupplierID like " + ddlsrchSupp.SelectedValue + " and ItemName Like '" + textBox6.Text + "'"; ds = sqlhelp.ExecuteQueries("Select * from SupplierOrder where " + wherecondition + ""); if (ds.Tables[0].Rows.Count > 0) { StockGrid.DataSource = ds.Tables[0]; StockGrid.Columns["POID"].Visible = false; StockGrid.Columns["CategoryID"].Visible = false; StockGrid.Columns["SupplierID"].Visible = false; StockGrid.Columns["ReceivedDate"].Visible = false; StockGrid.Columns["TotalAmount"].Visible = false; DataGridViewButtonColumn btnUpdate = new DataGridViewButtonColumn(); btnUpdate.HeaderText = "Split Quantity"; btnUpdate.Text = "Split Quantity"; btnUpdate.UseColumnTextForButtonValue = true; btnUpdate.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; btnUpdate.FlatStyle = FlatStyle.Standard; btnUpdate.CellTemplate.Style.BackColor = Color.Honeydew; StockGrid.Columns.Add(btnUpdate); } else { StockGrid.DataSource = ds.Tables[0]; StockGrid.Columns["POID"].Visible = false; StockGrid.Columns["CategoryID"].Visible = false; StockGrid.Columns["SupplierID"].Visible = false; FrmMessage.Show("No records Found!!!", caption, OkButton, InformationIcon); } } catch (Exception ex) { } finally { } }
private void button1_Click(object sender, EventArgs e) { try { if (dataGridView1.Rows.Count == 0 || dataGridView2.Rows.Count == 0) { FrmMessage.Show("No items were selected for return."); } else if (string.IsNullOrEmpty(textBox1.Text.Trim())) { FrmMessage.Show("Please Enter the reason for return."); } else { if (DialogResult.Yes == FrmMessage.Show("Are You Sure You want to return these items to Supplier.", caption, YesNoButton, QuestionIcon)) { bool result = false; for (int i = 0; i < dataGridView2.Rows.Count; i++) { result = sqlhelp.ExecuteNonQuery("insert into RETURNITEMSTOSUPPLIER (POID,SUPPLIERID,CATEGORYID,ITEMNAME,RETURNQTY,ITEMPRICE,TOTALAMOUNT,Reason,CREATEDBY) Values " + "(" + dataGridView2.Rows[i].Cells["POID"].Value.ToString() + "," + dataGridView2.Rows[i].Cells["SupplierID"].Value.ToString() + "," + dataGridView2.Rows[i].Cells["CategoryID"].Value.ToString() + "," + "'" + dataGridView2.Rows[i].Cells["ItemName"].Value.ToString() + "'," + dataGridView2.Rows[i].Cells["Qty"].Value.ToString() + "," + "" + dataGridView2.Rows[i].Cells["UnitPrice"].Value.ToString() + "," + dataGridView2.Rows[i].Cells["AfterVat"].Value.ToString() + ",'" + textBox1.Text.Trim() + "'," + GlobalData.UserID + ")"); result = sqlhelp.ExecuteNonQuery("update SupplierOrder set Qty= (Qty-" + dataGridView2.Rows[i].Cells["Qty"].Value + "),TotalAmount = (TotalAmount-" + dataGridView2.Rows[i].Cells["BeforeVat"].Value + ")" + " where SUPPLIERID=" + dataGridView2.Rows[i].Cells["SupplierID"].Value.ToString() + " and CATEGORYID=" + dataGridView2.Rows[i].Cells["CategoryID"].Value.ToString() + "" + " and POID=" + dataGridView2.Rows[i].Cells["POID"].Value.ToString() + " and ItemName='" + dataGridView2.Rows[i].Cells["ItemName"].Value.ToString() + "'"); } if (result == true) { FrmMessage.Show("Returned Items to Supplier Successfully Make Sure you Return the Items from Stock for this Item !!"); ReturnToSupplier form = new ReturnToSupplier { MdiParent = this.MdiParent, Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))), Dock = DockStyle.Fill }; form.Show(); } } } } catch (Exception ex) { } finally { } }
private void btnSave_Click(object sender, EventArgs e) { try { if (ReturnGrid.Rows.Count == 0 || TransGrid.Rows.Count == 0) { FrmMessage.Show("No items were selected for return."); } else if (string.IsNullOrEmpty(txtReason.Text.Trim())) { FrmMessage.Show("Please Enter the reason for return."); } else { if (DialogResult.Yes == FrmMessage.Show("Are You Sure You want to return these items.", caption, YesNoButton, QuestionIcon)) { bool result = false; for (int i = 0; i < ReturnGrid.Rows.Count; i++) { result = sqlhelp.ExecuteNonQuery("insert into RETURNTOSUPPLIER (StockID,SUPPLIERID,CATEGORYID,ITEMID,Barcode,RETURNQTY,ITEMPRICE,TOTALAMOUNT,Reason,CREATEDBY) Values " + "(" + ReturnGrid.Rows[i].Cells["StockID"].Value.ToString() + "," + ReturnGrid.Rows[i].Cells["SupplierID"].Value.ToString() + "," + ReturnGrid.Rows[i].Cells["CategoryID"].Value.ToString() + "," + "" + ReturnGrid.Rows[i].Cells["ItemID"].Value.ToString() + ",'" + ReturnGrid.Rows[i].Cells["Barcode"].Value.ToString() + "'," + ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString() + "," + "" + ReturnGrid.Rows[i].Cells["Item Price"].Value.ToString() + "," + ReturnGrid.Rows[i].Cells["Total Amount"].Value.ToString() + ",'" + txtReason.Text.Trim() + "'," + GlobalData.UserID + ")"); result = sqlhelp.ExecuteNonQuery("update Stock set StockQuantity= (StockQuantity-" + int.Parse(ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString()) + ")" + " where SUPPLIERID=" + ReturnGrid.Rows[i].Cells["SupplierID"].Value.ToString() + " and CATEGORYID=" + ReturnGrid.Rows[i].Cells["CategoryID"].Value.ToString() + "" + " and ITEMID=" + ReturnGrid.Rows[i].Cells["ItemID"].Value.ToString() + " and StockID=" + ReturnGrid.Rows[i].Cells["StockID"].Value.ToString() + ""); } if (result == true) { FrmMessage.Show("Returned Items to Supplier Successfully"); ReturnToSupplier form = new ReturnToSupplier { MdiParent = this.MdiParent, Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))), Dock = DockStyle.Fill }; form.Show(); } } } } catch (Exception ex) { } finally { } }
private void dataGridView2_CellValueChanged(object sender, DataGridViewCellEventArgs e) { try { for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView2.CurrentRow.Cells["POID"].Value.ToString() == dataGridView1.Rows[i].Cells["POID"].Value.ToString()) { if (!string.IsNullOrEmpty(dataGridView2.CurrentRow.Cells["Qty"].Value.ToString())) { if (double.Parse(dataGridView2.CurrentRow.Cells["Qty"].Value.ToString()) > double.Parse(dataGridView1.Rows[i].Cells["Qty"].Value.ToString()) || int.Parse(dataGridView2.CurrentRow.Cells["Qty"].Value.ToString()) == 0) { FrmMessage.Show("Quanity should be between 1 and max quantity " + dataGridView1.Rows[i].Cells["Qty"].Value.ToString()); dataGridView2.CurrentRow.Cells["Qty"].Value = dataGridView1.Rows[i].Cells["Qty"].Value.ToString(); break; } else { dataGridView2.CurrentRow.Cells["AfterVat"].Value = "" + Math.Round((decimal.Parse(dataGridView2.CurrentRow.Cells["Qty"].Value.ToString()) * (decimal.Parse(dataGridView2.CurrentRow.Cells["UnitPrice"].Value.ToString()))) + ((decimal.Parse(dataGridView2.CurrentRow.Cells["Qty"].Value.ToString()) * (decimal.Parse(dataGridView2.CurrentRow.Cells["UnitPrice"].Value.ToString()))) * (decimal.Parse(dataGridView2.CurrentRow.Cells["vat%"].Value.ToString()) / 100)), 2).ToString(); dataGridView2.CurrentRow.Cells["BeforeVat"].Value = "" + Math.Round((decimal.Parse(dataGridView2.CurrentRow.Cells["Qty"].Value.ToString()) * (decimal.Parse(dataGridView2.CurrentRow.Cells["UnitPrice"].Value.ToString()))), 2).ToString(); break; } } else { dataGridView2.CurrentRow.Cells["Qty"].Value = dataGridView1.Rows[i].Cells["Qty"].Value.ToString(); break; } } } decimal TotalRefund = 0; TotalActualAmount = 0; for (int k = 0; k < (dataGridView2.Rows.Count); k++) { //decimal afterdiscountamount = Math.Round(((decimal.Parse(dataGridView1.Rows[k].Cells[3].Value.ToString()) / 100) * (decimal.Parse(dataGridView1.Rows[k].Cells[1].Value.ToString()))), 2); TotalRefund = Math.Round((TotalRefund + (decimal.Parse(dataGridView2.Rows[k].Cells["AfterVat"].Value.ToString()))), 2); TotalActualAmount = Math.Round((TotalActualAmount + (decimal.Parse(dataGridView2.Rows[k].Cells["Qty"].Value.ToString()) * decimal.Parse(dataGridView2.Rows[k].Cells["UnitPrice"].Value.ToString()))), 2); } textBox2.Text = TotalRefund.ToString(); } catch (Exception ex) { } finally { } }
private void button1_Click_1(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtSrchBarcode.Text.Trim()) || string.IsNullOrEmpty(textBox2.Text.Trim()) || string.IsNullOrEmpty(textBox2.Text.Trim())) { FrmMessage.Show("Fields with * Symbols are Mandatory!!!", caption, OkButton, ErrorIcon); } else { if (dtStockList.Columns.Count == 0) { dtStockList.Columns.Add("Item Name"); dtStockList.Columns.Add("Packs"); dtStockList.Columns.Add("Weight"); dtStockList.Columns.Add("Total Weight"); } bool AlreadyAddedd = false; foreach (DataRow dr in dtStockList.Rows) { if (dr["Weight"].ToString() == textBox3.Text.Trim()) { AlreadyAddedd = true; } } if (AlreadyAddedd == true) { FrmMessage.Show("This Weight is already added to list for the selected Item"); } else { dtStockList.Rows.Add(txtSrchBarcode.Text.Trim(), textBox2.Text.Trim(), textBox3.Text, textBox4.Text.Trim()); dtStockList.AcceptChanges(); GridStockPurchase.DataSource = dtStockList; decimal pric = 0; decimal vatAmount = 0; for (int k = 0; k < (GridStockPurchase.Rows.Count); k++) { GridStockPurchase.Columns[k].SortMode = DataGridViewColumnSortMode.NotSortable; //pric = Math.Round((pric + (decimal.Parse(GridStockPurchase.Rows[k].Cells["Total"].Value.ToString()))), 2); //vatAmount = Math.Round((vatAmount + (decimal.Parse(GridStockPurchase.Rows[k].Cells["Total"].Value.ToString())) * (decimal.Parse(GridStockPurchase.Rows[k].Cells["Vat %"].Value.ToString()) / 100)), 2); } //txtVatAmount.Text = vatAmount.ToString(); //txtSubTotal.Text = pric.ToString(); //clear(); textBox2.Text = "0"; textBox3.Text = "0"; } } }
private void ShowStock() { if (dataGridView4.SelectedRows.Count > 0) { dataGridView4.SelectedRows[0].Cells["Barcode"].Value.ToString(); DataSet dsstk = new DataSet(); SQLHelper sqlh = new SQLHelper(); dsstk = sqlh.ExecuteQueries("select * from GetItemsForCashier where barcode='" + dataGridView4.SelectedRows[0].Cells["Barcode"].Value.ToString() + "'"); if (dsstk.Tables[0].Rows.Count > 0) { FrmMessage.Show("Avail Quantity " + Convert.ToDecimal(dsstk.Tables[0].Rows[0]["StockQuantity"].ToString())); } } }
private void ReturnGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e) { try { for (int i = 0; i < TransGrid.Rows.Count; i++) { if (ReturnGrid.CurrentRow.Cells["StockID"].Value.ToString() == TransGrid.Rows[i].Cells["StockID"].Value.ToString()) { if (!string.IsNullOrEmpty(ReturnGrid.CurrentRow.Cells["Quantity"].Value.ToString())) { if (double.Parse(ReturnGrid.CurrentRow.Cells["Quantity"].Value.ToString()) > double.Parse(TransGrid.Rows[i].Cells["Quantity"].Value.ToString()) || int.Parse(ReturnGrid.CurrentRow.Cells["Quantity"].Value.ToString()) == 0) { FrmMessage.Show("Quanity should be between 1 and max quantity " + TransGrid.Rows[i].Cells["Quantity"].Value.ToString()); ReturnGrid.CurrentRow.Cells["Quantity"].Value = TransGrid.Rows[i].Cells["Quantity"].Value.ToString(); break; } else { ReturnGrid.CurrentRow.Cells["Total Amount"].Value = "" + Math.Round((decimal.Parse(ReturnGrid.CurrentRow.Cells["Quantity"].Value.ToString()) * (decimal.Parse(ReturnGrid.CurrentRow.Cells["Item Price"].Value.ToString()))), 2).ToString(); break; } } else { ReturnGrid.CurrentRow.Cells["Quantity"].Value = TransGrid.Rows[i].Cells["Available Quantity"].Value.ToString(); break; } } } decimal TotalRefund = 0; TotalActualAmount = 0; for (int k = 0; k < (ReturnGrid.Rows.Count); k++) { //decimal afterdiscountamount = Math.Round(((decimal.Parse(dataGridView1.Rows[k].Cells[3].Value.ToString()) / 100) * (decimal.Parse(dataGridView1.Rows[k].Cells[1].Value.ToString()))), 2); TotalRefund = Math.Round((TotalRefund + (decimal.Parse(ReturnGrid.Rows[k].Cells["Total Amount"].Value.ToString()))), 2); TotalActualAmount = Math.Round((TotalActualAmount + (decimal.Parse(ReturnGrid.Rows[k].Cells["Quantity"].Value.ToString()) * decimal.Parse(ReturnGrid.Rows[k].Cells["Item Price"].Value.ToString()))), 2); } txtTotalRefund.Text = TotalRefund.ToString(); } catch (Exception ex) { } finally { } }
private void btnSrchItems_Click(object sender, EventArgs e) { try { dtTran = new DataTable(); dtTran1 = new DataTable(); dtTran = sqlhelp.ExecuteTables("Select GS.*,(SH.InvoiceAmount/SH.Qty) as [ItemPrice] from GetStock GS, StockHistory SH where GS.StockID=SH.StockID and GS.SupplierID like'" + ddlsrchsupp.SelectedValue + "' and GS.CategoryID like'" + ddlSrchCat.SelectedValue + "' and GS.ItemID like'" + ddlsrchitem.SelectedValue + "'"); if (dtTran.Rows.Count > 0) { dtTran1 = sqlhelp.ExecuteTables("Select * from ItemSplit where SupplierID like'" + ddlsrchsupp.SelectedValue + "' and CategoryID like'" + ddlSrchCat.SelectedValue + "' and ItemName ='" + ddlsrchitem.Text + "'"); if (dtTran1.Rows.Count > 0) { FrmMessage.Show("You can not return this Item, Beacuse This Item Has Splited to lesser Qty !!!"); } else { TransGrid.DataSource = dtTran; TransGrid.Columns["ItemPrice"].HeaderText = "Item Price"; TransGrid.Columns["StockID"].Visible = false; TransGrid.Columns["SupplierID"].Visible = false; TransGrid.Columns["ItemID"].Visible = false; TransGrid.Columns["CategoryID"].Visible = false; TransGrid.Columns["ImageName"].Visible = false; TransGrid.Columns["ReOrder Qty"].Visible = false; TransGrid.Columns["StockDescription"].Visible = false; } } else { FrmMessage.Show("No Records Found !!!"); ReturnToSupplier rtnStock = new ReturnToSupplier { MdiParent = this, Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))), Dock = DockStyle.Fill }; rtnStock.Show(); } } catch (Exception ex) { } finally { } }
private void btnClearSup_Click(object sender, EventArgs e) { try { if (btnClearSup.Text == "Clear") { txtaddress.Text = string.Empty; txtSupName.Text = string.Empty; txtSupPhone.Text = string.Empty; txtSupName.Text = string.Empty; textBox2.Text = string.Empty; //cmbSTKcategories.SelectedValue = 1; txtSupPhone.Text = string.Empty; textBox1.Text = string.Empty; textBox3.Text = string.Empty; txtaddress.Text = string.Empty; textBox5.Text = string.Empty; textBox6.Text = string.Empty; textBox4.Text = string.Empty; textBox7.Text = string.Empty; textBox8.Text = string.Empty; textBox9.Text = string.Empty; textBox10.Text = string.Empty; textBox11.Text = string.Empty; textBox12.Text = string.Empty; textBox13.Text = string.Empty; } else { int count = int.Parse(sqlhelp.ExecuteScalar("select count(*) from Items where SupplierID= " + SupplierID + "")); if (count == 0) { if (DialogResult.Yes == FrmMessage.Show("Are you Sure. You want to Delete this Supplier ?", caption, YesNoButton, QuestionIcon)) { bool result = sqlhelp.ExecuteNonQuery("delete from Supplier where SupplierID=" + SupplierID + ""); } } else { FrmMessage.Show("You Cannot Delete this Supplier. First Delete the Items of this Supplier from Stock", caption, OkButton, InformationIcon); } } } catch (Exception ex) { } finally { } }