public string insertSalesReturn(string subtotal, string tax, string shc, string misccost, string ttotal)
{
oblSalesRtn = new Store.SalesReturned.BusinessLogic.SalesReturned();
// oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived();
objMessageInfo = new MessageInfo();
objSalesRtn = new Store.SalesReturned.BusinessObject.SalesReturned();
if (cmdMode == Store.Common.CommandMode.M)
{
objSalesRtn.SalesReturnedID = Convert.ToInt32(hfPId.Value);
// objPurchaseReceived.PurchaseReceivedID = Convert.ToInt32(hfPId.Value);//PurchaseReceivedID which edit from data grid
}
else
{
// objPurchaseReceived.PurchaseReceivedID = 0;
}
objSalesRtn.SalesReturnedID = Convert.ToInt32(hfSaleOrder.Value);
objSalesRtn.VendorID = Convert.ToInt32(hfVendor.Value);
objSalesRtn.TotalSalesReturnAmount = Convert.ToDecimal(ttotal);
objSalesRtn.TaxValue = Convert.ToDecimal(tax);
objSalesRtn.ShippingAndHandlingCost = Convert.ToDecimal(shc);
objSalesRtn.MiscCost = Convert.ToDecimal(misccost);
objSalesRtn.IsActive = 1;
objMessageInfo = oblSalesRtn.ManageSalesRetuned(objSalesRtn, cmdMode);
return(objMessageInfo.TranID.ToString());
}
void BindSaleOrder(int id)
{
oblSalesRtn = new Store.SalesReturned.BusinessLogic.SalesReturned();
// oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
try
{
objSalesRtn = oblSalesRtn.GetAllSalesReturned(id, 0, "");
objSalesRtn = oblSalesRtn.GetAllSalesReturned(id, 0, "");
if (objSalesRtn != null)
{
txtSHC.Text = objSalesRtn.ShippingAndHandlingCost.ToString();
txtTax.Text = objSalesRtn.TaxValue.ToString();
txtMiscCost.Text = objSalesRtn.MiscCost.ToString();
txttotal.Text = objSalesRtn.TotalSalesReturnAmount.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(SalesReturn).FullName, 1);
}
finally
{
oblSalesRtn = null;
objSalesRtn = null;
}
upSummary.Update();
}
public Store.Common.MessageInfo ManageSalesRetuned(Store.SalesReturned.BusinessObject.SalesReturned objSalesReturned, CommandMode cmdMode)
{
try
{
return(odlSalesReturned.ManageSaleRetuned(objSalesReturned, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesReturned).FullName, 1);
return(null);
}
}
void ManageSalesReturned()
{
objSalesReturned = new Store.SalesReturned.BusinessObject.SalesReturned();
oblSalesReturned = new Store.SalesReturned.BusinessLogic.SalesReturned();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objSalesReturned.SalesReturnedID = Convert.ToInt32(txtSalesReturnedID.Text);
}
else
{
objSalesReturned.SalesReturnedID = 0;
}
objSalesReturned.VendorID = Convert.ToInt32(ddlVendor.SelectedItem.Value);
objSalesReturned.SalesReturnDate = Convert.ToDateTime(txtSalesReturnDate.Text);
objSalesReturned.TotalSalesReturnAmount = Convert.ToDecimal(txtTotalSalesReturnAmount.Text);
objSalesReturned.TaxValue = Convert.ToDecimal(txtTaxValue.Text);
objSalesReturned.ShippingAndHandlingCost = Convert.ToDecimal(txtShippingHandlingCost.Text);
objSalesReturned.MiscCost = Convert.ToDecimal(txtMiscCost.Text);
objSalesReturned.SalesOrderID = Convert.ToInt32(ddlSalesOrderID.SelectedItem.Value);
if (cbIsActive.Checked)
{
objSalesReturned.IsActive = 1;
}
else
{
objSalesReturned.IsActive = 0;
}
objSalesReturned.CreatedBy = 1;
objMessageInfo = oblSalesReturned.ManageItemMaster(objSalesReturned, cmdMode);
}
catch (Exception ex)
{
}
finally
{
objSalesReturned = null;
//objMessageInfo = null;
oblSalesReturned = null;
}
}
public string insertOrder(string tax, string shc, string misccost, string ttotal)
{
Store.SalesReturned.BusinessObject.SalesReturned objSalesReturned = new Store.SalesReturned.BusinessObject.SalesReturned();
Store.SalesReturned.BusinessLogic.SalesReturned oblSalesReturned = new Store.SalesReturned.BusinessLogic.SalesReturned();
//Store.PurchaseReceived.BusinessLogic.PurchaseReceived oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
//Store.PurchaseReceived.BusinessObject.PurchaseReceived objPurchaseReceived = new Store.PurchaseReceived.BusinessObject.PurchaseReceived();
objSalesReturned.SalesReturnedID = 0;
objSalesReturned.SalesOrderID = Convert.ToInt32(txtPoId.Text);
objSalesReturned.TotalSalesReturnAmount = Convert.ToDecimal(ttotal);
objSalesReturned.VendorID = 0;
objSalesReturned.TaxValue = Convert.ToDecimal(tax);
objSalesReturned.ShippingAndHandlingCost = Convert.ToDecimal(shc);
objSalesReturned.MiscCost = Convert.ToDecimal(misccost);
// objMessageInfo = oblSalesReturned.ManageSalesRetuned(objSalesReturned,cmdMode);
//objMessageInfo = oblPurchaseReceived.ManagePurchaseReceived(objPurchaseReceived, 1);
return(objMessageInfo.TranID.ToString());
}
public Store.Common.MessageInfo ManageSaleRetuned(Store.SalesReturned.BusinessObject.SalesReturned objSalesReturned, CommandMode cmdMode)
{
string SQL = "USP_SalesReturned";
ParameterList param = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_SalesReturned";
param.Add(new SQLParameter("@SalesReturnedID", objSalesReturned.SalesReturnedID));
param.Add(new SQLParameter("@VendorID", objSalesReturned.VendorID));
param.Add(new SQLParameter("@TotalSalesReturnAmount", objSalesReturned.TotalSalesReturnAmount));
param.Add(new SQLParameter("@SalesOrderID", objSalesReturned.SalesOrderID));
param.Add(new SQLParameter("@TaxValue", objSalesReturned.TaxValue));
param.Add(new SQLParameter("@ShippingAndHandlingCost", objSalesReturned.ShippingAndHandlingCost));
param.Add(new SQLParameter("@MiscCost", objSalesReturned.MiscCost));
param.Add(new SQLParameter("@UserId", objSalesReturned.CreatedBy));
param.Add(new SQLParameter("@ReferenceID", objSalesReturned.ReferenceID));
param.Add(new SQLParameter("@CMDMode", cmdMode));
param.Add(new SQLParameter("@IsActive", objSalesReturned.IsActive));
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(SalesReturned).FullName, 1);
}
return(objMessageInfo);
}
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objSalesReturned = new Store.SalesReturned.BusinessObject.SalesReturned();
oblSalesReturned = new Store.SalesReturned.BusinessLogic.SalesReturned();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objSalesReturned.SalesReturnedID = Convert.ToInt32(dgvSalesReturned.DataKeys[gvrow.RowIndex].Value.ToString());
objSalesReturned.VendorID = 0;
objSalesReturned.SalesReturnDate = DateTime.Now;
objSalesReturned.TotalSalesReturnAmount = 0;
objSalesReturned.TaxValue = 0;
objSalesReturned.ShippingAndHandlingCost = 0;
objSalesReturned.MiscCost = 0;
objSalesReturned.SalesOrderID = 0;
objSalesReturned.ClientID = 0;
objSalesReturned.CreatedBy = 1;
objMessageInfo = oblSalesReturned.ManageItemMaster(objSalesReturned, cmdMode);
BindSalesReturned();
updateSalesReturnedBdInfo.Update();
}
catch (Exception ex)
{
throw;
}
finally
{
objSalesReturned = null;
objMessageInfo = null;
oblSalesReturned = null;
}
}
public Store.SalesReturned.BusinessObject.SalesReturned GetAllSalesReturned(int SalesReturnedID, int Flag, string FlagValue)
{
Store.SalesReturned.BusinessObject.SalesReturned objSalesReturned = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_SalesReturn";
paramList.Add(new SQLParameter("@SalesReturnedID", SalesReturnedID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
if (dr.IsDBNull(dr.GetOrdinal("SalesReturnedID")) == false)
{
objSalesReturned.SalesReturnedID = dr.GetInt32(dr.GetOrdinal("SalesReturnedID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorID")) == false)
{
objSalesReturned.VendorID = dr.GetInt32(dr.GetOrdinal("VendorID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorName")) == false)
{
objSalesReturned.VendorName = dr.GetString(dr.GetOrdinal("VendorName"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesReturnDate")) == false)
{
objSalesReturned.SalesReturnDate = dr.GetDateTime(dr.GetOrdinal("SalesReturnDate"));
}
if (dr.IsDBNull(dr.GetOrdinal("TotalSalesReturnAmount")) == false)
{
objSalesReturned.TotalSalesReturnAmount = dr.GetDecimal(dr.GetOrdinal("TotalSalesReturnAmount"));
}
if (dr.IsDBNull(dr.GetOrdinal("TaxValue")) == false)
{
objSalesReturned.TaxValue = dr.GetDecimal(dr.GetOrdinal("TaxValue"));
}
if (dr.IsDBNull(dr.GetOrdinal("ShippingAndHandlingCost")) == false)
{
objSalesReturned.ShippingAndHandlingCost = dr.GetDecimal(dr.GetOrdinal("ShippingAndHandlingCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("MiscCost")) == false)
{
objSalesReturned.MiscCost = dr.GetDecimal(dr.GetOrdinal("MiscCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesOrderID")) == false)
{
objSalesReturned.SalesOrderID = dr.GetInt32(dr.GetOrdinal("SalesOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objSalesReturned.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objSalesReturned.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objSalesReturned.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objSalesReturned.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objSalesReturned.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objSalesReturned.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objSalesReturned.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
dr.Close();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesReturned).FullName, 1);
}
return(objSalesReturned);
}
