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);
}