public ProfessionalSchedule(IDataReader dbReader,string type) : this() { kendo = new KendoEntity(); try { if (dbReader.HasColumn("OwnerID") && dbReader["OwnerID"] != DBNull.Value) kendo.OwnerID = dbReader["OwnerID"].ToString(); if (dbReader.HasColumn("IsAllday") && dbReader["IsAllday"] != DBNull.Value) kendo.IsAllDay = false; if (dbReader.HasColumn("Title") && dbReader["Title"] != DBNull.Value) kendo.Title = dbReader["Title"].ToString(); if (dbReader.HasColumn("Description") && dbReader["Description"] != DBNull.Value) kendo.Description = dbReader["Description"].ToString(); if (dbReader.HasColumn("Start") && dbReader["Start"] != DBNull.Value) kendo.Start = dbReader["Start"].ToString(); if (dbReader.HasColumn("End") && dbReader["End"] != DBNull.Value) kendo.End = dbReader["End"].ToString(); if (dbReader.HasColumn("TaskId") && dbReader["TaskId"] != DBNull.Value) kendo.TaskID = dbReader["TaskId"].ToString(); } catch (Exception ex) { string exc = ex.Message; } }
public bool AddProfessionalSchedule(KendoEntity professionalSchedule) { using (var conn = new SqlConnection(PrescienceRxConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(AddProfessionalScheduleSp, conn)) { //ToDo : Fix this method cmd.CommandType = System.Data.CommandType.StoredProcedure; TimeZoneInfo easternZone = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"); professionalSchedule.Start = TimeZoneInfo.ConvertTimeFromUtc(Convert.ToDateTime(professionalSchedule.Start).ToUniversalTime(), easternZone).ToString(); professionalSchedule.End=TimeZoneInfo.ConvertTimeFromUtc(Convert.ToDateTime(professionalSchedule.End).ToUniversalTime(),easternZone).ToString(); cmd.Parameters.Add("@ProfessionalId", SqlDbType.Int).Value = professionalSchedule.ProfessionalId; cmd.Parameters.Add("@CustomerId", SqlDbType.Int).Value = professionalSchedule.OwnerID; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = professionalSchedule.Title; cmd.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = professionalSchedule.Start; cmd.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = professionalSchedule.End; cmd.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = professionalSchedule.Description; cmd.Parameters.Add("@CreatedBy ", SqlDbType.NVarChar).Value = professionalSchedule.UserId; cmd.Parameters.Add("@DateCreated", SqlDbType.NVarChar).Value = DateTime.UtcNow; //TODO: Add this back, these parms missing from sp //cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = professionalSchedule.CreatedBy; //cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.UtcNow; return Convert.ToBoolean(cmd.ExecuteScalar()); } } }
public ProfessionalSchedule(IDataReader dbReader, string type) : this() { kendo = new KendoEntity(); try { if (dbReader.HasColumn("OwnerID") && dbReader["OwnerID"] != DBNull.Value) { kendo.OwnerID = dbReader["OwnerID"].ToString(); } if (dbReader.HasColumn("IsAllday") && dbReader["IsAllday"] != DBNull.Value) { kendo.IsAllDay = false; } if (dbReader.HasColumn("Title") && dbReader["Title"] != DBNull.Value) { kendo.Title = dbReader["Title"].ToString(); } if (dbReader.HasColumn("Description") && dbReader["Description"] != DBNull.Value) { kendo.Description = dbReader["Description"].ToString(); } if (dbReader.HasColumn("Start") && dbReader["Start"] != DBNull.Value) { kendo.Start = dbReader["Start"].ToString(); } if (dbReader.HasColumn("End") && dbReader["End"] != DBNull.Value) { kendo.End = dbReader["End"].ToString(); } if (dbReader.HasColumn("TaskId") && dbReader["TaskId"] != DBNull.Value) { kendo.TaskID = dbReader["TaskId"].ToString(); } } catch (Exception ex) { string exc = ex.Message; } }