// For getting all the objects
public List <clsAllCameras> GetBrandModelObjects(string Brand)
{
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("Brand", Brand);
DataTable lcResult = clsDbConnection.GetDataTable("SELECT * FROM tblCameraModel WHERE fk_camera_brand = @Brand", par);
List <clsAllCameras> lcModelList = new List <clsAllCameras>();
if (lcResult.Rows.Count > 0)
{
foreach (DataRow dr in lcResult.Rows)
{
clsAllCameras lcCamera = new clsAllCameras();
lcCamera.model_name = (string)dr["model_name"];
lcCamera.description = (string)dr["description"];
lcCamera.release_year = (DateTime)dr["release_year"];
lcCamera.quantity = Convert.ToInt16(dr["quantity"]);
lcCamera.price = (decimal)dr["price"];
lcCamera.lens_mount = dr["lens_mount"] is DBNull ? (string)null : (string)dr["lens_mount"];
lcCamera.zoom_range = dr["zoom_range"] is DBNull ? (string)null : (string)dr["zoom_range"];
lcCamera.last_modified = (DateTime)dr["last_modified"];
lcCamera.camera_type = (string)dr["camera_type"];
lcCamera.camera_brand = (string)dr["fk_camera_brand"];
lcModelList.Add(lcCamera);
}
return(lcModelList);
}
else
{
return(null);
}
}
// Insert new camera
public string PostCamera(clsAllCameras prCamera)
{
try
{
int lcRecCount = clsDbConnection.Execute(
"INSERT INTO tblCameraModel(model_name, image, description, release_year, quantity, price, lens_mount, zoom_range, last_modified, camera_type, fk_camera_brand) VALUES (@model_name, @image, @description, @release_year, @quantity, @price, @lens_mount, @zoom_range, @last_modified, @camera_type, @camera_brand)", PrepareItemParameters(prCamera)
);
return("One Camera Inserted.");
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
private Dictionary <string, object> PrepareItemParameters(clsAllCameras prCamera)
{
Dictionary <string, object> par = new Dictionary <string, object>(11);
par.Add("model_name", prCamera.model_name);
par.Add("image", prCamera.image);
par.Add("description", prCamera.description);
par.Add("release_year", prCamera.release_year);
par.Add("quantity", prCamera.quantity);
par.Add("price", prCamera.price);
par.Add("lens_mount", prCamera.lens_mount);
par.Add("zoom_range", prCamera.zoom_range);
par.Add("last_modified", prCamera.last_modified);
par.Add("camera_type", prCamera.camera_type);
par.Add("camera_brand", prCamera.camera_brand);
return(par);
}
// Update existing camera
public string PutCamera(clsAllCameras prCamera)
{
try
{
int lcRecCount = clsDbConnection.Execute(
"UPDATE tblCameraModel SET model_name = @model_name, image = @image, description = @description, release_year = @release_year, quantity = @quantity, price = @price, lens_mount = @lens_mount, zoom_range = @zoom_range, last_modified = @last_modified, camera_type = @camera_type, fk_camera_brand = @camera_brand WHERE model_name = @model_name", PrepareItemParameters(prCamera));
if (lcRecCount == 1)
{
return("One Camera Updated.");
}
else
{
return("Unexpected Camera Update Count.");
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public static void Run(clsAllCameras prCamera)
{
Instance.SetDetails(prCamera);
}
public void UpdateControl(clsAllCameras prCamera)
{
lblLensMount.Text = prCamera.lens_mount.ToString();
}
public void PushData(clsAllCameras prCamera)
{
throw new NotImplementedException();
}
public void UpdateControl(clsAllCameras prCamera)
{
lblZoomRange.Text = prCamera.zoom_range.ToString();
}
