public CollectionCallBatch GetCollectionCallBatchByHID(int hid) { CollectionCallBatch batch = new CollectionCallBatch(); string queryString = "SELECT * FROM dbo.msmCollectionCallBulkProcess WHERE HID = @hid"; using (SqlConnection connection = new SqlConnection(GlobalVars.DBConnection["Conn"].ToString())) { SqlCommand command = new SqlCommand(queryString, connection); command.Parameters.AddWithValue("@hid", hid); try { connection.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); if (dt.Rows.Count > 0) { batch = Setup(dt.Rows[0]); } else { batch = null; } } catch (Exception ex) { } finally { connection.Close(); } return(batch); } }
public void InsertCollectionCallBatch(string hid, string hidBatch) { //first check if a row already exists with this hid. If so, update instead of delete string queryString; CollectionCallBatch _batchService = new CollectionCallBatch(); CollectionCallBatch extBatch = _batchService.GetCollectionCallBatchByHID(Convert.ToInt32(hid)); if (extBatch != null) { queryString = "UPDATE dbo.msmCollectionCallBulkProcess SET HIDs = " + hidBatch; } else { queryString = "INSERT INTO dbo.msmCollectionCallBulkProcess(HID, HIDs) VALUES(" + hid + ", '" + hidBatch + "')"; } using (SqlConnection connection = new SqlConnection(GlobalVars.DBConnection["Conn"].ToString())) { SqlCommand command = new SqlCommand(queryString, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { connection.Close(); } } }
public CollectionCallBatch Setup(DataRow r) { CollectionCallBatch batch = new CollectionCallBatch(); batch.ID = r["HID"].ToString(); batch.HIDs = r["HIDs"].ToString(); return(batch); }