public List <dynamic> AddGrantCodeOrders(GrantCodeMasterDTO grantCodeMasterDTO) { List <dynamic> objDynamic = new List <dynamic>(); var Data = JsonConvert.DeserializeObject <List <GrantCodeMaster> >(grantCodeMasterDTO.GrantCodeMaster); Int64 OrderID = 0, CustID = 0, GrantOrderSerialId = 0; OrderID = Convert.ToInt64(securityHelper.Decrypt(grantCodeMasterDTO.OrderID, false)); CustID = Convert.ToInt64(CustomerID); GrantCodeOrders grantCodeOrders = new GrantCodeOrders(); GrantCodeMaster grantCodeMaster = new GrantCodeMaster(); GrantCodeWiseOrderTotal grantCodeWiseOrderTotal = new GrantCodeWiseOrderTotal(); grantCodeOrders.OrderId = OrderID; grantCodeOrders.CustId = CustID; grantCodeOrders.NoofGrantCodes = Data.Count; AddGrantCodeOrders(grantCodeOrders); grantCodeWiseOrderTotal.GrantOrderId = grantCodeOrders.GrantOrderId; grantCodeWiseOrderTotal.Serial = grantCodeOrders.NoofGrantCodes; GrantOrderSerialId = AddGrantCodeWiseOrderTotal(grantCodeWiseOrderTotal); for (int i = 0; i < Data.Count; i++) { grantCodeMaster = Data[i]; GrantCodeOrderDetails grantCodeOrderDetails = new GrantCodeOrderDetails(); grantCodeOrderDetails.GrantOrderSerialId = GrantOrderSerialId; grantCodeOrderDetails.Serial = i + 1; grantCodeOrderDetails.Value = grantCodeMaster.Data; grantCodeOrderDetails.GrantId = grantCodeMaster.GrantId; AddGrntCodeOrdrDetls(grantCodeOrderDetails); } return(GrantCodeOrderDetails(grantCodeMasterDTO.OrderID)); }
private int SaveGrantCodeOrders(GrantCodeOrders grantCO) { int BudgetId = 0; string updateProcedure = "[UpdateGrantCodeOrders]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (grantCO.GrantOrderId != 0) { updateCommand.Parameters.AddWithValue("@GrantOrderId", grantCO.GrantOrderId); } else { updateCommand.Parameters.AddWithValue("@GrantOrderId", 0); } if (grantCO.OrderId != 0) { updateCommand.Parameters.AddWithValue("@OrderId", grantCO.OrderId); } else { updateCommand.Parameters.AddWithValue("@OrderId", 0); } if (grantCO.CustId != 0) { updateCommand.Parameters.AddWithValue("@CustId", grantCO.CustId); } else { updateCommand.Parameters.AddWithValue("@CustId", 0); } if (grantCO.NoofGrantCodes != 0) { updateCommand.Parameters.AddWithValue("@NoofGrantCodes", grantCO.NoofGrantCodes); } else { updateCommand.Parameters.AddWithValue("@NoofGrantCodes", 0); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; updateCommand.Parameters.Add("@BudgetIdout", System.Data.SqlDbType.Int); updateCommand.Parameters["@BudgetIdout"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); updateCommand.ExecuteNonQuery(); if (updateCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); } if (updateCommand.Parameters["@BudgetIdout"].Value != DBNull.Value) { BudgetId = System.Convert.ToInt32(updateCommand.Parameters["@BudgetIdout"].Value); } return(BudgetId); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(BudgetId); } finally { connection.Close(); } }
private GrantCodeOrders AddGrantCodeOrders(GrantCodeOrders grantCO) { Int64 GrantCodeID = 0; int numGrantcode = 0; string insertProcedure = "[CreatGrantCodeOrders]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (grantCO.OrderId != 0) { insertCommand.Parameters.AddWithValue("@OrderId", grantCO.OrderId); } else { insertCommand.Parameters.AddWithValue("@OrderId", 0); } insertCommand.Parameters.Add("@NoofGrantCodes", System.Data.SqlDbType.Int); insertCommand.Parameters["@NoofGrantCodes"].Direction = ParameterDirection.Output; insertCommand.Parameters.Add("@GrantOrderId", System.Data.SqlDbType.Int); insertCommand.Parameters["@GrantOrderId"].Direction = ParameterDirection.Output; insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); insertCommand.ExecuteNonQuery(); if (insertCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); } if (count != 0) { if (insertCommand.Parameters["@GrantOrderId"].Value != DBNull.Value) { GrantCodeID = System.Convert.ToInt32(insertCommand.Parameters["@GrantOrderId"].Value); } if (insertCommand.Parameters["@NoofGrantCodes"].Value != DBNull.Value) { numGrantcode = System.Convert.ToInt32(insertCommand.Parameters["@NoofGrantCodes"].Value); } } grantCO.GrantOrderId = GrantCodeID; grantCO.NoofGrantCodes = numGrantcode; return(grantCO); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(grantCO); } finally { connection.Close(); } }