public void UpdateJob(int id, JobModel model, float circul)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker")))
{
var p = new DynamicParameters();
p.Add("@oldJobCirculation", circul);
p.Add("@Id", id);
p.Add("@JobNumber", model.JobNumber);
p.Add("@Client", model.ClientName);
p.Add("@gdp", model.GDP);
p.Add("@modem", model.Modem);
p.Add("@ModemVersion", model.ModemVersion);
p.Add("@bbp", model.Bullplug);
p.Add("@newJobCirculation", model.CirculationHours);
p.Add("@Battery", model.Battery);
p.Add("@MaxTemp", model.MaxTemp);
p.Add("@EngineerOne", model.EngineerOne);
p.Add("@EngineerTwo", model.EngineerTwo);
p.Add("@EngineerOneArrived", model.eng_one_arrived);
p.Add("@EngineerTwoArrived", model.eng_two_arrived);
p.Add("@EngineerOneLeft", model.eng_one_left);
p.Add("@EngineerTwoLeft", model.eng_two_left);
p.Add("@Container", model.Container);
p.Add("@ContainerArrived", model.ContainerArrived);
p.Add("@ContainerLeft", model.ContainerLeft);
p.Add("@Rig", model.Rig);
p.Add("@Issues", model.Issues);
p.Add("@Comment", model.Comment);
//p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spUpdate_Job", p, commandType: CommandType.StoredProcedure);
//model.Id = p.Get<int>("@Id");
//return model;
}
}
// Creating Job record in DB
public JobModel CreateJob(JobModel model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker")))
{
var p = new DynamicParameters();
p.Add("@JobNumber", model.JobNumber);
p.Add("@Client", model.ClientName);
p.Add("@GDPAsset", model.GDP);
p.Add("@ModemAsset", model.Modem);
p.Add("@ModemVersion", model.ModemVersion);
p.Add("@BullplugAsset", model.Bullplug);
p.Add("@CirculationHours", model.CirculationHours);
p.Add("@Battery", model.Battery);
p.Add("@MaxTemp", model.MaxTemp);
p.Add("@EngineerOne", model.EngineerOne);
p.Add("@EngineerTwo", model.EngineerTwo);
p.Add("@EngineerOneArrived", model.eng_one_arrived);
p.Add("@EngineerTwoArrived", model.eng_two_arrived);
p.Add("@EngineerOneLeft", model.eng_two_arrived);
p.Add("@EngineerTwoLeft", model.eng_two_left);
p.Add("@Container", model.Container);
p.Add("@ContainerArrived", model.ContainerArrived);
p.Add("@ContainerLeft", model.ContainerLeft);
p.Add("@Rig", model.Rig);
p.Add("@Issues", model.Issues);
p.Add("@Comment", model.Comment);
p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spJob_Insert", p, commandType: CommandType.StoredProcedure);
model.Id = p.Get <int>("@Id");
return(model);
}
}