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