public IActionResult InsertTransLine([FromBody] EposTransLine m, string customerId, string storeId, string tillId) { if (ModelState.IsValid) { int result = repo.InsertTransLine(m, customerId, storeId, tillId); return(Ok(result)); } else { return(BadRequest(ModelState)); } }
public int InsertTransLine(EposTransLine m, string CustomerId, string StoreId, string TillId) { EposTransLineDA eposTransLineDa = new EposTransLineDA(); return(eposTransLineDa.InsertTransLine(ConnectionString, CustomerId, StoreId, TillId, m)); }
public List <EposTransLine> GetTransLinesByTransId(string connectionString, string CustomerId, string StoreId, string TillId, int TransId) { List <EposTransLine> lm = new List <EposTransLine>(); string Sql = ""; #region SQL Sql += "select Amount,Barcode,Bar_Print,Bar_Printed,Bar_Printed_Time,"; Sql += "Department_Id,[Description],Discount_Amount,Discountable,Discount_Percentage,"; Sql += "ELNo,Entry_Type,Free_Text,IsModifier,Item_Group,"; Sql += "Item_Sub_Group,Kitchen_Print,Kitchen_Printed,Kitchen_Printed_Time,"; Sql += "Line_No,Line_Status,LinkedOfferId,Main_Item_No,Mandatory,"; Sql += "Net_Amount,Number,OfferID,OfferQuantity,OfferTrigger,"; Sql += "OrderType,Payment_Type,Price,Print_Group,Quantity,"; Sql += "Scale,Scanned,Served,Split_Group,Staff_Id,"; Sql += "Store_ID,Temp_Item,Till_Id,Total_Cost,Trans_Date,"; Sql += "Trans_ID,Unit_Cost,VAT_Amount,VAT_Code,VAT_Rate "; Sql += "IsChange,IsRefund "; Sql += "from " + CustomerId + "_" + StoreId + "_" + TillId + "_" + "EPOS_Trans_Line "; Sql += "where Trans_ID=@Trans_ID "; Sql += "Order by Line_No desc "; #endregion SQL #region Execute SQL using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(Sql, connection)) { #region Param SqlParameter param = new SqlParameter(); param.ParameterName = "@Trans_ID"; param.Value = TransId; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion Param SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { EposTransLine m = new EposTransLine(); #region Fill Model //Amount,Barcode,Bar_Print,Bar_Printed,Bar_Printed_Time, #region Line 1 try{ m.Amount = reader.GetDecimal(0); }catch {} try{ m.Barcode = reader.GetString(1); }catch {} try{ m.BarPrint = reader.GetBoolean(2); }catch {} try{ m.BarPrinted = reader.GetBoolean(3); }catch {} try{ m.BarPrintedTime = reader.GetDateTime(4); }catch {} #endregion Line 1 //Department_Id,[Description],Discount_Amount,Discountable,Discount_Percentage, #region Line 2 try{ m.DepartmentId = reader.GetString(5); }catch {} try{ m.Description = reader.GetString(6); }catch {} try{ m.DiscountAmount = reader.GetDecimal(7); }catch {} try{ m.Discountable = reader.GetBoolean(8); }catch {} try{ m.DiscountPercentage = reader.GetDecimal(9); }catch {} #endregion Line 2 //ELNo,Entry_Type,Free_Text,IsModifier,Item_Group, #region Line 3 try{ m.Elno = reader.GetInt32(10); }catch {} try{ m.EntryType = reader.GetInt32(11); }catch {} try{ m.FreeText = reader.GetString(12); }catch {} try{ m.IsModifier = reader.GetBoolean(13); }catch {} try{ m.ItemGroup = reader.GetString(14); }catch {} #endregion Line 3 //Item_Sub_Group,Kitchen_Print,Kitchen_Printed,Kitchen_Printed_Time, #region Line 4 try{ m.ItemSubGroup = reader.GetString(15); }catch {} try{ m.KitchenPrint = reader.GetBoolean(16); }catch {} try{ m.KitchenPrinted = reader.GetBoolean(17); }catch {} try{ m.KitchenPrintedTime = reader.GetDateTime(18); }catch {} #endregion Line 4 //Line_No,Line_Status,LinkedOfferId,Main_Item_No,Mandatory, #region Line 5 try{ m.LineNo = reader.GetInt32(19); }catch {} try{ m.LineStatus = reader.GetBoolean(20); }catch {} try{ m.LinkedOfferId = reader.GetInt32(21); }catch {} try{ m.MainItemNo = reader.GetString(22); }catch {} try{ m.Mandatory = reader.GetBoolean(23); }catch {} #endregion Line 5 //Net_Amount,Number,OfferID,OfferQuantity,OfferTrigger, #region Line 6 try{ m.NetAmount = reader.GetDecimal(24); }catch {} try{ m.Number = reader.GetString(25); }catch {} try{ m.OfferID = reader.GetString(26); }catch {} try{ m.OfferQuantity = reader.GetDecimal(27); }catch {} try{ m.OfferTrigger = reader.GetBoolean(28); }catch {} #endregion Line 6 //OrderType,Payment_Type,Price,Print_Group,Quantity, #region Line 7 try{ m.OrderType = reader.GetInt32(29); }catch {} try{ m.PaymentType = reader.GetInt32(30); }catch {} try{ m.Price = reader.GetDecimal(31); }catch {} try{ m.PrintGroup = reader.GetString(32); }catch {} try{ m.Quantity = reader.GetDecimal(33); }catch {} #endregion Line 7 //Scale,Scanned,Served,Split_Group,Staff_Id, #region Line 8 try{ m.Scale = reader.GetBoolean(34); }catch {} try{ m.Scanned = reader.GetBoolean(35); }catch {} try{ m.Served = reader.GetBoolean(36); }catch {} try{ m.SplitGroup = reader.GetBoolean(37); }catch {} try{ m.StaffId = reader.GetString(38); }catch {} #endregion Line 8 //Store_ID,Temp_Item,Till_Id,Total_Cost,Trans_Date, #region Line 9 try{ m.StoreId = reader.GetString(39); }catch {} try{ m.TempItem = reader.GetBoolean(40); }catch {} try{ m.TillId = reader.GetString(41); }catch {} try{ m.TotalCost = reader.GetDecimal(42); }catch {} try{ m.TransDate = reader.GetDateTime(43); }catch {} #endregion Line 9 //Trans_ID,Unit_Cost,VAT_Amount,VAT_Code,VAT_Rate #region Line 10 try{ m.TransId = reader.GetInt32(44); }catch {} try{ m.UnitCost = reader.GetDecimal(45); }catch {} try{ m.VatAmount = reader.GetDecimal(46); }catch {} try{ m.VatCode = reader.GetString(47); }catch {} try{ m.VatRate = reader.GetDecimal(48); }catch {} #endregion Line 10 //IsChange,IsRefund #region Line 11 try{ m.IsChange = reader.GetBoolean(49); }catch {} try{ m.IsRefund = reader.GetBoolean(50); }catch {} #endregion Line 11 #endregion Fill Model lm.Add(m); } } } #endregion Execute SQL return(lm); }
public int InsertTransLine(string connectionString, string CustomerId, string StoreId, string TillId, EposTransLine m) { int result = 0; string Sql = ""; #region SQL Sql += "insert into " + CustomerId + "_" + StoreId + "_" + TillId + "_" + "EPOS_Trans_Line "; Sql += "(Amount,Barcode,Bar_Print,Bar_Printed,Bar_Printed_Time, "; Sql += "Department_Id,[Description],Discount_Amount,Discountable,Discount_Percentage, "; Sql += "Entry_Type,Free_Text,IsModifier,Item_Group,Item_Sub_Group, "; Sql += "Kitchen_Print,Kitchen_Printed,Kitchen_Printed_Time,Line_No,Line_Status, "; Sql += "LinkedOfferId,Main_Item_No,Mandatory,Net_Amount,Number, "; Sql += "OfferID,OfferQuantity,OfferTrigger,OrderType,Payment_Type, "; Sql += "Price,Print_Group,Quantity,Scale,Scanned, "; Sql += "Served,Split_Group,Staff_Id,Store_ID,Temp_Item, "; Sql += "Till_Id,Total_Cost,Trans_Date,Trans_ID,Unit_Cost, "; Sql += "VAT_Amount,VAT_Code,VAT_Rate,IsChange,IsRefund) "; Sql += "values "; Sql += "(@Amount,@Barcode,@Bar_Print,@Bar_Printed,@Bar_Printed_Time, "; //1 5 Sql += "@Department_Id,@Description,@Discount_Amount,@Discountable,@Discount_Percentage, "; //2 5 Sql += "@Entry_Type,@Free_Text,@IsModifier,@Item_Group,@Item_Sub_Group, "; //3 5 Sql += "@Kitchen_Print,@Kitchen_Printed,@Kitchen_Printed_Time,@Line_No,@Line_Status, "; //4 5 Sql += "@LinkedOfferId,@Main_Item_No,@Mandatory,@Net_Amount,@Number, "; //5 5 Sql += "@OfferID,@OfferQuantity,@OfferTrigger,@OrderType,@Payment_Type, "; //6 5 Sql += "@Price,@Print_Group,@Quantity,@Scale,@Scanned, "; //7 5 Sql += "@Served,@Split_Group,@Staff_Id,@Store_ID,@Temp_Item, "; //8 5 Sql += "@Till_Id,@Total_Cost,@Trans_Date,@Trans_ID,@Unit_Cost, "; //9 5 Sql += "@VAT_Amount,@VAT_Code,@VAT_Rate,@IsChange,@IsRefund) "; //10 5 #endregion SQL #region Execute SQL using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(Sql, connection)) { #region Param //@Amount,@Barcode,@Bar_Print,@Bar_Printed,@Bar_Printed_Time, #region Line 1 #region @Amount SqlParameter param = new SqlParameter(); param.ParameterName = "@Amount"; param.Value = m.Amount; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Amount #region @Barcode param = new SqlParameter(); param.ParameterName = "@Barcode"; param.Value = m.Barcode; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @Barcode #region @Bar_Print param = new SqlParameter(); param.ParameterName = "@Bar_Print"; param.Value = m.BarPrint; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Bar_Print #region @Bar_Printed param = new SqlParameter(); param.ParameterName = "@Bar_Printed"; param.Value = m.BarPrinted; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Bar_Printed #region @Bar_Printed_Time param = new SqlParameter(); param.ParameterName = "@Bar_Printed_Time"; param.Value = m.BarPrintedTime; param.DbType = DbType.DateTime; command.Parameters.Add(param); #endregion @Bar_Printed_Time #endregion Line 1 //@Department_Id,@Description,@Discount_Amount,@Discountable,@Discount_Percentage, #region Line 2 #region @Department_Id param = new SqlParameter(); param.ParameterName = "@Department_Id"; param.Value = m.DepartmentId; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); #endregion @Department_Id #region @Description param = new SqlParameter(); param.ParameterName = "@Description"; param.Value = m.Description; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); #endregion @Description #region @Discount_Amount param = new SqlParameter(); param.ParameterName = "@Discount_Amount"; param.Value = m.DiscountAmount; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Discount_Amount #region @Discountable param = new SqlParameter(); param.ParameterName = "@Discountable"; param.Value = m.Discountable; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Discountable #region @Discount_Percentage param = new SqlParameter(); param.ParameterName = "@Discount_Percentage"; param.Value = m.DiscountPercentage; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Discount_Percentage #endregion Line 2 //@Entry_Type,@Free_Text,@IsModifier,@Item_Group,@Item_Sub_Group, #region Line 3 #region @Entry_Type param = new SqlParameter(); param.ParameterName = "@Entry_Type"; param.Value = m.EntryType; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion @Entry_Type #region @Free_Text param = new SqlParameter(); param.ParameterName = "@Free_Text"; param.Value = m.FreeText; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); #endregion @Free_Text #region @IsModifier param = new SqlParameter(); param.ParameterName = "@IsModifier"; param.Value = m.IsModifier; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @IsModifier #region @Item_Group param = new SqlParameter(); param.ParameterName = "@Item_Group"; param.Value = m.ItemGroup; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); #endregion @Item_Group #region @Item_Sub_Group param = new SqlParameter(); param.ParameterName = "@Item_Sub_Group"; param.Value = m.ItemSubGroup; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); #endregion @Item_Sub_Group #endregion Line 3 //@Kitchen_Print,@Kitchen_Printed,@Kitchen_Printed_Time,@Line_No,@Line_Status, #region Line 4 #region @Kitchen_Print param = new SqlParameter(); param.ParameterName = "@Kitchen_Print"; param.Value = m.KitchenPrint; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Kitchen_Print #region @Kitchen_Printed param = new SqlParameter(); param.ParameterName = "@Kitchen_Printed"; param.Value = m.KitchenPrinted; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Kitchen_Printed #region @Kitchen_Printed_Time param = new SqlParameter(); param.ParameterName = "@Kitchen_Printed_Time"; param.Value = m.KitchenPrintedTime; param.DbType = DbType.DateTime; command.Parameters.Add(param); #endregion @Kitchen_Printed_Time #region @Line_No param = new SqlParameter(); param.ParameterName = "@Line_No"; param.Value = m.LineNo; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion @Line_No #region @Line_Status param = new SqlParameter(); param.ParameterName = "@Line_Status"; param.Value = m.LineStatus; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Line_Status #endregion Line 4 //@LinkedOfferId,@Main_Item_No,@Mandatory,@Net_Amount,@Number, #region Line 5 #region @LinkedOfferId param = new SqlParameter(); param.ParameterName = "@LinkedOfferId"; param.Value = m.LinkedOfferId; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion @LinkedOfferId #region @Main_Item_No param = new SqlParameter(); param.ParameterName = "@Main_Item_No"; param.Value = m.MainItemNo; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @Main_Item_No #region @Mandatory param = new SqlParameter(); param.ParameterName = "@Mandatory"; param.Value = m.Mandatory; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Mandatory #region @Net_Amount param = new SqlParameter(); param.ParameterName = "@Net_Amount"; param.Value = m.NetAmount; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Net_Amount #region @Number param = new SqlParameter(); param.ParameterName = "@Number"; param.Value = m.Number; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @Number #endregion Line 5 //@OfferID,@OfferQuantity,@OfferTrigger,@OrderType,@Payment_Type, #region Line 6 #region @OfferID param = new SqlParameter(); param.ParameterName = "@OfferID"; param.Value = m.OfferID; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @OfferID #region @OfferQuantity param = new SqlParameter(); param.ParameterName = "@OfferQuantity"; param.Value = m.OfferQuantity; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @OfferQuantity #region @OfferTrigger param = new SqlParameter(); param.ParameterName = "@OfferTrigger"; param.Value = m.OfferTrigger; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @OfferTrigger #region @OrderType param = new SqlParameter(); param.ParameterName = "@OrderType"; param.Value = m.OrderType; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion @OrderType #region @Payment_Type param = new SqlParameter(); param.ParameterName = "@Payment_Type"; param.Value = m.PaymentType; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion @Payment_Type #endregion Line 6 //@Price,@Print_Group,@Quantity,@Scale,@Scanned, #region Line 7 #region @Price param = new SqlParameter(); param.ParameterName = "@Price"; param.Value = m.Price; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Price #region @Print_Group param = new SqlParameter(); param.ParameterName = "@Print_Group"; param.Value = m.PrintGroup; param.DbType = DbType.String; param.Size = 10; command.Parameters.Add(param); #endregion @Print_Group #region @Quantity param = new SqlParameter(); param.ParameterName = "@Quantity"; param.Value = m.Quantity; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Quantity #region @Scale param = new SqlParameter(); param.ParameterName = "@Scale"; param.Value = m.Scale; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Scale #region @Scanned param = new SqlParameter(); param.ParameterName = "@Scanned"; param.Value = m.Scanned; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Scanned #endregion Line 7 //@Served,@Split_Group,@Staff_Id,@Store_ID,@Temp_Item, #region Line 8 #region @Served param = new SqlParameter(); param.ParameterName = "@Served"; param.Value = m.Served; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Served #region @Split_Group param = new SqlParameter(); param.ParameterName = "@Split_Group"; param.Value = m.SplitGroup; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Split_Group #region @Staff_Id param = new SqlParameter(); param.ParameterName = "@Staff_Id"; param.Value = m.StaffId; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @Staff_Id #region @Store_ID param = new SqlParameter(); param.ParameterName = "@Store_ID"; param.Value = m.StoreId; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @Store_ID #region @Temp_Item param = new SqlParameter(); param.ParameterName = "@Temp_Item"; param.Value = m.TempItem; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @Temp_Item #endregion Line 8 //@Till_Id,@Total_Cost,@Trans_Date,@Trans_ID,@Unit_Cost, #region Line 9 #region @Till_Id param = new SqlParameter(); param.ParameterName = "@Till_Id"; param.Value = m.TillId; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @Till_Id #region @Total_Cost param = new SqlParameter(); param.ParameterName = "@Total_Cost"; param.Value = m.TotalCost; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Total_Cost #region @Trans_Date param = new SqlParameter(); param.ParameterName = "@Trans_Date"; param.Value = m.TransDate; param.DbType = DbType.DateTime; command.Parameters.Add(param); #endregion @Trans_Date #region @Trans_ID param = new SqlParameter(); param.ParameterName = "@Trans_ID"; param.Value = m.TransId; param.DbType = DbType.Int32; command.Parameters.Add(param); #endregion @Trans_ID #region @Unit_Cost param = new SqlParameter(); param.ParameterName = "@Unit_Cost"; param.Value = m.UnitCost; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @Unit_Cost #endregion Line 9 //@VAT_Amount,@VAT_Code,@VAT_Rate,@IsChange,@IsRefund #region Line 10 #region @VAT_Amount param = new SqlParameter(); param.ParameterName = "@VAT_Amount"; param.Value = m.VatAmount; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @VAT_Amount #region @VAT_Code param = new SqlParameter(); param.ParameterName = "@VAT_Code"; param.Value = m.VatCode; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); #endregion @VAT_Code #region @VAT_Rate param = new SqlParameter(); param.ParameterName = "@VAT_Rate"; param.Value = m.VatRate; param.DbType = DbType.Decimal; command.Parameters.Add(param); #endregion @VAT_Rate #region @IsChange param = new SqlParameter(); param.ParameterName = "@IsChange"; param.Value = m.IsChange; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @IsChange #region @IsRefund param = new SqlParameter(); param.ParameterName = "@IsRefund"; param.Value = m.IsRefund; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion @IsRefund #endregion Line 10 #endregion Param result = command.ExecuteNonQuery(); } } #endregion Execute SQL return(result); }