//Order IT setup public List <dynamic> AddOrderITSetUp(OrderItsetupUI OrderItsetupUI) { List <dynamic> ObjDynamic = new List <dynamic>(); OrderItsetupDTO orderItsetupDTO = new OrderItsetupDTO(); string strOrderID = securityHelper.Decrypt(OrderItsetupUI.strOrderID, false); try { orderItsetupDTO.ITSetUpId = OrderItsetupUI.ITSetUpId; orderItsetupDTO.OrderId = Convert.ToInt64(strOrderID); orderItsetupDTO.ProductId = OrderItsetupUI.ProductId; orderItsetupDTO.Type = OrderItsetupUI.Type; orderItsetupDTO.Serial = OrderItsetupUI.Serial; orderItsetupDTO.UserName = OrderItsetupUI.UserName; orderItsetupDTO.UserTypeId = OrderItsetupUI.UserTypeId; orderItsetupDTO.WorkLocationId = OrderItsetupUI.WorkLocationId; orderItsetupDTO.DeliveryLocation = OrderItsetupUI.DeliveryLocation; orderItsetupDTO.Department = OrderItsetupUI.Department; orderItsetupDTO.Applications = OrderItsetupUI.Applications; orderItsetupDTO.SpecialInstructions = OrderItsetupUI.SpecialInstructions; orderItsetupDTO.MigrateInfo = OrderItsetupUI.MigrateInfo; orderItsetupDTO.isActive = OrderItsetupUI.isActive; CRUDorderItsetup(orderItsetupDTO); ObjDynamic.Add(orderItsetupDTO); return(ObjDynamic); } catch (Exception ex) { return(ObjDynamic); } }
///insert data orderItsetup /// private int CRUDorderItsetup(OrderItsetupDTO orderItsetup) { string insertProcedure = "[CreateOrderITSetup]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; int ITSetUpId = 0; if (orderItsetup.ITSetUpId != 0) { insertCommand.Parameters.AddWithValue("@ITSetUpId", orderItsetup.ITSetUpId); } else { insertCommand.Parameters.AddWithValue("@ITSetUpId", 0); } if (orderItsetup.OrderId != 0) { insertCommand.Parameters.AddWithValue("@OrderId", orderItsetup.OrderId); } else { insertCommand.Parameters.AddWithValue("@OrderId", 0); } if (orderItsetup.ProductId != 0) { insertCommand.Parameters.AddWithValue("@ProductId", orderItsetup.ProductId); } else { insertCommand.Parameters.AddWithValue("@ProductId", 0); } if (orderItsetup.Serial != 0) { insertCommand.Parameters.AddWithValue("@Serial", orderItsetup.Serial); } else { insertCommand.Parameters.AddWithValue("@Serial", 0); } if (!string.IsNullOrEmpty(orderItsetup.UserName)) { insertCommand.Parameters.AddWithValue("@UserName", orderItsetup.UserName); } else { insertCommand.Parameters.AddWithValue("@UserName", DBNull.Value); } if (orderItsetup.UserTypeId != 0) { insertCommand.Parameters.AddWithValue("@UserTypeId", orderItsetup.UserTypeId); } else { insertCommand.Parameters.AddWithValue("@UserTypeId", 0); } if (orderItsetup.WorkLocationId != 0) { insertCommand.Parameters.AddWithValue("@WorkLocationId", orderItsetup.WorkLocationId); } else { insertCommand.Parameters.AddWithValue("@WorkLocationId", 0); } if (!string.IsNullOrEmpty(orderItsetup.DeliveryLocation)) { insertCommand.Parameters.AddWithValue("@DeliveryLocation", orderItsetup.DeliveryLocation); } else { insertCommand.Parameters.AddWithValue("@DeliveryLocation", DBNull.Value); } if (!string.IsNullOrEmpty(orderItsetup.Department)) { insertCommand.Parameters.AddWithValue("@Department", orderItsetup.Department); } else { insertCommand.Parameters.AddWithValue("@Department", DBNull.Value); } if (!string.IsNullOrEmpty(orderItsetup.Applications)) { insertCommand.Parameters.AddWithValue("@Applications", orderItsetup.Applications); } else { insertCommand.Parameters.AddWithValue("@Applications", DBNull.Value); } if (!string.IsNullOrEmpty(orderItsetup.SpecialInstructions)) { insertCommand.Parameters.AddWithValue("@SpecialInstructions", orderItsetup.SpecialInstructions); } else { insertCommand.Parameters.AddWithValue("@SpecialInstructions", DBNull.Value); } if (orderItsetup.MigrateInfo != 0) { insertCommand.Parameters.AddWithValue("@MigrateInfo", orderItsetup.MigrateInfo); } else { insertCommand.Parameters.AddWithValue("@MigrateInfo", 0); } if (orderItsetup.isActive) { insertCommand.Parameters.AddWithValue("@isActive", orderItsetup.isActive); } else { insertCommand.Parameters.AddWithValue("@isActive", 0); } if (Convert.ToInt64(UserID) != 0) { insertCommand.Parameters.AddWithValue("@UserId", Convert.ToInt64(UserID)); } else { insertCommand.Parameters.AddWithValue("@UserId", 0); } if (orderItsetup.Type != 0) { insertCommand.Parameters.AddWithValue("@Type", orderItsetup.Type); } else { insertCommand.Parameters.AddWithValue("@Type", 0); } insertCommand.Parameters.Add("@ITSetUpIdOut", System.Data.SqlDbType.Int); insertCommand.Parameters["@ITSetUpIdOut"].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 && orderItsetup.ITSetUpId == 0) { orderItsetup.ITSetUpId = Convert.ToInt32(insertCommand.Parameters["@ITSetUpIdOut"].Value); } return(ITSetUpId); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(ITSetUpId); } finally { connection.Close(); } }