public SaveTempOrder AddOrder(Order order)
{
SaveTempOrder SaveTempOrder = new SaveTempOrder();
int orderId = 0;
string insertProcedure = "[CreatNewOrderTemp]";
if (order.OrderId == 0)
{
insertProcedure = "[CreatNewOrderTemp]";
}
else
{
insertProcedure = "[UpdateNewOrderTemp]";
}
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (order.OrderId != 0)
{
insertCommand.Parameters.AddWithValue("@OrderID", order.OrderId);
}
else
{
insertCommand.Parameters.AddWithValue("@OrderID", 0);
}
if (!string.IsNullOrEmpty(order.ReferenceNo))
{
insertCommand.Parameters.AddWithValue("@ReferenceNo", order.ReferenceNo);
}
else
{
insertCommand.Parameters.AddWithValue("@ReferenceNo", DBNull.Value);
}
if (!string.IsNullOrEmpty(order.Department))
{
insertCommand.Parameters.AddWithValue("@Department", order.Department);
}
else
{
insertCommand.Parameters.AddWithValue("@Department", DBNull.Value);
}
if (order.CustId != 0)
{
insertCommand.Parameters.AddWithValue("@CustId", order.CustId);
}
else
{
insertCommand.Parameters.AddWithValue("@CustId", 0);
}
if (order.UserId != 0)
{
insertCommand.Parameters.AddWithValue("@UserId", order.UserId);
}
else
{
insertCommand.Parameters.AddWithValue("@UserId", 0);
}
if (order.BranchId != 0)
{
insertCommand.Parameters.AddWithValue("@BranchId", order.BranchId);
}
else
{
insertCommand.Parameters.AddWithValue("@BranchId", 0);
}
if (order.IncoTermId != 0)
{
insertCommand.Parameters.AddWithValue("@IncoTermId", order.IncoTermId);
}
else
{
insertCommand.Parameters.AddWithValue("@IncoTermId", 0);
}
if (order.StatusId != 0)
{
insertCommand.Parameters.AddWithValue("@StatusId", order.StatusId);
}
else
{
insertCommand.Parameters.AddWithValue("@StatusId", 0);
}
if (!string.IsNullOrEmpty(order.ShippingAddress))
{
insertCommand.Parameters.AddWithValue("@ShippingAddress", order.ShippingAddress);
}
else
{
insertCommand.Parameters.AddWithValue("@ShippingAddress", DBNull.Value);
}
if (order.CountryId != 0)
{
insertCommand.Parameters.AddWithValue("@CountryId", order.CountryId);
}
else
{
insertCommand.Parameters.AddWithValue("@CountryId", 0);
}
if (!string.IsNullOrEmpty(order.CountryName))
{
insertCommand.Parameters.AddWithValue("@CountryName", order.CountryName);
}
else
{
insertCommand.Parameters.AddWithValue("@CountryName", DBNull.Value);
}
if (order.CityId != 0)
{
insertCommand.Parameters.AddWithValue("@CityId", order.CityId);
}
else
{
insertCommand.Parameters.AddWithValue("@CityId", 0);
}
if (!string.IsNullOrEmpty(order.CityName))
{
insertCommand.Parameters.AddWithValue("@CityName", order.CityName);
}
else
{
insertCommand.Parameters.AddWithValue("@CityName", DBNull.Value);
}
if (!string.IsNullOrEmpty(order.BillingAddress))
{
insertCommand.Parameters.AddWithValue("@BillingAddress", order.BillingAddress);
}
else
{
insertCommand.Parameters.AddWithValue("@BillingAddress", DBNull.Value);
}
if (!string.IsNullOrEmpty(order.CustomerComments))
{
insertCommand.Parameters.AddWithValue("@CustomerComments", order.CustomerComments);
}
else
{
insertCommand.Parameters.AddWithValue("@CustomerComments", DBNull.Value);
}
if (order.Feight != 0)
{
insertCommand.Parameters.AddWithValue("@Feight", order.Feight);
}
else
{
insertCommand.Parameters.AddWithValue("@Feight", 0);
}
if (order.IsSalesOrder != false)
{
insertCommand.Parameters.AddWithValue("@IsSalesOrder", order.IsSalesOrder);
}
else
{
insertCommand.Parameters.AddWithValue("@IsSalesOrder", 0);
}
if (order.SalesOrderNo != null)
{
insertCommand.Parameters.AddWithValue("@SalesOrderNo", order.SalesOrderNo);
}
else
{
insertCommand.Parameters.AddWithValue("@SalesOrderNo", DBNull.Value);
}
if (order.ContactName != null)
{
insertCommand.Parameters.AddWithValue("@ContactName", order.ContactName);
}
else
{
insertCommand.Parameters.AddWithValue("@ContactName", DBNull.Value);
}
if (order.ContactNum != null)
{
insertCommand.Parameters.AddWithValue("@ContactNum", order.ContactNum);
}
else
{
insertCommand.Parameters.AddWithValue("@ContactNum", DBNull.Value);
}
if (order.ContactEmail != null)
{
insertCommand.Parameters.AddWithValue("@ContactEmail", order.ContactEmail);
}
else
{
insertCommand.Parameters.AddWithValue("@ContactEmail", DBNull.Value);
}
if (order.isClosed != false)
{
insertCommand.Parameters.AddWithValue("@isClosed", order.isClosed);
}
else
{
insertCommand.Parameters.AddWithValue("@isClosed", 0);
}
if (order.isDeleted != false)
{
insertCommand.Parameters.AddWithValue("@isDeleted", order.isDeleted);
}
else
{
insertCommand.Parameters.AddWithValue("@isDeleted", 0);
}
if (!string.IsNullOrEmpty(order.DeletedReason))
{
insertCommand.Parameters.AddWithValue("@DeletedReason", order.isDeleted);
}
else
{
insertCommand.Parameters.AddWithValue("@DeletedReason", DBNull.Value);
}
insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
insertCommand.Parameters.Add("@OrderIDout", System.Data.SqlDbType.Int);
insertCommand.Parameters["@OrderIDout"].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);
SaveTempOrder.RetVal = count;
}
if (order.OrderId == 0)
{
if (insertCommand.Parameters["@OrderIDout"].Value != DBNull.Value)
{
orderId = System.Convert.ToInt32(insertCommand.Parameters["@OrderIDout"].Value);
SaveTempOrder.TempOrderID = orderId;
}
}
return(SaveTempOrder);
}
catch (Exception ex)
{
log.logErrorMessage("OrderData.AddOrder");
log.logErrorMessage(ex.StackTrace);
return(SaveTempOrder);
}
finally
{
connection.Close();
}
}
public List <dynamic> SaveOrderRequest(CustRequest custreq)
{
var OrderIDdet = new List <dynamic>();
SaveTempOrder SaveTempOrder = new SaveTempOrder();
Order ord = new Order();
if (!string.IsNullOrEmpty(custreq.OrderID))
{
ord.OrderId = Convert.ToInt64(securityHelper.Decrypt(custreq.OrderID, false));
}
else
{
ord.OrderId = 0;
}
if (!string.IsNullOrEmpty(custreq.BranchID))
{
ord.BranchId = Convert.ToInt64(custreq.BranchID);
}
else
{
ord.BranchId = 0;
}
if (!string.IsNullOrEmpty(custreq.SCity))
{
ord.CityId = Convert.ToInt64(custreq.SCity);
//ord.CityId = 1;
}
else
{
ord.CityId = 0;
}
if (!string.IsNullOrEmpty(custreq.SCountry))
{
ord.CountryId = Convert.ToInt64(custreq.SCountry);
//ord.CountryId = 1;
}
else
{
ord.CountryId = 0;
}
if (!string.IsNullOrEmpty(custreq.selectedCustomer))
{
ord.CustId = Convert.ToInt64(custreq.selectedCustomer);
}
else
{
ord.CustId = 0;
}
ord.Department = custreq.Department;
if (!string.IsNullOrEmpty(custreq.DeliveryTo))
{
ord.IncoTermId = Convert.ToInt64(custreq.DeliveryTo);
}
else
{
ord.IncoTermId = 0;
}
ord.ContactName = custreq.Sname;
ord.ContactEmail = custreq.Semail;
ord.ContactNum = custreq.Sphone;
ord.ReferenceNo = custreq.Refernce;
ord.BillingAddress = (custreq.BAdd1 + "#" + custreq.BAdd2 + "#" + custreq.BAdd3 + "#" + custreq.BCityName + "#" + custreq.BState + "#" + custreq.BZip + "#" + custreq.BCountryName);
ord.ShippingAddress = (custreq.SAdd1 + "#" + custreq.SAdd2 + "#" + custreq.SAdd3 + "#" + custreq.SCityName + "#" + custreq.SState + "#" + custreq.SZip + "#" + custreq.SCountryName);
if (!string.IsNullOrEmpty(UserID))
{
ord.UserId = Convert.ToInt64(UserID);
}
int cstOrdr = SaveCustOrder(ord);
SaveTempOrder.TempOrderID = ord.OrderId;
if (SaveTempOrder.TempOrderID != 0)
{
if (!string.IsNullOrEmpty(custreq.ApproverDetails))
{
var Data = JsonConvert.DeserializeObject <List <ApproverDetail> >(custreq.ApproverDetails);
ApproverDetail ApproverDetails = new ApproverDetail();
for (int i = 0; i < Data.Count; i++)
{
ApproverDetails = Data[i];
OrderApprover orda = new OrderApprover();
orda.OrderId = ord.OrderId;
orda.Serial = i + 1; // Need to ask customer
orda.UserId = ord.UserId;
if (ApproverDetails.AprName != null && ApproverDetails.AprEmail != null)
{
if (!string.IsNullOrEmpty(ApproverDetails.AprId))
{
orda.OAId = Convert.ToInt64(orda.OAId);
}
orda.ApproverName = ApproverDetails.AprName;
orda.ApproverTitle = ApproverDetails.AprTitle;
orda.ApproverEmail = ApproverDetails.AprEmail;
orda.isLoggedin = true; // Need to ask customer
orda.isApproved = true; // Need to ask customer
int ordap = SaveCustOrderApprover(orda);
}
}
}
}
OrderIDdet.Add(SaveTempOrder);
OrderIDdet.Add(2);
return(OrderIDdet);
}
