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); }