}//END OF CREATE BRAND
public Boolean updateBrands(VehicleBrand passedData)
{
bool reqStatus = false;
passedData.brandName = passedData.brandName;
passedData.brandCategory = passedData.brandCategory;
passedData.brandStatus = Sanitize(passedData.brandStatus);
try
{
openConnection();
sql = @"UPDATE tblvehiclebrand SET brandName='" + passedData.brandName +
"', brandCategory='" + passedData.brandCategory +
"', brandStatus='" + passedData.brandStatus +
"' WHERE brandID='" + passedData.brandID + "'";
cmd = new MySqlCommand(sql, con);
cmd.ExecuteNonQuery();
reqStatus = true;
}
catch
{
reqStatus = false;
}
finally
{
con.Close();
}
return(reqStatus);
}//END OF UPDATE BRAND
}//END OF READ ALL BRAND ACTIVE
public List <VehicleBrand> searchBrands_all(string searchText)
{
searchText = Sanitize(searchText);
try
{
openConnection();
sql = @"SELECT * FROM tblvehiclebrand WHERE brandName LIKE '%" + searchText +
"%' OR brandStatus LIKE '%" + searchText +
"%'";
cmd = new MySqlCommand(sql, con);
rd = cmd.ExecuteReader();
if (rd.HasRows)
{
var listOfBrand = new List <VehicleBrand>();
while (rd.Read())
{
var brand = new VehicleBrand();
brand.brandID = rd["brandID"].ToString();
brand.brandName = rd["brandName"].ToString();
brand.brandCategory = rd["brandCategory"].ToString();
brand.brandStatus = rd["brandStatus"].ToString();
brand.created_at = rd["created_at"].ToString();
brand.updated_at = rd["updated_at"].ToString();
listOfBrand.Add(brand);
}
return(listOfBrand);
}
else
{
Console.WriteLine("No data");
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
con.Close();
}
return(null);
}//END OF SEARCH FROM ALL BRAND
}//END OF READ ALL BRAND
public List <VehicleBrand> readBrands_active()
{
try
{
openConnection();
sql = "SELECT * FROM tblvehiclebrand WHERE brandStatus='ACTIVE'";
cmd = new MySqlCommand(sql, con);
rd = cmd.ExecuteReader();
if (rd.HasRows)
{
var listOfBrand = new List <VehicleBrand>();
while (rd.Read())
{
var brand = new VehicleBrand();
brand.brandID = rd["brandID"].ToString();
brand.brandName = rd["brandName"].ToString();
brand.brandCategory = rd["brandCategory"].ToString();
brand.brandStatus = rd["brandStatus"].ToString();
brand.created_at = rd["created_at"].ToString();
brand.updated_at = rd["updated_at"].ToString();
listOfBrand.Add(brand);
}
return(listOfBrand);
}
else
{
Console.WriteLine("No data");
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
con.Close();
}
return(null);
}//END OF READ ALL BRAND ACTIVE
}//END OF SEARCH FROM ALL TYPE
public Boolean createBrands(VehicleBrand passedData)
{
bool reqStatus = false;
passedData.brandName = passedData.brandName;
passedData.brandCategory = passedData.brandCategory;
passedData.brandStatus = Sanitize(passedData.brandStatus);
DateTime dateTimeVariable = DateTime.Now;
string date = dateTimeVariable.ToString("yyyy-MM-dd H:mm:ss");
passedData.created_at = date;
try
{
openConnection();
sql = @"INSERT INTO tblvehiclebrand SET brandName='" + passedData.brandName +
"', brandCategory='" + passedData.brandCategory +
"', brandStatus='" + passedData.brandStatus +
"', created_at='" + passedData.created_at + "'";
cmd = new MySqlCommand(sql, con);
cmd.ExecuteNonQuery();
reqStatus = true;
}
catch
{
reqStatus = false;
}
finally
{
con.Close();
}
return(reqStatus);
}//END OF CREATE BRAND
private void btnBrandSave_Click(object sender, EventArgs e)
{
if (this.brandActionIdentifier == "ADD")
{
if (txtBrandID.Text != "" && txtBrandName.Text != "" && cboBrandCategory.Text != "" && cboBrandStatus.Text != "")
{
VehicleBrand data = new VehicleBrand();
data.brandName = txtBrandName.Text;
data.brandStatus = cboBrandStatus.Text;
foreach (var type in currentDataType)
{
//Find Same Type Name
if (cboBrandCategory.Text == type.typeName)
{
data.brandCategory = type.typeID;
break;
}
}
if (connect.createBrands(data))
{
MessageBox.Show("Saved Successfully!");
clearBrandFields();
LoadBrands();
}
else
{
MessageBox.Show("Error Saving!");
}
}
else
{
MessageBox.Show("Please Complete All Required Fields!");
}
}
else if (this.brandActionIdentifier == "EDIT")
{
if (txtBrandID.Text != "" && txtBrandName.Text != "" && cboBrandCategory.Text != "" && cboBrandStatus.Text != "")
{
VehicleBrand data = new VehicleBrand();
data.brandID = txtBrandID.Text;
data.brandName = txtBrandName.Text;
data.brandStatus = cboBrandStatus.Text;
foreach (var type in currentDataType)
{
//Find Same Type Name
if (cboBrandCategory.Text == type.typeName)
{
data.brandCategory = type.typeID;
break;
}
}
if (connect.updateBrands(data))
{
MessageBox.Show("Updated Successfully!");
clearBrandFields();
LoadBrands();
}
else
{
MessageBox.Show("Error Saving!");
}
}
else
{
MessageBox.Show("Please Complete All Required Fields!");
}
}
}