public Object GetCity([FromBody] PlaceInput pi) { CityGet daOP = new CityGet(); DataSet SelectedSlots = new DataSet(); string sJSONResponse = ""; DataTable dt_Sessions = new DataTable(); List <City> city = new List <City>(); try { dt_Sessions = getdata(string.Format("select city,CityName from city", "")); for (int i = 0; i < dt_Sessions.Rows.Count; i++) { City stt = new City { cityId = dt_Sessions.Rows[i]["city"].ToString(), CityName = dt_Sessions.Rows[i]["CityName"].ToString() }; city.Add(stt); } daOP.status = "success"; daOP.value = city; sJSONResponse = JsonConvert.SerializeObject(daOP); } catch (Exception ec) { daOP.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(daOP); } return(sJSONResponse); }
public Object CityPost([FromBody] PlaceInput pi) { string sJSONResponse = ""; DataTable dt_AppType = new DataTable(); string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture); int a = 0; string country_Query = ""; PlanOutPut Pcity = new PlanOutPut(); try { cnn.Open(); country_Query = "insert into city(CityName,StatesId,IsDeleted,IsActive) values('" + pi.CityName + "'," + pi.StatesId + ",0,1) SELECT @@IDENTITY;"; SqlCommand tm_cmd = new SqlCommand(country_Query, cnn); a = Convert.ToInt32(tm_cmd.ExecuteScalar()); Pcity.status = "Success"; } catch (Exception ex) { Pcity.status = "Fail"; } finally { cnn.Close(); } sJSONResponse = JsonConvert.SerializeObject(Pcity); return(sJSONResponse); }
public Object GetState([FromBody] PlaceInput pi) { StateGet daOP = new StateGet(); DataSet SelectedSlots = new DataSet(); string sJSONResponse = ""; DataTable dt_Sessions = new DataTable(); List <State> state = new List <State>(); try { dt_Sessions = getdata(string.Format("select StatesId,StatesName from States", "")); for (int i = 0; i < dt_Sessions.Rows.Count; i++) { State stt = new State { StatesId = dt_Sessions.Rows[i]["StatesId"].ToString(), StatesName = dt_Sessions.Rows[i]["StatesName"].ToString() }; state.Add(stt); } daOP.status = "success"; daOP.value = state; sJSONResponse = JsonConvert.SerializeObject(daOP); } catch (Exception ec) { daOP.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(daOP); } return(sJSONResponse); }
private void LoadSchemeOfHall(int seatingCapacity, int placesInRowLimit) { RowInput.Clear(); PlaceInput.Clear(); int X = 6; int Y = 19; bool notEven = false; int leftPlaces = seatingCapacity % placesInRowLimit; if (leftPlaces != 0) { notEven = true; buttonArray = new Button[(seatingCapacity / placesInRowLimit) + 1][]; } else { buttonArray = new Button[seatingCapacity / placesInRowLimit][]; } for (int i = 0; i < buttonArray.Length; i++) { buttonArray[i] = new Button[placesInRowLimit]; if (i == buttonArray.Length - 1 && notEven) { buttonArray[i] = new Button[leftPlaces]; } for (int j = 0; j < buttonArray[i].Length; j++) { buttonArray[i][j] = new Button(); buttonArray[i][j].Size = new Size(30, 30); buttonArray[i][j].Name = (i + 1).ToString(); buttonArray[i][j].Text = (j + 1).ToString(); buttonArray[i][j].MouseClick += new MouseEventHandler(SelectedPlaceInHall); if (i == buttonArray.Length - 1 && notEven) { X += 35 * (placesInRowLimit - leftPlaces) / 2; notEven = false; } buttonArray[i][j].Location = new Point(X, Y); HallPlaces.Controls.Add(buttonArray[i][j]); X += 35; } Label rowLabel = new Label(); rowLabel.Size = new Size(40, 30); rowLabel.Location = new Point(35 * buttonArray[0].Length, Y); rowLabel.Text = "Ряд " + (i + 1) + " "; HallPlaces.Controls.Add(rowLabel); X = 6; Y += 40; } }
public Object CountryDelete([FromBody] PlaceInput pi) { string sJSONResponse = ""; SqlCommand command = cnn.CreateCommand(); PlanOutPut Pcountry = new PlanOutPut(); 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 Country where CountryId=" + pi.CountryId + " "; command.ExecuteNonQuery(); transaction.Commit(); Pcountry.status = "Success"; } catch (Exception ex) { transaction.Rollback(); } finally { } } catch (Exception ec) { Pcountry.status = "Fail"; } sJSONResponse = JsonConvert.SerializeObject(Pcountry); return(sJSONResponse); }