public int SaveCallRecord(CallsRecords callsrecords, string ConnString) { int rpta = 0; try { using (SqlConnection con = new SqlConnection(ConnString)) { con.Open(); using (SqlCommand cmd = new SqlCommand("spSaveCallsRecords", con)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CallId", SqlDbType.VarChar).Value = callsrecords.CallId; cmd.Parameters.Add("@Record", SqlDbType.Bit).Value = callsrecords.Record; cmd.Parameters.Add("@CallPartNumber", SqlDbType.VarChar).Value = callsrecords.CallPartNumber; rpta = cmd.ExecuteNonQuery(); } } return(rpta); } catch (Exception e) { return(0); } }
public List <CallsRecords> spGetListCallsRecords(string CallId, string ConnString) { List <CallsRecords> list = new List <CallsRecords>(); using (SqlConnection con = new SqlConnection(ConnString)) { con.Open(); using (SqlCommand cmd = new SqlCommand("spGetListCallsRecords", con)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pCallId", SqlDbType.VarChar).Value = CallId; var read = cmd.ExecuteReader(); while (read.Read()) { CallsRecords tmp = new CallsRecords(); if (read["Id"] != DBNull.Value) { tmp.Id = read.GetInt32(read.GetOrdinal("Id")); } if (read["Record"] != DBNull.Value) { tmp.Record = read.GetBoolean(read.GetOrdinal("Record")); } if (read["CallPartNumber"] != DBNull.Value) { tmp.CallPartNumber = read.GetString(read.GetOrdinal("CallPartNumber")); } if (read["StartDate"] != DBNull.Value) { tmp.StartDate = read.GetDateTime(read.GetOrdinal("StartDate")); } if (read["CallId"] != DBNull.Value) { tmp.CallId = Int32.Parse(read.GetString(read.GetOrdinal("CallId"))); } list.Add(tmp); } } } return(list); }