public ClsDealerData getSingleDealerData(int dealerId)
{
ClsDealerData dealer = new ClsDealerData();
DataTable dt = new DataTable();
try
{
string querry = "SELECT * FROM tbl_dealers WHERE dealerId = '" + dealerId + "';";
dt = CONN.getDataTable(querry);
if (dt.Rows.Count > 0)
{
dealer._dealerId = Convert.ToInt32(dt.Rows[0]["dealerId"]);
dealer._dealerName = dt.Rows[0]["dealerName"].ToString();
dealer._companyName = dt.Rows[0]["companyName"].ToString();
dealer._address = dt.Rows[0]["address"].ToString();
dealer._phoneNo = dt.Rows[0]["phoneNo"].ToString();
dealer._mobile = dt.Rows[0]["mobile"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(dealer);
}
public bool updateData_dealer(ClsDealerData dealer)
{
bool isOK = false;
string querry = string.Empty;
try
{
querry += "UPDATE tbl_dealers SET ";
querry += "dealerName = '" + dealer._dealerName + "', ";
querry += "companyName = '" + dealer._companyName + "', ";
querry += "address = '" + dealer._address + "',";
querry += "phoneNo ='" + dealer._phoneNo + "', ";
querry += "mobile ='" + dealer._mobile + "' ";
querry += "WHERE dealerId = '" + dealer._dealerId + "'";
isOK = CONN.update(querry);
}
catch (Exception ex)
{
throw ex;
}
return(isOK);
}
public bool insertData_dealer(ClsDealerData dealer)
{
bool isOK = false;
string querry = string.Empty;
try
{
querry += "INSERT INTO tbl_dealers (dealerId, dealerName, companyName, address, phoneNo, mobile) VALUES (";
querry += "'" + dealer._dealerId + "',";
querry += "'" + dealer._dealerName + "',";
querry += "'" + dealer._companyName + "',";
querry += "'" + dealer._address + "',";
querry += "'" + dealer._phoneNo + "',";
querry += "'" + dealer._mobile + "'";
querry += ");";
isOK = CONN.update(querry);
}
catch (Exception ex)
{
throw ex;
}
return(isOK);
}