public RigModel GetRig(int RigId)
{
RigModel model = new RigModel();
try
{
string query = String.Format(@"SELECT [RigId]
,[RigCode]
,[RigName]
,[RigManufacturer]
,[RigProject]
,[LocId]
,[RigTypeId]
,[RigModelNo]
,[RigRemarks]
,[RigDeployed]
,[RigLocation]
,[RigTypeName]
FROM [Rig] WHERE [RigId] = {0}", RigId);
fun.OpenConnection();
if (fun.getConnection().State == ConnectionState.Open)
{
DataSet ds = fun.fillComboDataset(query);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
model.LocId = Convert.ToInt32(item["LocId"].ToString());
model.RigCode = item["RigCode"].ToString();
if (item["RigDeployed"].ToString() == "")
{
model.RigDeployed = null;
}
else
{
model.RigDeployed = Convert.ToDateTime(item["RigDeployed"].ToString());
}
model.RigId = RigId;
model.RigManufacturer = item["RigManufacturer"].ToString();
model.RigModelNo = item["RigModelNo"].ToString();
model.RigName = item["RigName"].ToString();
model.RigProject = item["RigProject"].ToString();
model.RigRemarks = item["RigRemarks"].ToString();
model.RigTypeId = Convert.ToInt32(item["RigTypeId"].ToString());
model.RigLocation = item["RigLocation"].ToString();
model.RigTypeName = item["RigTypeName"].ToString();
}
}
}
else
{
throw new Exception("Please check network connection");
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
public RigModel Insert(RigModel model)
{
try
{
string query = @"INSERT INTO Rig(
RigCode
,RigName
,RigManufacturer
,RigProject
,LocId
,RigTypeId
,RigModelNo
,RigRemarks
,RigDeployed
,RigLocation
,RigTypeName)
output INSERTED.RigId
VALUES(
@RigCode
,@RigName
,@RigManufacturer
,@RigProject
,@LocId
,@RigTypeId
,@RigModelNo
,@RigRemarks
,@RigDeployed
,@RigLocation
,@RigTypeName)
";
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RigCode", model.RigCode));
param.Add(new SqlParameter("@RigName", model.RigName));
param.Add(new SqlParameter("@RigManufacturer", model.RigManufacturer));
param.Add(new SqlParameter("@RigProject", model.RigProject));
param.Add(new SqlParameter("@LocId", model.LocId));
param.Add(new SqlParameter("@RigTypeId", model.RigTypeId));
param.Add(new SqlParameter("@RigModelNo", model.RigModelNo));
param.Add(new SqlParameter("@RigRemarks", model.RigRemarks));
param.Add(new SqlParameter("@RigDeployed", model.RigDeployed));
param.Add(new SqlParameter("@RigLocation", model.RigLocation));
param.Add(new SqlParameter("@RigTypeName", model.RigTypeName));
fun.OpenConnection();
if (fun.getConnection().State == ConnectionState.Open)
{
model.RigId = fun.ExecuteQueryWithParameters(query, param, "Yes");
}
else
{
throw new Exception("Please check connection");
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
public RigModel Update(RigModel model)
{
try
{
string query = @"UPDATE Rig SET
RigCode = @RigCode
,RigName = @RigName
,RigManufacturer = @RigManufacturer
,RigProject = @RigProject
,LocId = @LocId
,RigTypeId = @RigTypeId
,RigModelNo = @RigModelNo
,RigRemarks = @RigRemarks
,RigDeployed = @RigDeployed
,RigLocation = @RigLocation
,RigTypeName = @RigTypeName
WHERE RigId = @RigId
";
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RigId", model.RigId));
param.Add(new SqlParameter("@RigCode", model.RigCode));
param.Add(new SqlParameter("@RigName", model.RigName));
param.Add(new SqlParameter("@RigManufacturer", model.RigManufacturer));
param.Add(new SqlParameter("@RigProject", model.RigProject));
param.Add(new SqlParameter("@LocId", model.LocId));
param.Add(new SqlParameter("@RigTypeId", model.RigTypeId));
param.Add(new SqlParameter("@RigModelNo", model.RigModelNo));
param.Add(new SqlParameter("@RigRemarks", model.RigRemarks));
param.Add(new SqlParameter("@RigDeployed", model.RigDeployed));
param.Add(new SqlParameter("@RigLocation", model.RigLocation));
param.Add(new SqlParameter("@RigTypeName", model.RigTypeName));
fun.OpenConnection();
if (fun.getConnection().State == ConnectionState.Open)
{
model.RigId = fun.ExecuteQueryWithParameters(query, param, "Yes");
}
else
{
throw new Exception("Please check connection");
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}