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);
}
