public IList <AppointmentSheet> AppointmentQueue(int said, Boolean reschedule) { assignableAppointments.Clear(); using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(GetAppointmentQueueQuery, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter(":salesagent", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter(":reschedule", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Prepare(); command.Parameters[0].Value = said; command.Parameters[1].Value = reschedule; using (Npgsql.NpgsqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { AppointmentSheet newAppointment = populateAppointmentFromDB(dr); assignableAppointments.Add(newAppointment); } } } } return(assignableAppointments); }
public IEnumerable <AppointmentSheet> GetAppointmentByLeadId(int leadId) { //Please see section on using prepared statements in npgsql user manual for explanation on params and query structure IList <Domain.AppointmentSheet> leadAppointments = new List <Domain.AppointmentSheet>(); using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(AppointmentSelectonLeadIDQuery, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter("leadid", NpgsqlTypes.NpgsqlDbType.Integer)); command.Prepare(); command.Parameters[0].Value = leadId; using (Npgsql.NpgsqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { AppointmentSheet newAppointment = populateAppointmentFromDB(dr); leadAppointments.Add(newAppointment); } } } } return(leadAppointments); }
public void DeleteAppointmentSheet(AppointmentSheet appointment) { var temp = fakeAppointment.ToList(); temp.RemoveAll(row => row.AppointmentSheetId == appointment.AppointmentSheetId); //temp.RemoveAll(row => row.AppointmentSheetId == appointment.AppointmentSheetId && row.ParentLeadId == row.ParentLeadId); //temp.RemoveAll(row => row.ParentLeadId == appointment.ParentLeadId); fakeAppointment = temp; }
public JsonResult updateEventId(FormCollection updatedCalendarEvent) { CalendarEventViewModel cevm = new CalendarEventViewModel(); CalendarEvent events = new CalendarEvent(); string lead = updatedCalendarEvent[19].Substring(0, 5); int LeadId = Int32.Parse(lead); LeadId = Int32.Parse(lead); AppointmentSheetViewModel avm = new AppointmentSheetViewModel(); AppointmentSheet asvm = new AppointmentSheet() { ParentLeadId = LeadId }; string starttemp = updatedCalendarEvent[14].Remove(0, 4); starttemp = starttemp.Remove(20); string endtemp = updatedCalendarEvent[15].Remove(0, 4); endtemp = endtemp.Remove(20); DateTime tempstart = DateTime.Parse(starttemp); events.start = tempstart.ToString("yyyy-MM-ddTHH':'mm':'ss'.'fff'-'05':'00"); DateTime tempend = DateTime.Parse(endtemp); events.end = tempend.ToString("yyyy-MM-ddTHH':'mm':'ss'.'fff'-'05':'00"); events.id = Int32.Parse(updatedCalendarEvent[0]); events.title = updatedCalendarEvent[1].ToString(); events.street = updatedCalendarEvent[6].ToString(); events.city = updatedCalendarEvent[7].ToString(); events.state = updatedCalendarEvent[8].ToString(); events.Parent_User_Id = Int32.Parse(updatedCalendarEvent[17]); events.Parent_Appointment_Id = Int32.Parse(updatedCalendarEvent[18]); events.Appointment_Reference = updatedCalendarEvent[19].ToString(); events.zipcode = Int32.Parse(updatedCalendarEvent[10]); events.appointment = Boolean.Parse(updatedCalendarEvent[4]); events.creator = Int32.Parse(updatedCalendarEvent[12]); asvm.Street = updatedCalendarEvent[6].ToString();; asvm.City = updatedCalendarEvent[7].ToString(); asvm.State = updatedCalendarEvent[8].ToString(); asvm.Event_Reference = updatedCalendarEvent[19].ToString(); asvm.ZipCode = Int32.Parse(updatedCalendarEvent[10]); asvm.AssignedSalesAgent = Int32.Parse(updatedCalendarEvent[17]); asvm.AppointmentDateFrom = tempstart; asvm.AppointmentDateTo = tempend; asvm.AppointmentSheetId = events.Parent_Appointment_Id; string parentlead = events.Appointment_Reference.Substring(0, 5); asvm.ParentLeadId = Int32.Parse(parentlead); asvm.DayOfAppointment = tempstart; asvm.LastUpdated = Convert.ToDateTime(DateTime.Now); asvm.CreatorId = events.creator; avm.appointmentSheet = asvm; cevm.calendarEvent = events; _eventsRepository.SaveCalendarEvent(cevm.calendarEvent); _appointmentsRepository.SaveAppointmentSheetFromCalendar(avm.appointmentSheet); return(null); }
public void DeleteAppointmentSheet(AppointmentSheet appointment) { using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(AppointmentDeleteQuery, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentid", NpgsqlTypes.NpgsqlDbType.Integer)); command.Prepare(); command.Parameters[0].Value = appointment.AppointmentSheetId; int rowsAffected = command.ExecuteNonQuery(); } } }
public void SaveAppointmentSheet(AppointmentSheet appointment) { // If it's a new appointment, just add it to the list if (appointment.AppointmentSheetId == 0) { appointment.AppointmentSheetId = counter; counter += 1; fakeAppointment.Add(appointment); } else if (fakeAppointment.Count(row => row.AppointmentSheetId == appointment.AppointmentSheetId) == 1) { //This is an update. Remove old one, insert new one DeleteAppointmentSheet(appointment); fakeAppointment.Add(appointment); } }
private static AppointmentSheet populateAppointmentFromDB(Npgsql.NpgsqlDataReader dr) { AppointmentSheet newAppointment = new AppointmentSheet(); newAppointment.AppointmentSheetId = Helper.ConvertFromDBVal <int>(dr[0]); newAppointment.AddingServices = Helper.ConvertFromDBVal <bool>(dr[1]); newAppointment.AppointmentLocation = dr[2].ToString(); newAppointment.AssignedSalesAgent = Helper.ConvertFromDBVal <int>(dr[3]); newAppointment.City = dr[4].ToString(); newAppointment.Comment = dr[5].ToString(); newAppointment.CreatedAt = Helper.ConvertFromDBVal <DateTime>(dr[6]); newAppointment.CurrentlyAcceptingCards = Helper.ConvertFromDBVal <bool>(dr[7]); newAppointment.CurrentProcessor = dr[8].ToString(); newAppointment.DayOfAppointment = Helper.ConvertFromDBVal <DateTime>(dr[9]); newAppointment.HowManyLocations = Helper.ConvertFromDBVal <int>(dr[10]); newAppointment.Internet = Helper.ConvertFromDBVal <bool>(dr[11]); newAppointment.LastUpdated = Helper.ConvertFromDBVal <DateTime>(dr[12]); newAppointment.Moto = Helper.ConvertFromDBVal <bool>(dr[13]); newAppointment.MultiLocation = Helper.ConvertFromDBVal <bool>(dr[14]); newAppointment.NewEquipment = Helper.ConvertFromDBVal <bool>(dr[15]); newAppointment.NewSetUp = Helper.ConvertFromDBVal <Boolean>(dr[16]); newAppointment.Price = Helper.ConvertFromDBVal <Boolean>(dr[17]); newAppointment.Score = dr[18].ToString(); newAppointment.SingleLocation = Helper.ConvertFromDBVal <Boolean>(dr[19]); newAppointment.State = dr[20].ToString(); newAppointment.Street = dr[21].ToString(); newAppointment.Swipe = Helper.ConvertFromDBVal <bool>(dr[22]); newAppointment.Unhappy = Helper.ConvertFromDBVal <bool>(dr[23]); newAppointment.Volume = dr[24].ToString(); newAppointment.ZipCode = Helper.ConvertFromDBVal <int>(dr[25]); newAppointment.CreatorId = Helper.ConvertFromDBVal <int>(dr[26]); newAppointment.ParentLeadId = Helper.ConvertFromDBVal <int>(dr[27]); newAppointment.Location = dr[28].ToString(); newAppointment.AppointmentDateFrom = Helper.ConvertFromDBVal <DateTime>(dr[29]); newAppointment.AppointmentDateTo = Helper.ConvertFromDBVal <DateTime>(dr[30]); newAppointment.Reschedule = Helper.ConvertFromDBVal <bool>(dr[31]); newAppointment.CreatorName = dr[32].ToString(); newAppointment.SingleLocCheck = Helper.ConvertFromDBVal <bool>(dr[33]); newAppointment.Event_Reference = (dr[34]).ToString(); return(newAppointment); }
public IList <AppointmentSheet> AssignAppointments(int appointmentid) { assignableAppointments.Clear(); using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(GetAppointmentQuery, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter(":appointmentsheetid", NpgsqlTypes.NpgsqlDbType.Integer)); command.Prepare(); command.Parameters[0].Value = appointmentid; using (Npgsql.NpgsqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { AppointmentSheet newAppointment = populateAppointmentFromDB(dr); assignableAppointments.Add(newAppointment); } } } } return(assignableAppointments); }
public void SaveAppointmentSheet(AppointmentSheet appointment) { string query; bool isUpdate = false; // Want to know right off the bat if we're doing a insert or update if (appointment.AppointmentSheetId > 0) { query = AppointmentUpdateQuery; isUpdate = true; } else { query = AppointmentInsertQuery; } using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(query, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter("addingservices", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentlocation", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("assignedsalesagent", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("city", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("comment", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("createdat", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("currentlyacceptedcards", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("currentprocessor", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("dateofappointment", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("howmanylocations", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("internet", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("lastupdated", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("moto", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("multilocation", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("newequipment", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("newsetup", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("price", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("score", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("singlelocation", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("state", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("street", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("swipe", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("unhappy", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("volume", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("zipcode", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("creator", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("parentlead", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("location", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentdatefrom", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentdateto", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("reschedule", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("creatorname", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("singleloccheck", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("event_reference", NpgsqlTypes.NpgsqlDbType.Text)); //command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentzone", NpgsqlTypes.NpgsqlDbType.Integer)); if (isUpdate) { command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentid", NpgsqlTypes.NpgsqlDbType.Integer)); } command.Prepare(); command.Parameters[0].Value = appointment.AddingServices; command.Parameters[1].Value = appointment.AppointmentLocation; command.Parameters[2].Value = appointment.AssignedSalesAgent; command.Parameters[3].Value = appointment.City; command.Parameters[4].Value = appointment.Comment; command.Parameters[5].Value = appointment.CreatedAt; command.Parameters[6].Value = appointment.CurrentlyAcceptingCards; command.Parameters[7].Value = appointment.CurrentProcessor; command.Parameters[8].Value = appointment.DayOfAppointment; command.Parameters[9].Value = appointment.HowManyLocations; command.Parameters[10].Value = appointment.Internet; command.Parameters[11].Value = appointment.LastUpdated; command.Parameters[12].Value = appointment.Moto; command.Parameters[13].Value = appointment.MultiLocation; command.Parameters[14].Value = appointment.NewEquipment; command.Parameters[15].Value = appointment.NewSetUp; command.Parameters[16].Value = appointment.Price; command.Parameters[17].Value = appointment.Score; command.Parameters[18].Value = appointment.SingleLocation; command.Parameters[19].Value = appointment.State; command.Parameters[20].Value = appointment.Street; command.Parameters[21].Value = appointment.Swipe; command.Parameters[22].Value = appointment.Unhappy; command.Parameters[23].Value = appointment.Volume; command.Parameters[24].Value = appointment.ZipCode; command.Parameters[25].Value = appointment.CreatorId; command.Parameters[26].Value = appointment.ParentLeadId; command.Parameters[27].Value = appointment.Location; command.Parameters[28].Value = appointment.AppointmentDateFrom; command.Parameters[29].Value = appointment.AppointmentDateTo; command.Parameters[30].Value = appointment.Reschedule; command.Parameters[31].Value = appointment.CreatorName; command.Parameters[32].Value = appointment.SingleLocCheck; command.Parameters[33].Value = appointment.Event_Reference; //command.Parameters[34].Value = appointment.AppointmentZone; //command.Parameters[10].Value = card.Creator; if (isUpdate) { command.Parameters[34].Value = appointment.AppointmentSheetId; } int rowsAffected = command.ExecuteNonQuery(); } } }
public void SaveAppointmentSheetFromCalendar(AppointmentSheet appointment) { string query; bool isUpdate = false; // Want to know right off the bat if we're doing a insert or update if (appointment.AppointmentSheetId > 0) { query = CalendarAppointmentUpdateQuery; isUpdate = true; } else { query = AppointmentInsertQuery; } using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(query, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter("city", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("dateofappointment", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("lastupdated", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("state", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("street", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("zipcode", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentdatefrom", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentdateto", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("event_reference", NpgsqlTypes.NpgsqlDbType.Text)); if (isUpdate) { command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentid", NpgsqlTypes.NpgsqlDbType.Integer)); } command.Prepare(); command.Parameters[0].Value = appointment.City; command.Parameters[1].Value = appointment.DayOfAppointment; command.Parameters[2].Value = appointment.LastUpdated; command.Parameters[3].Value = appointment.State; command.Parameters[4].Value = appointment.Street; command.Parameters[5].Value = appointment.ZipCode; command.Parameters[6].Value = appointment.AppointmentDateFrom; command.Parameters[7].Value = appointment.AppointmentDateTo; command.Parameters[8].Value = appointment.Event_Reference; //command.Parameters[10].Value = card.Creator; if (isUpdate) { command.Parameters[9].Value = appointment.AppointmentSheetId; } int rowsAffected = command.ExecuteNonQuery(); } } }
public void SaveAppointmentSheetFromCalendar(AppointmentSheet lead) { }
public void SaveAssignedAppointments(AppointmentSheet appointment, int userid) { using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString())) { conn.Open(); using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(AppointmentUpdateQuery, conn)) { command.Parameters.Add(new Npgsql.NpgsqlParameter("addingservices", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentlocation", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("assignedsalesagent", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("city", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("comment", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("createdat", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("currentlyacceptedcards", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("currentprocessor", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("dateofappointment", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("howmanylocations", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("internet", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("lastupdated", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("moto", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("multilocation", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("newequipment", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("newsetup", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("price", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("score", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("singlelocation", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("state", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("street", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("swipe", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("unhappy", NpgsqlTypes.NpgsqlDbType.Boolean)); command.Parameters.Add(new Npgsql.NpgsqlParameter("volume", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("zipcode", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("creator", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("parentlead", NpgsqlTypes.NpgsqlDbType.Integer)); command.Parameters.Add(new Npgsql.NpgsqlParameter("location", NpgsqlTypes.NpgsqlDbType.Text)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentdatefrom", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentdateto", NpgsqlTypes.NpgsqlDbType.Timestamp)); command.Parameters.Add(new Npgsql.NpgsqlParameter("appointmentid", NpgsqlTypes.NpgsqlDbType.Integer)); command.Prepare(); command.Parameters[0].Value = appointment.AddingServices; command.Parameters[1].Value = appointment.AppointmentLocation; command.Parameters[2].Value = userid; command.Parameters[3].Value = appointment.City; command.Parameters[4].Value = appointment.Comment; command.Parameters[5].Value = appointment.CreatedAt; command.Parameters[6].Value = appointment.CurrentlyAcceptingCards; command.Parameters[7].Value = appointment.CurrentProcessor; command.Parameters[8].Value = appointment.DayOfAppointment; command.Parameters[9].Value = appointment.HowManyLocations; command.Parameters[10].Value = appointment.Internet; command.Parameters[11].Value = appointment.LastUpdated; command.Parameters[12].Value = appointment.Moto; command.Parameters[13].Value = appointment.MultiLocation; command.Parameters[14].Value = appointment.NewEquipment; command.Parameters[15].Value = appointment.NewSetUp; command.Parameters[16].Value = appointment.Price; command.Parameters[17].Value = appointment.Score; command.Parameters[18].Value = appointment.SingleLocation; command.Parameters[19].Value = appointment.State; command.Parameters[20].Value = appointment.Street; command.Parameters[21].Value = appointment.Swipe; command.Parameters[22].Value = appointment.Unhappy; command.Parameters[23].Value = appointment.Volume; command.Parameters[24].Value = appointment.ZipCode; command.Parameters[25].Value = appointment.CreatorId; command.Parameters[26].Value = appointment.ParentLeadId; command.Parameters[27].Value = appointment.Location; command.Parameters[28].Value = appointment.AppointmentDateFrom; command.Parameters[29].Value = appointment.AppointmentDateTo; command.Parameters[30].Value = appointment.AppointmentSheetId; int rowsAffected = command.ExecuteNonQuery(); } } }