private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (Seats == null || Seats.Count() == 0) { txbMessage.Text = "Please enter Rows and Columns to generate layout"; txbMessage.Height = 30; return; } txbMessage.Height = 0; var result = ModernDialog.ShowMessage("Are you sure, you want to Save Layout ?", "Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { ManageLoadingDataVisibility(false, true); Screenclasses objScreenclasses = new Screenclasses(); objScreenclasses.ScreenId = Convert.ToInt32(cmbScreen.SelectedValue); objScreenclasses.ScreenClassId = Convert.ToInt32(cmbClass.SelectedValue); objScreenclasses.RowCount = Convert.ToInt32(txtRows.Text); objScreenclasses.ColumnCount = Convert.ToInt32(txtColumns.Text); objScreenclasses.seats = new List <Seat>(); foreach (SeatProperties sp in Seats.Where(w => w.Column != 0 && w.Row != 0)) { objScreenclasses.seats.Add(new Seat() { ColumnText = Convert.ToString(sp.ColumnText), ColumnValue = sp.Column, RowText = sp.RowText, RowValue = sp.Row }); } int insertRresult = new SeatLayoutConfig().BulkInsertSeat(objScreenclasses); if (insertRresult == 1) { Helper.LoadDropDownSource(cmbClass, new SeatLayoutConfig().GetScreeClasses(Convert.ToInt32(cmbScreen.SelectedValue)), "ScreenClassName", "ScreenClassId", false); } ModernDialog.ShowMessage(insertRresult == 1 ? "Screen Layout saved succefully" : "Unable to save Screen Layout at this moment.. Try after sometime", "Alert", MessageBoxButton.OK); ManageLoadingDataVisibility(false, false); } } catch (Exception ex) { ManageLoadingDataVisibility(false, false); LogExceptions.LogException(ex); } }
public int InsertCustomTicketPrices(Screenclasses sc) { try { var p = new DynamicParameters(); p.Add("@MovieTimingId", sc.MovieTimingId); p.Add("@ScreenClassesId", sc.ScreenClassId); p.Add("@Price", sc.TicketPrice); p.Add("@CGST", sc.CGST); p.Add("@SGST", sc.SGST); p.Add("@MC", sc.MC); p.Add("@Output", dbType: DbType.Int32, direction: ParameterDirection.Output); const string storedprocedure = "dbo.sp_ins_CustomTicketPrices"; con.Query <int>(storedprocedure, p, commandType: CommandType.StoredProcedure).FirstOrDefault(); return(p.Get <int>("@Output")); } catch (Exception ex) { throw ex; } }
public int BulkInsertSeat(Screenclasses sc) { try { // con = new SqlConnection(connectionString); using (SqlBulkCopy sbc = new SqlBulkCopy(connectionString)) { DataTable data = new DataTable(); #region datatable definition DataColumn column; column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "FK_ScreenClasses_ID"; data.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "FK_SeatStatus_ID"; data.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "RowValue"; data.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "RowText"; data.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "ColumnValue"; data.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "ColumnText"; data.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "FK_Screens_ID"; data.Columns.Add(column); #endregion foreach (Seat objSeat in sc.seats) { DataRow newRow = data.NewRow(); newRow["FK_ScreenClasses_ID"] = sc.ScreenClassId; newRow["FK_SeatStatus_ID"] = !string.IsNullOrEmpty(objSeat.ColumnText) && !string.IsNullOrEmpty(objSeat.RowText) ? "1" : "0"; newRow["RowValue"] = objSeat.RowValue; newRow["RowText"] = objSeat.RowText; newRow["ColumnValue"] = objSeat.ColumnValue; newRow["ColumnText"] = !string.IsNullOrEmpty(objSeat.ColumnText) && !string.IsNullOrEmpty(objSeat.RowText) ? objSeat.ColumnText : "999"; newRow["FK_Screens_ID"] = sc.ScreenId; data.Rows.Add(newRow); } List <SqlBulkCopyColumnMapping> mappings = new List <SqlBulkCopyColumnMapping>(); SqlBulkCopyColumnMapping screenClassID = new SqlBulkCopyColumnMapping("FK_ScreenClasses_ID", "FK_ScreenClasses_ID"); mappings.Add(screenClassID); SqlBulkCopyColumnMapping RowValue = new SqlBulkCopyColumnMapping("RowValue", "RowValue"); mappings.Add(RowValue); SqlBulkCopyColumnMapping RowText = new SqlBulkCopyColumnMapping("RowText", "RowText"); mappings.Add(RowText); SqlBulkCopyColumnMapping ColumnValue = new SqlBulkCopyColumnMapping("ColumnValue", "ColumnValue"); mappings.Add(ColumnValue); SqlBulkCopyColumnMapping ColumnText = new SqlBulkCopyColumnMapping("ColumnText", "ColumnText"); mappings.Add(ColumnText); SqlBulkCopyColumnMapping SeatStatus = new SqlBulkCopyColumnMapping("FK_SeatStatus_ID", "FK_SeatStatus_ID"); mappings.Add(SeatStatus); SqlBulkCopyColumnMapping ScreenId = new SqlBulkCopyColumnMapping("FK_Screens_ID", "FK_Screens_ID"); mappings.Add(ScreenId); if (mappings != null) { foreach (SqlBulkCopyColumnMapping map in mappings) { sbc.ColumnMappings.Add(map); } } sbc.DestinationTableName = "dbo.Seats"; sbc.WriteToServer(data); return(1); } } catch (Exception ex) { throw ex; } }
private int InsertScreenClass(Screenclasses screenClass) { return(1); }