public static void OnBeforeInsertStep(ITicketProduct ticketproduct, ISession session) { // TODO: Complete business rule implementation /*if(ticketproduct.Quantity <= 0) * { * throw new ApplicationException("Enter Quantity of selected product..."); * } * * * * * Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>(); * System.Data.OleDb.OleDbConnection conObj1 = new System.Data.OleDb.OleDbConnection(service.GetConnectionString()); * conObj1.Open(); * string query1 = "Select MAX(isnull(CP.QUANTITY,0)) - SUM(isnull(TP.Quantity,0)) Qty From TICKETPRODUCT TP "+ * "LEFT JOIN CONTRACTPRODUCTITEM CP ON TP.ContractProductItemID = CP.ContractProductItemID " + * "where TP.ContractProductItemID = '"+ ticketproduct.ContractProductItemID + "' group by TP.PRODUCTID"; * * System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query1, conObj1); * System.Data.OleDb.OleDbDataReader dr; * * dr = cmd.ExecuteReader(); * if (dr.HasRows == true) * { * if(Convert.ToInt32(dr.row[0][0]) < 0) * { * throw new ApplicationException("Quantity is exeeded the limit with " + Convert.ToInt32(dr.row[0][0])); * } * }*/ }
public static void OnBeforeInsertStep( ITicketProduct ticketproduct, ISession session) { // TODO: Complete business rule implementation /*if(ticketproduct.Quantity <= 0) { throw new ApplicationException("Enter Quantity of selected product..."); } Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>(); System.Data.OleDb.OleDbConnection conObj1 = new System.Data.OleDb.OleDbConnection(service.GetConnectionString()); conObj1.Open(); string query1 = "Select MAX(isnull(CP.QUANTITY,0)) - SUM(isnull(TP.Quantity,0)) Qty From TICKETPRODUCT TP "+ "LEFT JOIN CONTRACTPRODUCTITEM CP ON TP.ContractProductItemID = CP.ContractProductItemID " + "where TP.ContractProductItemID = '"+ ticketproduct.ContractProductItemID + "' group by TP.PRODUCTID"; System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query1, conObj1); System.Data.OleDb.OleDbDataReader dr; dr = cmd.ExecuteReader(); if (dr.HasRows == true) { if(Convert.ToInt32(dr.row[0][0]) < 0) { throw new ApplicationException("Quantity is exeeded the limit with " + Convert.ToInt32(dr.row[0][0])); } }*/ }