public void UpdateRecod(GroupHelper GrpHlprObj, string _connStr)
{
using (SqlConnection conn = new SqlConnection(_connStr))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdateCipRecord";
cmd.Parameters.AddWithValue("EndDatetime", GrpHlprObj.EndDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ReUsdWtrStarDatetime", GrpHlprObj.ReUsdWtrStarDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ReUsdWtrEndDatetime", GrpHlprObj.ReUsdWtrEndDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("cCCondctivity", GrpHlprObj.cCCondctivity ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("cCTemp", GrpHlprObj.cCTemp ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("cCFlowRate", GrpHlprObj.cCFlowRate ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrStartDatetime", GrpHlprObj.RawWtrStartDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrEndDatetime", RawWtrEndDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("aCCondctivity", GrpHlprObj.aCCondctivity ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("aCTemp", GrpHlprObj.aCTemp ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("aCFlowRate", GrpHlprObj.aCFlowRate ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrCondctivity", GrpHlprObj.RawWtrCondctivity ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrStartDatetime1", GrpHlprObj.RawWtrStartDatetime1 ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrEndDatetime1", GrpHlprObj.RawWtrEndDatetime1 ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("Remarks", GrpHlprObj.Remarks ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ID", GrpHlprObj.RowID);
cmd.Parameters.AddWithValue("CIPType", GrpHlprObj.CIPType);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public int InsertRecod(GroupHelper GrpHlprObj, string _connStr)
{
int RecordID = -1;
using (SqlConnection conn = new SqlConnection(_connStr))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertCipRecord";
cmd.Parameters.AddWithValue("StartDatetime", GrpHlprObj.StartDatetime);
cmd.Parameters.AddWithValue("EndDatetime", GrpHlprObj.EndDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ReUsdWtrStarDatetime", GrpHlprObj.ReUsdWtrStarDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("ReUsdWtrEndDatetime", GrpHlprObj.ReUsdWtrEndDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("cCCondctivity", GrpHlprObj.cCCondctivity ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("cCTemp", GrpHlprObj.cCTemp ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("cCFlowRate", GrpHlprObj.cCFlowRate ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrStartDatetime", GrpHlprObj.RawWtrStartDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrEndDatetime", GrpHlprObj.RawWtrEndDatetime ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("aCCondctivity", GrpHlprObj.aCCondctivity ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("aCTemp", GrpHlprObj.aCTemp ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("aCFlowRate", GrpHlprObj.aCFlowRate ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrCondctivity", GrpHlprObj.RawWtrCondctivity ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrStartDatetime1", GrpHlprObj.RawWtrStartDatetime1 ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("RawWtrEndDatetime1", GrpHlprObj.RawWtrEndDatetime1 ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("Remarks", GrpHlprObj.Remarks);
cmd.Parameters.AddWithValue("ObjectCode", GrpHlprObj.ObjectCode);
cmd.Parameters.AddWithValue("ObjectGroup", GrpHlprObj.CIPGroup);
cmd.Parameters.AddWithValue("CIPType", GrpHlprObj.CIPType);
RecordID = (int)(decimal)cmd.ExecuteScalar();
}
conn.Close();
}
return(RecordID);
}
