public Object GetDashboardText([FromBody] DashboardText da) { DashboardTextOutput daOP = new DashboardTextOutput(); DataSet SelectedSlots = new DataSet(); string sJSONResponse = ""; DataTable dt_Sessions = new DataTable(); List <DashboardTextResponse> dalots = new List <DashboardTextResponse>(); try { dt_Sessions = getdata(string.Format("select distinct DT.ID,Text,DT.Comments,DT.ScreenId,D.ScreenName,DT.DisplayID,DD.DisplayName from DashboardText DT,DashboardDisplay DD,Dashboard D where DT.DisplayID=DD.ID and DT.ScreenId=D.ScreenId and DT.ScreenId='{0}' and DT.DisplayID='{1}' order by ID asc", da.screenId, da.displayId)); for (int i = 0; i < dt_Sessions.Rows.Count; i++) { DashboardTextResponse SlotsDetails = new DashboardTextResponse { id = dt_Sessions.Rows[i]["ID"].ToString(), text = dt_Sessions.Rows[i]["Text"].ToString(), comments = dt_Sessions.Rows[i]["Comments"].ToString() }; dalots.Add(SlotsDetails); } daOP.status = "success"; daOP.value = dalots; sJSONResponse = JsonConvert.SerializeObject(daOP); } catch (Exception ec) { daOP.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(daOP); } return(sJSONResponse); }
// GET: ApplicationTypes public Object DashboardTextPost([FromBody] DashboardText dt) { string sJSONResponse = ""; DataTable dt_AppType = new DataTable(); string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture); int a = 0; string olPackage_Query = ""; PaymentDetailsPost Pdetails = new PaymentDetailsPost(); try { cnn.Open(); olPackage_Query = "insert into DashboardText(DisplayID,Text,Comments,CreatedBy,CreatedOn,IsDeleted,IsActive,ScreenId) values('" + dt.displayId + "','" + dt.text + "','" + dt.comments + "','" + dt.createdBy + "','" + ServerDateTime + "',0,1," + dt.screenId + ") SELECT @@IDENTITY;"; SqlCommand tm_cmd = new SqlCommand(olPackage_Query, cnn); a = Convert.ToInt32(tm_cmd.ExecuteScalar()); Pdetails.status = "Success"; Pdetails.transactionId = a; } catch (Exception ex) { Pdetails.status = "Fail"; } finally { cnn.Close(); } sJSONResponse = JsonConvert.SerializeObject(Pdetails); return(sJSONResponse); }
public void SaveDashboardDetail(DashoboardModel model) { DashboardText dashboard = new DashboardText { Id = model.Id, Description = model.EditorText }; _context.DashboardTexts.Add(dashboard); _context.SaveChanges(); }
public Object DashboardTextDelete([FromBody] DashboardText dt) { SqlCommand command = cnn.CreateCommand(); string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture); try { cnn.Close(); cnn.Open(); SqlTransaction transaction; transaction = cnn.BeginTransaction("SampleTransaction"); command.Connection = cnn; command.Transaction = transaction; try { command.CommandText = "delete from DashboardText where Id=" + dt.id + " "; command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } finally { } } catch (Exception ec) { } string sJSONResponse = ""; return(sJSONResponse); }