protected void BtnUpdate_Click(object sender, EventArgs e) { string stockId = TbxStockID.Text; string reg = TbxRegNo.Text; string make = TbxMake.Text; string frameNo = TbxFrameNo.Text; string engineNo = TbxEngineNo.Text; string variant = TbxVariant.Text; string modelYear = TbxModelYear.Text; string color = TbxColor.Text; /// Drop down List string engineType = DdnEnginetype.Text; string transmissionType = DdnTransmissionType.Text; string powerWindow = DdnPowerWindow.Text; string powerLock = DdnPowerLock.Text; string ccontrol = DdnCruiseControl.Text; string aircondition = DdnAirCondition.Text; string radio = DdnRadio.Text; string player = DdnPlayer.Text; string sunroof = DdnSunRoof.Text; string wheelcover = DdnWheelCover.Text; string wheelChrome = DdnWheelChrome.Text; string wheelAluminium = DdnWheelAluminium.Text; string purchaseType = DdnType.Text; string others = TbxOther.Text; if (reg != "" && frameNo != "" && engineNo != "") { ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection sqlC = myConnection.getDatabaseConnection(); var myQuery = "UPDATE StockMaster SET RegNo = '" + reg + "', Make = '" + make + "', FrameNo = '" + frameNo + "', EngineNo = '" + engineNo + "',"; myQuery = myQuery + " Variant = '" + variant + "', ModelYear = '" + modelYear + "', Color = '" + color + "', EngineType = '" + engineType + "', TransmissionType = '" + transmissionType + "', PowerWindow = '" + powerWindow + "',"; myQuery = myQuery + "PowerLock = '" + powerLock + "', CruiseControl = '" + ccontrol + "', AirCondition = '" + aircondition + "', Radio ='" + radio + "', Player = '" + player + "',"; myQuery = myQuery + " Sunroof = '" + sunroof + "', Wheelcover = '" + wheelcover + "', WheelChrome = '" + wheelChrome + "', WheelAluminium = '" + wheelAluminium + "',Type = '" + purchaseType + "',"; myQuery = myQuery + "Other = '" + others + "' WHERE (StockId = " + stockId + ")"; SqlCommand saveInStockMaster = new SqlCommand(myQuery, sqlC); try { sqlC.Open(); saveInStockMaster.ExecuteNonQuery(); sqlC.Close(); } catch (Exception) { throw; } } else { string script = "alert(\" Must Enter Vehicle Registration No ,Engine No & Frame No !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
protected void Login(object sender, EventArgs e) { string email = TbxEmail.Text; string pass = TbxPass.Text; ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Select * from UserAccountDetails where emailAddress = '" + email + "' and Password = '******'"; SqlCommand loginCommand = new SqlCommand(Query, sc); try { sc.Open(); var count = loginCommand.ExecuteScalar(); if (count != null) { FlagsVariables.userId = email; Response.Redirect("HomePage.aspx"); } else { Response.Write("Karachi Motor does not recognize that credentails"); } } catch (Exception ex) { Response.Write("Karachi Motor does not recognize that credentails"); Response.Write(ex); } }
protected void btncheck(object sender, EventArgs e) { string email = TbxEmail.Text; string cellNo = TbxCellNo.Text; if (email != "" && cellNo != "") { ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Select * from UserAccountDetails where emailAddress = '" + email + "' and CellNumber = '" + cellNo + "'"; SqlCommand loginCommand = new SqlCommand(Query, sc); try { sc.Open(); var count = loginCommand.ExecuteScalar(); Response.Write(count); if (count != null) { //TbxConformPassword.Enabled = true; //TbxNewPassword.Enabled = true; //BtnSumit.Enabled = true; } else { Response.Write("Karachi Motor does not recognize that credentails"); } } catch (Exception ex) { Response.Write("Karachi Motor does not recognize that credentails"); Response.Write(ex); } } }
private void GetCustomerRecord(string tableName, string ColumnName, string Userinput) { if (Userinput != "") { ConnectionStringClass myConn = new ConnectionStringClass(); SqlConnection dbConnec = myConn.getDatabaseConnection(); string Query = "Select customerID,emailAddress,cellNo1,homeAddress,driverNo from " + tableName + " Where " + ColumnName + " = '" + Userinput + "'"; SqlCommand myCommand = new SqlCommand(Query, dbConnec); SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand); DataTable myTable = new DataTable(); try { dbConnec.Open(); myAdapter.Fill(myTable); var record = myCommand.ExecuteReader(); dbConnec.Close(); if (record != null) { TbxCustomerID.Text = myTable.Rows[0]["customerID"].ToString(); TbxEmail.Text = myTable.Rows[0]["emailAddress"].ToString(); TbxCellNo.Text = myTable.Rows[0]["cellNo1"].ToString(); TbxHomeAddress.Text = myTable.Rows[0]["homeAddress"].ToString(); TbxDriverNo.Text = myTable.Rows[0]["driverNo"].ToString(); } } catch (Exception ex) { Response.Write(ex); } } }
protected void Save_Event(object sender, EventArgs e) { string purchaseID = TbxPurchaseID.Text; string purchasePerson = TbxPurchasePerson.Text; string trade = ddnTrade.Text; string date = TbxDate.Text; string cnic = TbxCNIC.Text; string regNo = TbxRegNo.Text; string cName = TbxCustomerName.Text; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection dbConnection = myConnection.getDatabaseConnection(); string query = "insert into Purchase (purchaseID, purchasePerson, trade, date, cnic, regNo, customerName) values "; query += "('" + purchaseID + "', '" + purchasePerson + "', '" + trade + "', '" + date + "', '" + cnic + "', '" + regNo + "', '" + cName + "')"; SqlCommand myCommand = new SqlCommand(query, dbConnection); try { dbConnection.Open(); myCommand.ExecuteNonQuery(); dbConnection.Close(); } catch (Exception) { string script = "alert(\" Data Not save !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
private void GetStockMasterRecord(string tableName, string ColumnName, string Userinput) { if (Userinput != "") { ConnectionStringClass myConn = new ConnectionStringClass(); SqlConnection dbConnec = myConn.getDatabaseConnection(); string Query = "Select Stockid,Make,FrameNo,EngineNo,Variant, Other from " + tableName + " Where " + ColumnName + " = '" + Userinput + "'"; SqlCommand myCommand = new SqlCommand(Query, dbConnec); SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand); DataTable myTable = new DataTable(); try { dbConnec.Open(); myAdapter.Fill(myTable); var record = myCommand.ExecuteReader(); dbConnec.Close(); if (record != null) { TbxStockID.Text = myTable.Rows[0]["Stockid"].ToString(); TbxMake.Text = myTable.Rows[0]["Make"].ToString(); TbxFrameNo.Text = myTable.Rows[0]["FrameNo"].ToString(); TbxEngineNo.Text = myTable.Rows[0]["EngineNo"].ToString(); TbxVariant.Text = myTable.Rows[0]["Variant"].ToString(); TbxAmount.Text = myTable.Rows[0]["Other"].ToString(); } } catch (Exception ex) { Response.Write(ex); } } }
protected void Save_event(object sender, EventArgs e) { string saleid = TbxSaleID.Text; string saleperson = TbxSalePerson.Text; string trade = trade_DropDownList.Text; string date = TbxDate.Text; string cnic = TbxCNIC.Text; string regNo = TbxRegNo.Text; string cust_name = TbxCustomerName.Text; Int64 sal_amount = Convert.ToInt64(TbxSaleAmount.Text); if (sal_amount != 0 && trade != "") { ConnectionStringClass conn = new ConnectionStringClass(); SqlConnection dataConn = conn.getDatabaseConnection(); string query = "insert into sale (saleID, salePerson, trade, date, saleAmount, CNIC, RegNo,customerName) values"; query += "('" + saleid + "','" + saleperson + "','" + trade + "','" + date + "','" + sal_amount + "','" + cnic + "','" + regNo + "','" + cust_name + "')"; SqlCommand myCommand = new SqlCommand(query, dataConn); try { dataConn.Open(); myCommand.ExecuteNonQuery(); dataConn.Close(); } catch (Exception) { string script = "alert(\" Data Not save !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } }
protected void CreateAccount(object sender, EventArgs e) { string name = TbxFirstName.Text; string surname = TxtSurname.Text; string password = Txtpassword.Text; string email = TxtEmailAddress.Text; string homeAddress = TxthomeAddress.Text; string cellNo = Txtphoneno.Text; string dateOfBirth = DropDownDay.Text + "/" + DropDownMonth.Text + "/" + DropDownYear.Text; string gender = RdBtngender.Text; ConnectionStringClass myConnectionString = new ConnectionStringClass(); SqlConnection sqlC = myConnectionString.getDatabaseConnection(); String insertQuery = "insert into UserAccountDetails (firstName,surName,Password,emailAddress,homeAddress,CellNumber,dob,gender) Values ('" + name + "','" + surname + "','" + password + "','" + email + "','" + homeAddress + "','" + cellNo + "','" + dateOfBirth + "','" + gender + "')"; SqlCommand mycommand = new SqlCommand(insertQuery, sqlC); try { sqlC.Open(); mycommand.ExecuteNonQuery(); sqlC.Close(); FlagsVariables.accountCreate = true; Response.Redirect("LoginPage.aspx"); } catch (Exception ex) { Response.Write("data not save OK"); Response.Write(ex); } }
protected void deleteRecord(object sender, EventArgs e) { if (TbxRegNo.Text != "") { string deleteStockId = TbxStockID.Text; ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Delete StockMaster where StockID = '" + deleteStockId + "'"; SqlCommand deleteCommand = new SqlCommand(Query, sc); try { sc.Open(); deleteCommand.ExecuteNonQuery(); sc.Close(); } catch (Exception ex) { string script = "alert(\"Does Not Delete Sucessfully!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } else { string script = "alert(\"Do Not Delete Empty Record!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
protected void btnSubmit(object sender, EventArgs e) { string newPass = TbxNewPassword.Text; string conformPass = TbxConformPassword.Text; string email = TbxEmail.Text; string cellNo = TbxCellNo.Text; if (newPass != "" && conformPass != "") { ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Update UserAccountDetails Set Password = '******' where emailAddress = '" + email + "' and CellNumber = '" + cellNo + "'"; SqlCommand updateCommand = new SqlCommand(Query, sc); try { sc.Open(); updateCommand.ExecuteNonQuery(); sc.Close(); Response.Redirect("LoginPage.aspx"); } catch (Exception ex) { Response.Write(ex); } } }
protected void BtnSave(object sender, EventArgs e) { string stockId = TbxStockID.Text; string reg = TbxRegNo.Text; string make = TbxMake.Text; string frameNo = TbxFrameNo.Text; string engineNo = TbxEngineNo.Text; string variant = TbxVariant.Text; string modelYear = TbxModelYear.Text; string color = TbxColor.Text; /// Drop down List string engineType = DdnEnginetype.Text; string transmissionType = DdnTransmissionType.Text; string powerWindow = DdnPowerWindow.Text; string powerLock = DdnPowerLock.Text; string ccontrol = DdnCruiseControl.Text; string aircondition = DdnAirCondition.Text; string radio = DdnRadio.Text; string player = DdnPlayer.Text; string sunroof = DdnSunRoof.Text; string wheelcover = DdnWheelCover.Text; string wheelChrome = DdnWheelChrome.Text; string wheelAluminium = DdnWheelAluminium.Text; string purchaseType = DdnType.Text; string others = TbxOther.Text; if (reg != "" && frameNo != "" && engineNo != "") { ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection sqlC = myConnection.getDatabaseConnection(); String query = "insert into stockmaster (stockid,regno,make,frameno,engineno,variant,modelyear,color,enginetype,transmissiontype,powerwindow,powerlock,cruiseControl,aircondition,radio,player,sunroof,wheelcover,wheelchrome,wheelaluminium,type,other) values ('" + stockId + "', '" + reg + "','" + make + "','" + frameNo + "','" + engineNo + "','" + variant + "','" + modelYear + "',"; query += "'" + color + "','" + engineType + "','" + transmissionType + "','" + powerWindow + "','" + powerLock + "',"; query += "'" + ccontrol + "','" + aircondition + "','" + radio + "','" + player + "','" + sunroof + "',"; query += "'" + wheelcover + "','" + wheelChrome + "','" + wheelAluminium + "','" + purchaseType + "','" + others + "')"; SqlCommand saveInStockMaster = new SqlCommand(query, sqlC); try { sqlC.Open(); saveInStockMaster.ExecuteNonQuery(); sqlC.Close(); } catch (Exception) { throw; } } else { string script = "alert(\" Must Enter Vehicle Registration No ,Engine No & Frame No !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
private void getStockRecord(string searchBy, string columnName) { ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Select * from StockMaster where " + columnName + " = " + searchBy + ""; SqlCommand updateCommand = new SqlCommand(Query, sc); SqlDataAdapter myadapter = new SqlDataAdapter(updateCommand); DataTable myTable = new DataTable(); try { sc.Open(); var a = updateCommand.ExecuteScalar(); if (a != null) { myadapter.Fill(myTable); TbxStockID.Text = myTable.Rows[0]["StockID"].ToString(); TbxRegNo.Text = myTable.Rows[0]["RegNo"].ToString(); TbxMake.Text = myTable.Rows[0]["Make"].ToString(); TbxFrameNo.Text = myTable.Rows[0]["FrameNo"].ToString(); TbxEngineNo.Text = myTable.Rows[0]["EngineNo"].ToString(); TbxVariant.Text = myTable.Rows[0]["Variant"].ToString(); TbxModelYear.Text = myTable.Rows[0]["ModelYear"].ToString(); TbxColor.Text = myTable.Rows[0]["Color"].ToString(); DdnEnginetype.Text = myTable.Rows[0]["EngineType"].ToString(); DdnTransmissionType.Text = myTable.Rows[0]["TransmissionType"].ToString(); DdnPowerWindow.Text = myTable.Rows[0]["PowerWindow"].ToString(); DdnPowerLock.Text = myTable.Rows[0]["PowerLock"].ToString(); DdnCruiseControl.Text = myTable.Rows[0]["CruiseControl"].ToString(); DdnAirCondition.Text = myTable.Rows[0]["AirCondition"].ToString(); DdnRadio.Text = myTable.Rows[0]["Radio"].ToString(); DdnPlayer.Text = myTable.Rows[0]["Player"].ToString(); DdnSunRoof.Text = myTable.Rows[0]["SunRoof"].ToString(); DdnWheelCover.Text = myTable.Rows[0]["WheelCover"].ToString(); DdnWheelChrome.Text = myTable.Rows[0]["WheelChrome"].ToString(); DdnwheelAluminum.Text = myTable.Rows[0]["WheelAluminium"].ToString(); DdnType.Text = myTable.Rows[0]["type"].ToString(); TbxOther.Text = myTable.Rows[0]["Other"].ToString(); } else { string script = "alert(\"Record Does Not Exist !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } sc.Close(); } catch (Exception) { throw; } }
protected void BtnSearch_Click(object sender, EventArgs e) { string searchCustomerID = TbxSearchCustomerID.Text; ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Select * from CustomerMaster where customerID = '" + searchCustomerID + "'"; SqlCommand updateCommand = new SqlCommand(Query, sc); SqlDataAdapter myadapter = new SqlDataAdapter(updateCommand); DataTable myTable = new DataTable(); try { sc.Open(); var a = updateCommand.ExecuteScalar(); if (a != null) { myadapter.Fill(myTable); TbxCustomerId.Text = myTable.Rows[0]["customerID"].ToString(); TbxCustomerName.Text = myTable.Rows[0]["customerName"].ToString(); TbxFatherName.Text = myTable.Rows[0]["fatherName"].ToString(); TbxCNIC.Text = myTable.Rows[0]["cNIC"].ToString(); TbxHPASales.Text = myTable.Rows[0]["hPASales"].ToString(); TbxResidentialNo.Text = myTable.Rows[0]["residentialNo"].ToString(); TbxOfficeNo.Text = myTable.Rows[0]["officeNo"].ToString(); TbxCellNo1.Text = myTable.Rows[0]["cellNo1"].ToString(); TbxDriverNo.Text = myTable.Rows[0]["driverNo"].ToString(); TbxEmailAddress.Text = myTable.Rows[0]["emailAddress"].ToString(); TbxHomeAddress.Text = myTable.Rows[0]["homeAddress"].ToString(); TbxNTNNo.Text = myTable.Rows[0]["nTNNo"].ToString(); TbxRecdoveryBy.Text = myTable.Rows[0]["recoveryBy"].ToString(); TbxUpdatedBy.Text = myTable.Rows[0]["UpdatedBy"].ToString(); TbxInsertedBy.Text = myTable.Rows[0]["insertedBy"].ToString(); TbxDOB.Text = myTable.Rows[0]["DOB"].ToString(); } else { string script = "alert(\"Record Does Not Exist !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } sc.Close(); } catch (Exception) { throw; } }
protected void BtnSave(object sender, EventArgs e) { string customer = TbxCustomerId.Text; string customerName = TbxCustomerName.Text; string fatherName = TbxFatherName.Text; string dOB = TbxDOB.Text; string cNIC = TbxCNIC.Text; string hPASales = TbxHPASales.Text; string residentialNo = TbxResidentialNo.Text; string officeNo = TbxOfficeNo.Text; string cellNo1 = TbxCellNo1.Text; string driverNo = TbxDriverNo.Text; string emailAddress = TbxEmailAddress.Text; string homeAddress = TbxHomeAddress.Text; string nTNNo = TbxNTNNo.Text; string customerType = DdnListCustomerType.Text; string recoveryBy = TbxRecdoveryBy.Text; string insertedBy = TbxInsertedBy.Text; string UpdatedBy = TbxUpdatedBy.Text; string DOB = TbxDOB.Text; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection sqlC = myConnection.getDatabaseConnection(); string insertQuery = "insert into CustomerMaster (customerID,CustomerName, fatherName, cNIC, hPASales, residentialNo, officeNo, cellNo1, driverNo, emailAddress, homeAddress, nTNNo, customerType, recoveryBy, insertedBy, UpdatedBy, DOB) Values ( '" + customer + "','" + customerName + "', '" + fatherName + "', '" + cNIC + "', '" + hPASales + "', '" + residentialNo + "', '" + officeNo + "', '" + cellNo1 + "', '" + driverNo + "', '" + emailAddress + "','" + homeAddress + "', '" + nTNNo + "', '" + customerType + "', '" + insertedBy + "', '" + UpdatedBy + "' ,'" + UpdatedBy + "' , '" + DOB + "')"; SqlCommand mycommand = new SqlCommand(insertQuery, sqlC); try { sqlC.Open(); var a = mycommand.ExecuteNonQuery(); // Response.Write(a); sqlC.Close(); } catch (Exception ex) { string script = "alert(\"Data Failed to Save!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
private int GetSaleID() { int Sale = 0; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection Sqlconnection = myConnection.getDatabaseConnection(); String Query = "Select saleID from Sale order by saleID desc "; SqlCommand GetIDCommand = new SqlCommand(Query, Sqlconnection); try { Sqlconnection.Open(); int id = Convert.ToInt32(GetIDCommand.ExecuteScalar()) + 1; Sale = id; Sqlconnection.Close(); } catch (Exception) { throw; } return(Sale); }
private int GetPurchaseID() { int Purchase = 0; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection dbconnection = myConnection.getDatabaseConnection(); string query = "Select purchaseID from Purchase order by purchaseID desc"; SqlCommand GetIDCommand = new SqlCommand(query, dbconnection); try { dbconnection.Open(); int id = Convert.ToInt32(GetIDCommand.ExecuteScalar()) + 1; Purchase = id; dbconnection.Close(); } catch (Exception) { throw; } return(Purchase); }
protected void BtnDelete(object sender, EventArgs e) { string deleteCustomerID = TbxCustomerId.Text; ConnectionStringClass connectionString = new ConnectionStringClass(); SqlConnection sc = connectionString.getDatabaseConnection(); string Query = "Delete CustomerMaster where customerID = '" + deleteCustomerID + "'"; SqlCommand deleteCommand = new SqlCommand(Query, sc); try { sc.Open(); deleteCommand.ExecuteNonQuery(); sc.Close(); } catch (Exception ex) { string script = "alert(\"Does Not Delete Sucessfully!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
private void GetSaleRecord(string tableName, string ColumnName, string Userinput) { if (Userinput != "") { ConnectionStringClass myConn = new ConnectionStringClass(); SqlConnection dbConnec = myConn.getDatabaseConnection(); string Query = "Select * from " + tableName + " Where " + ColumnName + " = '" + Userinput + "'"; SqlCommand myCommand = new SqlCommand(Query, dbConnec); SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand); DataTable myTable = new DataTable(); try { dbConnec.Open(); myAdapter.Fill(myTable); var record = myCommand.ExecuteScalar(); dbConnec.Close(); if (record != null) { TbxSaleID.Text = myTable.Rows[0]["saleID"].ToString(); TbxSalePerson.Text = myTable.Rows[0]["SalePerson"].ToString(); trade_DropDownList.Text = myTable.Rows[0]["trade"].ToString(); TbxDate.Text = myTable.Rows[0]["date"].ToString(); TbxSaleAmount.Text = myTable.Rows[0]["saleAmount"].ToString(); TbxCNIC.Text = myTable.Rows[0]["CNIC"].ToString(); TbxRegNo.Text = myTable.Rows[0]["RegNo"].ToString(); TbxCustomerName.Text = myTable.Rows[0]["customerName"].ToString(); this.GetCustomerRecord("CustomerMaster", "cNIC", TbxCNIC.Text); this.GetStockMasterRecord("StockMaster", "RegNo", TbxRegNo.Text); } } catch (Exception ex) { Response.Write(ex); } } }
private void GetStockData(string TableName, string columnName, string desiredValue) { string regNo = TbxRegNo.Text; ConnectionStringClass myConnecion = new ConnectionStringClass(); SqlConnection dbConnection = myConnecion.getDatabaseConnection(); string query = "Select StockID, Make, FrameNo, EngineNo, Variant, Other from " + TableName + " Where " + columnName + " = '" + desiredValue + "'"; SqlCommand myCommand = new SqlCommand(query, dbConnection); SqlDataAdapter myAdaptor = new SqlDataAdapter(myCommand); DataTable mytable = new DataTable(); try { myAdaptor.Fill(mytable); dbConnection.Open(); var record = myCommand.ExecuteScalar(); if (record != null) { TbxStockID.Text = mytable.Rows[0]["StockID"].ToString(); TbxMake.Text = mytable.Rows[0]["Make"].ToString(); TbxFrameNo.Text = mytable.Rows[0]["FrameNo"].ToString(); TbxEngineNo.Text = mytable.Rows[0]["EngineNo"].ToString(); TbxVariant.Text = mytable.Rows[0]["Variant"].ToString(); TbxAmount.Text = mytable.Rows[0]["Other"].ToString(); } else { string script = "alert(\" Stock Not Found !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } dbConnection.Close(); } catch (Exception) { throw; } }
protected void BtnUpdate(object sender, EventArgs e) { string customerId = TbxCustomerId.Text; string customerName = TbxCustomerName.Text; string fatherName = TbxFatherName.Text; string dOB = TbxDOB.Text; string cNIC = TbxCNIC.Text; string hPASales = TbxHPASales.Text; string residentialNo = TbxResidentialNo.Text; string officeNo = TbxOfficeNo.Text; string cellNo1 = TbxCellNo1.Text; string driverNo = TbxDriverNo.Text; string emailAddress = TbxEmailAddress.Text; string homeAddress = TbxHomeAddress.Text; string nTNNo = TbxNTNNo.Text; string customerType = DdnListCustomerType.Text; string recoveryBy = TbxRecdoveryBy.Text; string insertedBy = TbxInsertedBy.Text; string UpdatedBy = TbxUpdatedBy.Text; string DOB = TbxDOB.Text; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection sqlC = myConnection.getDatabaseConnection(); string insertQuery = "Update CustomerMaster SET customerID = '" + customerId + "' , CustomerName = '" + customerName + "', fatherName = '" + fatherName + "' , cNIC = '" + cNIC + "', hPASales = '" + hPASales + "', residentialNo = '" + residentialNo + "', officeNo = '" + officeNo + "' , cellNo1 = '" + cellNo1 + "', driverNo = '" + driverNo + "' , emailAddress = '" + emailAddress + "', homeAddress = '" + homeAddress + "' , nTNNo = '" + nTNNo + "' , customerType = '" + customerType + "' , recoveryBy = '" + recoveryBy + "', insertedBy = '" + insertedBy + "' , UpdatedBy = '" + UpdatedBy + "', DOB = '" + DOB + "' Where ( customerID = " + customerId + ")"; SqlCommand mycommand = new SqlCommand(insertQuery, sqlC); try { sqlC.Open(); mycommand.ExecuteNonQuery(); sqlC.Close(); } catch (Exception ex) { string script = "alert(\"Record Does Not Update Successfully!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
private void GetCustomerData(string TableName, string columnName, string desiredValue) { string cnic = TbxCNIC.Text; ConnectionStringClass myConnecion = new ConnectionStringClass(); SqlConnection dbConnection = myConnecion.getDatabaseConnection(); string query = "Select customerID, customerName, cellNo1, emailAddress, homeAddress, driverNo from " + TableName + " Where " + columnName + " = '" + desiredValue + "'"; SqlCommand myCommand = new SqlCommand(query, dbConnection); SqlDataAdapter myAdaptor = new SqlDataAdapter(myCommand); DataTable mytable = new DataTable(); try { myAdaptor.Fill(mytable); dbConnection.Open(); var record = myCommand.ExecuteScalar(); if (record != null) { TbxCustomerID.Text = mytable.Rows[0]["customerID"].ToString(); TbxCustomerName.Text = mytable.Rows[0]["customerName"].ToString(); TbxCellNo.Text = mytable.Rows[0]["cellNo1"].ToString(); TbxEmail.Text = mytable.Rows[0]["emailAddress"].ToString(); TbxHomeAddress.Text = mytable.Rows[0]["homeAddress"].ToString(); TbxDriverNo.Text = mytable.Rows[0]["driverNo"].ToString(); } else { string script = "alert(\" Customer Not Found !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } dbConnection.Close(); } catch (Exception) { throw; } }
protected void CNICTextChangeEvent(object sender, EventArgs e) { string CNIC = TbxCNIC.Text; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection myDataBaseConnection = myConnection.getDatabaseConnection(); string Query = " Select customerID, customerName, cellNo1, emailaddress, homeAddress, driverNo From CustomerMaster Where cNIC = '" + CNIC + "'"; SqlCommand myCommand = new SqlCommand(Query, myDataBaseConnection); SqlDataAdapter myAdaptor = new SqlDataAdapter(myCommand); DataTable datatable = new DataTable(); try { myDataBaseConnection.Open(); var record = myCommand.ExecuteScalar(); if (record != null) { myAdaptor.Fill(datatable); TbxCustomerID.Text = datatable.Rows[0]["customerID"].ToString(); TbxCustomerName.Text = datatable.Rows[0]["customerName"].ToString(); TbxEmail.Text = datatable.Rows[0]["emailAddress"].ToString(); TbxCellNo.Text = datatable.Rows[0]["cellNo1"].ToString(); TbxDriverNo.Text = datatable.Rows[0]["driverNo"].ToString(); TbxHomeAddress.Text = datatable.Rows[0]["homeAddress"].ToString(); myDataBaseConnection.Close(); } else { string script = "alert(\"Record Does Not Found !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } catch (Exception) { throw; } }
protected void RegistrationTextchangeEvent(object sender, EventArgs e) { string RegistrationNo = TbxRegNo.Text; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection myDBConnection = myConnection.getDatabaseConnection(); string Query = "Select StockID, Make, FrameNo, EngineNo, Variant, Other from StockMaster Where RegNo = '" + RegistrationNo + "' "; SqlCommand myCommand = new SqlCommand(Query, myDBConnection); SqlDataAdapter myAdaptor = new SqlDataAdapter(myCommand); DataTable datatable = new DataTable(); try { myDBConnection.Open(); var record = myCommand.ExecuteScalar(); if (record != null) { myAdaptor.Fill(datatable); TbxStockID.Text = datatable.Rows[0]["StockID"].ToString(); TbxMake.Text = datatable.Rows[0]["Make"].ToString(); TbxFrameNo.Text = datatable.Rows[0]["FrameNo"].ToString(); TbxEngineNo.Text = datatable.Rows[0]["EngineNo"].ToString(); TbxVariant.Text = datatable.Rows[0]["Variant"].ToString(); TbxAmount.Text = datatable.Rows[0]["Other"].ToString(); myDBConnection.Close(); } else { string script = "alert(\"Record Does Not Found !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } catch (Exception) { throw; } }
private void SaleRecord(string tableName, string ColumnName, string UserInput) { ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection dbConnection = myConnection.getDatabaseConnection(); string query = " Select purchaseID, cnic, regNo, purchasePerson, trade, date, customerName from " + tableName + " where " + ColumnName + " = '" + UserInput + "' "; SqlCommand mycommand = new SqlCommand(query, dbConnection); SqlDataAdapter myAdapter = new SqlDataAdapter(mycommand); DataTable myTable = new DataTable(); try { dbConnection.Open(); myAdapter.Fill(myTable); var record = mycommand.ExecuteScalar(); if (record != null) { TbxPurchaseID.Text = myTable.Rows[0]["purchaseID"].ToString(); TbxPurchasePerson.Text = myTable.Rows[0]["purchasePerson"].ToString(); ddnTrade.Text = myTable.Rows[0]["trade"].ToString(); TbxDate.Text = myTable.Rows[0]["date"].ToString(); TbxCNIC.Text = myTable.Rows[0]["cnic"].ToString(); TbxRegNo.Text = myTable.Rows[0]["regNo"].ToString(); TbxCustomerName.Text = myTable.Rows[0]["customerName"].ToString(); this.GetCustomerRecord("CustomerMaster", "cNIC", TbxCNIC.Text); this.GetStockMasterRecord("StockMaster", "RegNo", TbxRegNo.Text); } else { string script = "alert(\" Sale Data Not Found !\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } catch (Exception) { throw; } }
private int getstockID() { int stock = 0; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection sqlConn = myConnection.getDatabaseConnection(); string q = "select stockid from stockmaster order by stockid desc"; SqlCommand getIDCommand = new SqlCommand(q, sqlConn); try { sqlConn.Open(); int id = Convert.ToInt32(getIDCommand.ExecuteScalar()) + 1; stock = id; sqlConn.Close(); } catch (Exception) { throw; } return(stock); }
private int getCustomerID() { int customer = 0; ConnectionStringClass myConnection = new ConnectionStringClass(); SqlConnection sqlConn = myConnection.getDatabaseConnection(); string q = " select customerID from customerMaster order by customerID desc "; SqlCommand getIDCommand = new SqlCommand(q, sqlConn); try { sqlConn.Open(); int id = Convert.ToInt32(getIDCommand.ExecuteScalar()) + 1; customer = id; sqlConn.Close(); } catch (Exception) { throw; } return(customer); }