public ActionResult InserOrder(T_OrderHeaderModel T_Orderheader, List <T_OrderDetailModel> T_OrderDetail)
{
Order_InputBL oib = new Order_InputBL();
DataTable dtorderdetail = new DataTable();
using (var reader = ObjectReader.Create(T_OrderDetail, "OrderID", "AdminCD", "OrderItem", "StockItem", "SalePrice", "TotalAmount", "Memo", "AvailableShippingDate"))
{
dtorderdetail.Load(reader);
}
if (dtorderdetail.Rows.Count > 0)
{
if (Session["CompanyCD"] != null)
{
string CompanyCD = Session["CompanyCD"].ToString();
T_Orderheader.UpdateOperator = CompanyCD;
}
T_Orderheader.AccessPC = System.Environment.MachineName;
if (oib.Order_Input_Insert(T_Orderheader, dtorderdetail))
{
Session["Error"] = null;
return(Json(new { orderid = T_Orderheader.OrderID }, JsonRequestBehavior.AllowGet)); //return View();//RedirectToAction("../Order/Order_History/" + T_Orderheader.OrderID);
}
else
{
Session["Error"] = "Error";
return(Json(new { msg = "Error" }));
}
}
else
{
Session["Error"] = "Error";
return(Json(new { msg = "Error" }));
}
}
public Boolean Order_Input_Insert(T_OrderHeaderModel toh, DataTable dtorder)
{
try
{
BaseDL dl = new BaseDL();
SqlParameter[] prms = new SqlParameter[13];
prms[0] = new SqlParameter("@OrderID", SqlDbType.VarChar)
{
Value = toh.OrderID
};
prms[1] = new SqlParameter("@ShippingID", SqlDbType.VarChar)
{
Value = toh.ShippingID
};
if (toh.ShippingName == null)
{
prms[2] = new SqlParameter("@ShippingName", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[2] = new SqlParameter("@ShippingName", SqlDbType.VarChar)
{
Value = toh.ShippingName
};
}
if (toh.ZipCD1 == null)
{
prms[3] = new SqlParameter("@ZipCD1", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[3] = new SqlParameter("@ZipCD1", SqlDbType.VarChar)
{
Value = toh.ZipCD1
};
}
if (toh.ZipCD2 == null)
{
prms[4] = new SqlParameter("@ZipCD2", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[4] = new SqlParameter("@ZipCD2", SqlDbType.VarChar)
{
Value = toh.ZipCD2
};
}
if (toh.Address1 == null)
{
prms[5] = new SqlParameter("@Address1", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[5] = new SqlParameter("@Address1", SqlDbType.VarChar)
{
Value = toh.Address1
};
}
if (toh.Address2 == null)
{
prms[6] = new SqlParameter("@Address2", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[6] = new SqlParameter("@Address2", SqlDbType.VarChar)
{
Value = toh.Address2
};
}
if (toh.TelephoneNO == null)
{
prms[7] = new SqlParameter("@PhoneNo", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[7] = new SqlParameter("@PhoneNo", SqlDbType.VarChar)
{
Value = toh.TelephoneNO
};
}
prms[8] = new SqlParameter("@TotalAmount", SqlDbType.VarChar)
{
Value = toh.TotalAmount
};
if (toh.Memo == null)
{
prms[9] = new SqlParameter("@Memo", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[9] = new SqlParameter("@Memo", SqlDbType.VarChar)
{
Value = toh.Memo
};
}
prms[10] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar)
{
Value = toh.UpdateOperator
};
prms[11] = new SqlParameter("@AccessPC", SqlDbType.VarChar)
{
Value = toh.AccessPC
};
dtorder.TableName = "order";
System.IO.StringWriter writer = new System.IO.StringWriter();
dtorder.WriteXml(writer, XmlWriteMode.WriteSchema, false);
string result = writer.ToString();
prms[12] = new SqlParameter("@xml", SqlDbType.Xml)
{
Value = result
};
var option = new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted,
Timeout = TimeSpan.MaxValue
};
using (TransactionScope scopt = new TransactionScope(TransactionScopeOption.Required, option))
{
dl.InsertUpdateDeleteData("Order_Input_Insert", prms);
scopt.Complete();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
