public int UpdateProductionSetBySetID(ProductionSet obj)
{
string sql = @"Update [BE_ProductionSet] Set
[Started]=@Started
,[Ended]=@Ended
,[Weeks]=@Weeks
,[Days]=@Days
,[TotalAreal]=@TotalAreal
,[Created]=@Created
,[CreatedBy]=@CreatedBy
Where SetID=@SetID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pSetID = new SqlParameter("SetID", Convert2DBnull(obj.SetID));
pSetID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pSetID);
SqlParameter pStarted = new SqlParameter("Started", Convert2DBnull(obj.Started));
pStarted.SqlDbType = SqlDbType.SmallDateTime;
cmd.Parameters.Add(pStarted);
SqlParameter pEnded = new SqlParameter("Ended", Convert2DBnull(obj.Ended));
pEnded.SqlDbType = SqlDbType.SmallDateTime;
cmd.Parameters.Add(pEnded);
SqlParameter pWeeks = new SqlParameter("Weeks", Convert2DBnull(obj.Weeks));
pWeeks.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pWeeks);
SqlParameter pDays = new SqlParameter("Days", Convert2DBnull(obj.Days));
pDays.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pDays);
SqlParameter pTotalAreal = new SqlParameter("TotalAreal", Convert2DBnull(obj.TotalAreal));
pTotalAreal.SqlDbType = SqlDbType.Decimal;
cmd.Parameters.Add(pTotalAreal);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}
public int LoadProductionSet(ProductionSet obj)
{
string sql = @"Select
[SetID]
,[Started]
,[Ended]
,[Weeks]
,[Days]
,[TotalAreal]
,[Created]
,[CreatedBy]
From [BE_ProductionSet] With(NoLock) Where SetID=@SetID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pSetID = new SqlParameter("SetID", Convert2DBnull(obj.SetID));
pSetID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pSetID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["SetID"]))
{
obj.SetID = (Guid)dr["SetID"];
}
if (!Convert.IsDBNull(dr["Started"]))
{
obj.Started = (DateTime)dr["Started"];
}
if (!Convert.IsDBNull(dr["Ended"]))
{
obj.Ended = (DateTime)dr["Ended"];
}
if (!Convert.IsDBNull(dr["Weeks"]))
{
obj.Weeks = (int)dr["Weeks"];
}
if (!Convert.IsDBNull(dr["Days"]))
{
obj.Days = (int)dr["Days"];
}
if (!Convert.IsDBNull(dr["TotalAreal"]))
{
obj.TotalAreal = (decimal)dr["TotalAreal"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
obj.CreatedBy = (string)dr["CreatedBy"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public List <ProductionSet> LoadProductionSets()
{
string sql = @"Select
[SetID]
,[Started]
,[Ended]
,[Weeks]
,[Days]
,[TotalAreal]
,[Created]
,[CreatedBy]
From [BE_ProductionSet] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <ProductionSet> ret = new List <ProductionSet>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ProductionSet iret = new ProductionSet();
if (!Convert.IsDBNull(dr["SetID"]))
{
iret.SetID = (Guid)dr["SetID"];
}
if (!Convert.IsDBNull(dr["Started"]))
{
iret.Started = (DateTime)dr["Started"];
}
if (!Convert.IsDBNull(dr["Ended"]))
{
iret.Ended = (DateTime)dr["Ended"];
}
if (!Convert.IsDBNull(dr["Weeks"]))
{
iret.Weeks = (int)dr["Weeks"];
}
if (!Convert.IsDBNull(dr["Days"]))
{
iret.Days = (int)dr["Days"];
}
if (!Convert.IsDBNull(dr["TotalAreal"]))
{
iret.TotalAreal = (decimal)dr["TotalAreal"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
iret.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
iret.CreatedBy = (string)dr["CreatedBy"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}