private void BindCustomerInfo()
{
try
{
Qtm.Lib.OrderModifiCustomerInfo obj = Qtm.Lib.OrderModifiCustomerInfo.FindCustomerForBlanketOrder(Request["OrderNo"].ToString());
if (obj != null)
{
l_CustName.Text = obj.Name;
l_CustAdd.Text = obj.Address1 + " " + obj.Address2 + " " + obj.City + " " + obj.PostCode;
l_CustConNo.Text = obj.PhoneNo;
txtCustomerReferenceNo.Text = obj.Cust_Ref_No;
}
Qtm.Lib.OrderModifiCustomerInfo objc = Qtm.Lib.OrderModifiCustomerInfo.FindConsigneeForBlanketOrder(Request["OrderNo"].ToString());
if (objc != null)
{
l_ConName.Text = objc.Name;
l_ConAdd.Text = objc.Address1 + " " + objc.Address2 + " " + objc.City + " " + objc.PostCode;
l_ConNo.Text = objc.PhoneNo;
}
else
{
l_ConName.Text = obj.Name;
l_ConAdd.Text = obj.Address1 + " " + obj.Address2 + " " + obj.City + " " + obj.PostCode;
l_ConNo.Text = obj.PhoneNo;
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
public static List <OrderModifiCustomerInfo> List(string ItemCategoryCode, string OrderNo)
{
string strSQL = string.Empty;
List <OrderModifiCustomerInfo> list = new List <OrderModifiCustomerInfo>();
SqlDataReader reader;
strSQL = "SP_WA_OrderModification_LineInfomation";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
OrderModifiCustomerInfo obj = null;
try
{
db.AddInParameter(dbCommand, "@ItemCategoryCode", DbType.String, ItemCategoryCode);
db.AddInParameter(dbCommand, "@OrderNo", DbType.String, OrderNo);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
obj = new OrderModifiCustomerInfo();
obj.ItemNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("ItemNo")));
obj.Description = Convert.ToString(reader.GetValue(reader.GetOrdinal("Description")));
obj.Quantity = Math.Round(Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Quantity"))));
obj.UnitPrice = (Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Unit Price"))));
obj.Amount = Math.Round(Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Amount"))));
obj.ItemNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("ItemNo")));
obj.LineNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("LineNo")));
obj.VariantCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("Variant Code")));
obj.Remark = Convert.ToString(reader.GetValue(reader.GetOrdinal("Remarks")));
obj.Discount = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Discount")));
obj.UOM = Convert.ToString(reader.GetValue(reader.GetOrdinal("UOM")));
obj.OutStandingQty = Math.Round(Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("OutStandingQty"))));
obj.QuantityShipped = (Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("QuantityShipped"))));
obj.ItemCategoryCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("ItemCategoryCode"))); //added by vishal: 06-09-2016
obj.SelltoCustomerNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("SelltoCustomerNo"))); //added by vishal: 06-09-2016
obj.ShiptoCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("ShiptoCode"))); //added by vishal: 06-09-2016
obj.CustomerPriceGroup = Convert.ToString(reader.GetValue(reader.GetOrdinal("CustomerPriceGroup"))); //added by vishal: 06-09-2016
list.Add(obj);
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(list);
}
public static List <OrderModifiCustomerInfo> InternalList(string OrderNo)
{
string strSQL = string.Empty;
List <OrderModifiCustomerInfo> list = new List <OrderModifiCustomerInfo>();
SqlDataReader reader;
strSQL = "SP_WA_OrderModification_LineInfomation_Internal";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
OrderModifiCustomerInfo obj = null;
try
{
db.AddInParameter(dbCommand, "@OrderNo", DbType.String, OrderNo);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
obj = new OrderModifiCustomerInfo();
obj.ItemNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("ItemNo")));
obj.Description = Convert.ToString(reader.GetValue(reader.GetOrdinal("Description")));
obj.Quantity = Math.Round(Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Quantity"))));
obj.UnitPrice = Math.Round(Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Unit Price"))));
obj.Amount = Math.Round(Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Amount"))));
obj.ItemNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("ItemNo")));
obj.LineNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("LineNo")));
obj.VariantCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("Variant Code")));
obj.Remark = Convert.ToString(reader.GetValue(reader.GetOrdinal("Remarks")));
obj.LocationCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("LocationCode")));
obj.Discount = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Discount")));
obj.ExciseGroupCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("ExciseGroupCode")));
list.Add(obj);
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(list);
}
public static OrderModifiCustomerInfo InternalFind(string OrderNo)
{
string strSQL = string.Empty;
SqlDataReader reader;
strSQL = "SP_WA_OrderModification_HeaderInfomation_Internal";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
OrderModifiCustomerInfo obj = null;
try
{
db.AddInParameter(dbCommand, "@OrderNo", DbType.String, OrderNo);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
obj = new OrderModifiCustomerInfo();
obj.Code = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to Customer No_")));
obj.Name = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to Name")));
obj.Address1 = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to Address")));
obj.Address2 = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to Address 2")));
obj.City = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to City")));
obj.PostCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to Post Code")));
obj.PhoneNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("Bill-to Contact")));
obj.Consignee = Convert.ToString(reader.GetValue(reader.GetOrdinal("Ship-to Name")));
obj.ShiptoCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("Ship-to Code")));
obj.SelltoCustomerNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("Sell-to Customer No_")));
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(obj);
}
private void BindDestination()
{
try
{
Qtm.Lib.OrderModifiCustomerInfo obj = Qtm.Lib.OrderModifiCustomerInfo.FetchDestination(hf_ShiptoCode.Value, hf_SelltoCustomerNo.Value, Convert.ToString(Request["OrderNo"]));
if (obj != null)
{
txtDestination.Text = Convert.ToString(obj.Destination);
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
public static List <OrderModifiCustomerInfo> TaxGroupCodeList(string OrderNo, string ItemNo)
{
string strSQL = string.Empty;
List <OrderModifiCustomerInfo> list = new List <OrderModifiCustomerInfo>();
SqlDataReader reader;
strSQL = "SP_WA_OrderModification_TaxGroupCode_Linewise";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
OrderModifiCustomerInfo obj = null;
try
{
db.AddInParameter(dbCommand, "@OrderNo", DbType.String, OrderNo);
db.AddInParameter(dbCommand, "@ItemNo", DbType.String, ItemNo);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
obj = new OrderModifiCustomerInfo();
obj.TaxGroupCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("TaxGroupCode")));
list.Add(obj);
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(list);
}
public static OrderModifiCustomerInfo FetchDestination(string ShipToCode, string CustomerCode, string OrderNo)
{
string strSQL = string.Empty;
SqlDataReader reader;
strSQL = "SP_WA_Destination";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
OrderModifiCustomerInfo obj = null;
try
{
db.AddInParameter(dbCommand, "@ShipToCode", DbType.String, ShipToCode);
db.AddInParameter(dbCommand, "@CustomerCode", DbType.String, CustomerCode);
db.AddInParameter(dbCommand, "@OrderNo", DbType.String, OrderNo);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
obj = new OrderModifiCustomerInfo();
obj.Destination = Convert.ToString(reader.GetValue(reader.GetOrdinal("Destination")));
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(obj);
}
private void BindCustomerInfo()
{
try
{
Qtm.Lib.OrderModifiCustomerInfo obj = Qtm.Lib.OrderModifiCustomerInfo.InternalFind(Request["OrderNo"].ToString());
if (obj != null)
{
l_CustName.Text = obj.Name;
l_CustAdd.Text = obj.Address1 + " " + obj.Address2 + " " + obj.City + " " + obj.PostCode;
l_CustConNo.Text = obj.PhoneNo;
l_Consignee.Text = obj.Consignee;
hf_ShiptoCode.Value = obj.ShiptoCode;
hf_SelltoCustomerNo.Value = obj.SelltoCustomerNo;
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
