public string insertOrder(string subtotal, string dicpre, string dic, string tax, string shc, string misccost, string ttotal)
{
oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
objMessageInfo = new MessageInfo();
objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder();
if (cmdMode == Store.Common.CommandMode.M)
{
objPurchaseOrder.PurchaseOrderID = Convert.ToInt32(hfPId.Value);//PurchaseOrderID which edit from data grid
}
else
{
objPurchaseOrder.PurchaseOrderID = 0;
}
objPurchaseOrder.PurchaseOrderID = 0;
objPurchaseOrder.VendorID = Convert.ToInt32(hfVendor.Value);
objPurchaseOrder.PurchaseAmount = Convert.ToDecimal(ttotal);
objPurchaseOrder.TaxValue = Convert.ToDecimal(tax);
objPurchaseOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc);
objPurchaseOrder.MiscCost = Convert.ToDecimal(misccost);
objPurchaseOrder.PDiscountPre = Convert.ToDecimal(dicpre);
objPurchaseOrder.PDiscount = Convert.ToDecimal(dic);
objPurchaseOrder.IsActive = 1;
objMessageInfo = oblPurchaseOrder.ManagePurchaseOrder(objPurchaseOrder, cmdMode);
return objMessageInfo.TranID.ToString();
}
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder();
objMessageInfo = new MessageInfo();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objPurchaseOrder.PurchaseOrderID = Convert.ToInt32(gvPOrder.DataKeys[gvrow.RowIndex].Value.ToString());
objMessageInfo = oblPurchaseOrder.ManagePurchaseOrder(objPurchaseOrder, cmdMode);
BindPurchaseOrder();
if (objMessageInfo.TranID != 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true);
}
else if (objMessageInfo.ErrorCode == -101)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.ErrorMessage + "')", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objMessageInfo = null;
oblPurchaseOrder = null;
objPurchaseOrder = null;
}
}
void BindPurchaseOrder(int id)
{
oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
try
{
objPurchaseOrder = oblPurchaseOrder.GetAllPurchaseOrder(id, 0, "");
if (objPurchaseOrder != null)
{
txtSHC.Text = objPurchaseOrder.ShipingAndHandlingCost.ToString();
txtTax.Text = objPurchaseOrder.TaxValue.ToString();
txtMiscCost.Text = objPurchaseOrder.MiscCost.ToString();
txttotal.Text = objPurchaseOrder.PurchaseAmount.ToString();
}
else
{
txtSHC.Text = "";
txtTax.Text = "";
txttotal.Text = "";
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PReceived).FullName, 1);
}
finally
{
oblPurchaseOrder = null;
objPurchaseOrder = null;
}
upSummary.Update();
}
void BindPurchaseOrder(int id)
{
odlPOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
try
{
objPOrder = odlPOrder.GetAllPurchaseOrder(id, 0, "");
if (objPOrder != null)
{
txtSHC.Text = objPOrder.ShipingAndHandlingCost.ToString();
txtTax.Text = objPOrder.TaxValue.ToString();
txtMiscCost.Text = objPOrder.MiscCost.ToString();
txtTotal.Text = objPOrder.PurchaseAmount.ToString();
up1.Update();
}
else
{
txtSHC.Text = "";
txtTax.Text = "";
txtTotal.Text = "";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
odlPOrder = null;
objPOrder = null;
}
#endregion
}
public Store.Common.MessageInfo ManagePurchaseOrder(Store.PurchaseOrder.BusinessObject.PurchaseOrder objPOrder, CommandMode cmdMode)
{
try
{
return(odlPurchaseOrder.ManagePurchase(objPOrder, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrder).FullName, 1);
return(null);
}
}
public string insertOrder(string subtotal, string dicpre, string dic, string tax, string shc, string misccost, string ttotal)
{
Store.PurchaseOrder.BusinessLogic.PurchaseOrder oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
Store.PurchaseOrder.BusinessObject.PurchaseOrder objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder();
objPurchaseOrder.PurchaseOrderID = 0;
objPurchaseOrder.VendorID = 0;
objPurchaseOrder.PurchaseAmount = Convert.ToDecimal(ttotal);
objPurchaseOrder.TaxValue = Convert.ToDecimal(tax);
objPurchaseOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc);
objPurchaseOrder.MiscCost = Convert.ToDecimal(misccost);
objPurchaseOrder.PDiscountPre = Convert.ToDecimal(dicpre);
objPurchaseOrder.PDiscount = Convert.ToDecimal(dic);
objMessageInfo = oblPurchaseOrder.ManagePurchaseOrder(objPurchaseOrder, 1);
return(objMessageInfo.TranID.ToString());
}
public Store.Common.MessageInfo ManagePurchase(Store.PurchaseOrder.BusinessObject.PurchaseOrder objPOrder, CommandMode cmdMode)
{
string SQL = "";
ParameterList param = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManagePurchaseOrder";
param.Add(new SQLParameter("@PurchaseOrderID", objPOrder.PurchaseOrderID));
param.Add(new SQLParameter("@VendorID", objPOrder.VendorID));
param.Add(new SQLParameter("@PurchaseAmount", objPOrder.PurchaseAmount));
param.Add(new SQLParameter("@TaxValue", objPOrder.TaxValue));
param.Add(new SQLParameter("@ShipingAndHandlingCost", objPOrder.ShipingAndHandlingCost));
param.Add(new SQLParameter("@MiscCost", objPOrder.MiscCost));
param.Add(new SQLParameter("@PDiscount", objPOrder.PDiscount));
param.Add(new SQLParameter("@PDiscountPre", objPOrder.PDiscountPre));
param.Add(new SQLParameter("@UserId", objPOrder.CreatedBy));
param.Add(new SQLParameter("@ReferenceID", objPOrder.ReferenceID));
param.Add(new SQLParameter("@IsActive", objPOrder.IsActive));
param.Add(new SQLParameter("@CMDMode", cmdMode));
dr = ExecuteQuery.ExecuteReader(SQL, param);
if (dr.Read())
{
objMessageInfo = new Store.Common.MessageInfo();
objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]);
objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]);
objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]);
objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]);
objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]);
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrder).FullName, 1);
}
return(objMessageInfo);
}
public Store.PurchaseOrder.BusinessObject.PurchaseOrderList GetAllPurchaseOrderList(int PurchaseOrderID, int Flag, string FlagValue)
{
Store.PurchaseOrder.BusinessObject.PurchaseOrder objPOrder = null;
Store.PurchaseOrder.BusinessObject.PurchaseOrderList objPOrderList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_PurchaseOrder";
objPOrderList = new BusinessObject.PurchaseOrderList();
paramList.Add(new SQLParameter("@PurchaseOrderID", PurchaseOrderID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objPOrder = new BusinessObject.PurchaseOrder();
if (dr.IsDBNull(dr.GetOrdinal("PurchaseOrderID")) == false)
{
objPOrder.PurchaseOrderID = dr.GetInt32(dr.GetOrdinal("PurchaseOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorID")) == false)
{
objPOrder.VendorID = dr.GetInt32(dr.GetOrdinal("VendorID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorName")) == false)
{
objPOrder.VendorName = dr.GetString(dr.GetOrdinal("VendorName"));
}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseDate")) == false)
{
objPOrder.PurchaseDate = dr.GetDateTime(dr.GetOrdinal("PurchaseDate"));
}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseAmount")) == false)
{
objPOrder.PurchaseAmount = dr.GetDecimal(dr.GetOrdinal("PurchaseAmount"));
}
if (dr.IsDBNull(dr.GetOrdinal("TaxValue")) == false)
{
objPOrder.TaxValue = dr.GetDecimal(dr.GetOrdinal("TaxValue"));
}
if (dr.IsDBNull(dr.GetOrdinal("ShipingAndHandlingCost")) == false)
{
objPOrder.ShipingAndHandlingCost = dr.GetDecimal(dr.GetOrdinal("ShipingAndHandlingCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("MiscCost")) == false)
{
objPOrder.MiscCost = dr.GetDecimal(dr.GetOrdinal("MiscCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objPOrder.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objPOrder.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objPOrder.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objPOrder.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objPOrder.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objPOrder.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objPOrder.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
objPOrderList.Add(objPOrder);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrder).FullName, 1);
}
return(objPOrderList);
}
