private void Uc_Vehicle1_SelectByIdRequest(object sender, ProcEventArgs e)
{
var procName = Utility.GetStProcName(e.ProcKey);
var db = new DbOperations(connectionString);
var table = db.SelectSingleById(procName, e.SelectRequestId);
uc_Vehicle1.SelectByIdProcResult(table);
}
private void Uc_Vehicle1_InsertRequest(object sender, ProcEventArgs e)
{
var procName = Utility.GetStProcName(e.ProcKey);
var db = new DbOperations(connectionString);
Dictionary <string, object> insertDict = new Dictionary <string, object>();
insertDict.Add(keyColumnMake, uc_Vehicle1.Make);
insertDict.Add(keyColumnModel, uc_Vehicle1.Model);
insertDict.Add(keyColumnYear, uc_Vehicle1.Year);
insertDict.Add(keyColumnLicensePlate, uc_Vehicle1.LicensePlate);
insertDict.Add(keyColumnColor, uc_Vehicle1.Color);
int newRecordId = db.InsertSingle(procName, insertDict);
uc_Vehicle1.InsertProcResult(newRecordId);
}
private void btnInsert_Click(object sender, EventArgs e)
{
//ResetForm();
var vehicle = new Vehicle();
Make = txtMake.Text.Trim();
Model = txtModel.Text.Trim();
LicensePlate = txtLicensePlate.Text.Trim();
Color = txtColor.Text.Trim();
if (ValidateInsertModel())
{
ProcEventArgs args = new ProcEventArgs();
args.ProcKey = insertProcKey;
InsertRequest(this, args);
}
}
//private void ResetDataSelection()
//{
// dataId.Text = "";
// dataMake.Text = "";
// dataModel.Text = "";
// dataYear.Text = "";
// dataLicensePlate.Text = "";
// dataColor.Text = "";
//}
private void btnSelect_Click(object sender, EventArgs e)
{
int id = 0;
if (Int32.TryParse(txtId.Text, out id))
{
if (id > 0)
{
ResetErrorMessages();
ResetInputsOutputs();
ProcEventArgs args = new ProcEventArgs();
args.ProcKey = selectByIdProcKey;
args.SelectRequestId = id;
SelectByIdRequest(this, args);
txtId.Text = id.ToString();
return;
}
}
lblRecordError.Text = "Invalid Format";
lblRecordError.Show();
}