protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objSalesReturnItem = new Store.SaleReturnItem.BusinessObject.SaleReturnItem();
oblSalesreturnItem = new Store.SaleReturnItem.BusinessLogic.SaleReturnItem();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objSalesReturnItem.SaleReturnItemID = Convert.ToInt32(dgvSalesReturnedItem.DataKeys[gvrow.RowIndex].Value.ToString());
objSalesReturnItem.SalesOrderID = 0;
objSalesReturnItem.SalesReturnID = 0;
objSalesReturnItem.SalesOrderID = 0;
objSalesReturnItem.ItemId = 0;
objSalesReturnItem.ItemUnit = "";
objSalesReturnItem.Description = "";
objSalesReturnItem.ItemPrice = 0;
objSalesReturnItem.CreatedBy = 1;
objMessageInfo = oblSalesreturnItem.ManageItemMaster(objSalesReturnItem, cmdMode);
BindSalesReturnItem();
updateSalesReturnedItemBdInfo.Update();
}
catch (Exception ex)
{
throw;
}
finally
{
objSalesReturnItem = null;
objMessageInfo = null;
oblSalesreturnItem = null;
}
}
public Store.Common.MessageInfo ManageItemMaster(Store.SaleReturnItem.BusinessObject.SaleReturnItem objSaleReturnItem, CommandMode cmdMode)
{
try
{
return(odlSaleReturnItem.ManageSaleReturnItem(objSaleReturnItem, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SaleReturnItem).FullName, 1);
return(null);
}
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
try
{
string transid = "";
transid = insertSalesReturn(txtSubTotal.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text);
objsalesRtnItemList = new Store.SaleReturnItem.BusinessObject.SaleReturnItemList();
// objPurchaseReceivedItemList = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList();
for (int i = 0; i < Gridview1.Rows.Count; i++)
{
objsalesRtnItem = new Store.SaleReturnItem.BusinessObject.SaleReturnItem();
TextBox txtItemNames = (TextBox)Gridview1.Rows[i].FindControl("txtItemName");
if (txtItemNames.Text == "")
{
break;
}
TextBox txtDecs = (TextBox)Gridview1.Rows[i].FindControl("txtDec");
TextBox txtPrices = (TextBox)Gridview1.Rows[i].FindControl("txtSPrice");
// TextBox txtDisPres = (TextBox)Gridview1.Rows[i].FindControl("txtDisPre");
// TextBox txtDiss = (TextBox)Gridview1.Rows[i].FindControl("txtDis");
TextBox txtQuts = (TextBox)Gridview1.Rows[i].FindControl("txtQut");
TextBox txtTotals = (TextBox)Gridview1.Rows[i].FindControl("txtTotal");
objsalesRtnItem.ItemPrefix = txtItemNames.Text;
objsalesRtnItem.Description = txtDecs.Text;
objsalesRtnItem.ItemPrice = Convert.ToDecimal(txtPrices.Text);
// objPurchaseReceivedItem.DiscountPre = Convert.ToDecimal(txtDisPres.Text);
//objPurchaseReceivedItem.Discount = Convert.ToDecimal(txtDiss.Text);
objsalesRtnItem.ItemUnit = txtQuts.Text;
objsalesRtnItem.ItemPrice = Convert.ToDecimal(txtTotals.Text);
objsalesRtnItem.SalesReturnID = Convert.ToInt32(transid);
objsalesRtnItem.SalesOrderID = Convert.ToInt32(hfSaleOrder.Value);
objsalesRtnItemList.Add(objsalesRtnItem);
}
oblsalesRtnItem = new Store.SaleReturnItem.BusinessLogic.SaleReturnItem();
//oblSalesItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
//oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem();
objMessageInfo = oblsalesRtnItem.ManageItemMaster(objsalesRtnItem, cmdMode);
reset();
}
catch (Exception ex)
{ Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesReturn).FullName, 1); }
}
void ManageSalesReturnItem()
{
objSalesReturnItem = new Store.SaleReturnItem.BusinessObject.SaleReturnItem();
oblSalesreturnItem = new Store.SaleReturnItem.BusinessLogic.SaleReturnItem();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objSalesReturnItem.SaleReturnItemID = Convert.ToInt32(txtSalesReturnItemId.Text);
}
else
{
objSalesReturnItem.SaleReturnItemID = 0;
}
objSalesReturnItem.SalesReturnID = Convert.ToInt32(ddlSalesReturnID.SelectedItem.Value);
objSalesReturnItem.SalesOrderID = Convert.ToInt32(ddlSalesOrderId.SelectedItem.Value);
objSalesReturnItem.ItemId = Convert.ToInt32(ddlItemId.SelectedItem.Value);
objSalesReturnItem.ItemUnit = Convert.ToString(txtItemUnit.Text);
objSalesReturnItem.Description = Convert.ToString(txtDescription.Text);
objSalesReturnItem.ItemPrice = Convert.ToDecimal(txtItemPrice.Text);
if (cbIsActive.Checked)
{
objSalesReturnItem.IsActive = 1;
}
else
{
objSalesReturnItem.IsActive = 0;
}
objSalesReturnItem.CreatedBy = 1;
objMessageInfo = oblSalesreturnItem.ManageItemMaster(objSalesReturnItem, cmdMode);
}
catch (Exception ex)
{
}
finally
{
objSalesReturnItem = null;
//objMessageInfo = null;
oblSalesreturnItem = null;
}
}
public string insertItem(string name, string description, string unitprice, string quantity, string tranID)
{
Store.SalesReturned.BusinessLogic.SalesReturned oblSaleReturnItem = new Store.SalesReturned.BusinessLogic.SalesReturned();
Store.SaleReturnItem.BusinessObject.SaleReturnItem objSaleReturnItem = new Store.SaleReturnItem.BusinessObject.SaleReturnItem();
//Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem objPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
//Store.PurchaseReceived.BusinessLogic.PurchaseReceived oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived();
objSaleReturnItem.SaleReturnItemID = 0;
objSaleReturnItem.SalesOrderID = Convert.ToInt32(txtPoId.Text);
objSaleReturnItem.SalesReturnID = Convert.ToInt32(tranID);
objSaleReturnItem.ItemPrefix = name;
objSaleReturnItem.ItemUnit = quantity;
objSaleReturnItem.Description = description;
objSaleReturnItem.ItemPrice = Convert.ToDecimal(unitprice);
objMessageInfo = oblSaleReturnItem.ManageSalesRetunedItem(objSaleReturnItem, 1);
//objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder();
return("");
}
public Store.Common.MessageInfo ManageSaleRetunedItem(Store.SaleReturnItem.BusinessObject.SaleReturnItem objSaleReturnItem, int cmdMode)
{
string SQL = "dbo.USP_SalesReturnItem";
ParameterList param = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_SalesReturnItem";
param.Add(new SQLParameter("@SaleReturnItemID", objSaleReturnItem.SaleReturnItemID));
param.Add(new SQLParameter("@SalesReturnID", objSaleReturnItem.SalesReturnID));
param.Add(new SQLParameter("@SalesOrderID", objSaleReturnItem.SalesOrderID));
param.Add(new SQLParameter("@ItemPrefix", objSaleReturnItem.ItemPrefix));
param.Add(new SQLParameter("@ItemUnit", objSaleReturnItem.ItemUnit));
param.Add(new SQLParameter("@Description", objSaleReturnItem.Description));
param.Add(new SQLParameter("@ItemPrice", objSaleReturnItem.ItemPrice));
param.Add(new SQLParameter("@IsActive", objSaleReturnItem.IsActive));
param.Add(new SQLParameter("@ReferenceID", objSaleReturnItem.ReferenceID));
param.Add(new SQLParameter("@UserId", objSaleReturnItem.CreatedBy));
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(SalesReturned).FullName, 1);
}
return(objMessageInfo);
}
public Store.SaleReturnItem.BusinessObject.SaleReturnItem GetAllSaleReturnItem(int SaleReturnItemID, int Flag, string FlagValue)
{
Store.SaleReturnItem.BusinessObject.SaleReturnItem objSaleReturnItem = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_SaleReturnItem";
paramList.Add(new SQLParameter("@SaleReturnItemID", SaleReturnItemID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objSaleReturnItem = new BusinessObject.SaleReturnItem();
if (dr.IsDBNull(dr.GetOrdinal("SaleReturnItemID")) == false)
{
objSaleReturnItem.SaleReturnItemID = dr.GetInt32(dr.GetOrdinal("SaleReturnItemID"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesRetrunID")) == false)
{
objSaleReturnItem.SalesReturnID = dr.GetInt32(dr.GetOrdinal("SalesRetrunID"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesOrderID")) == false)
{
objSaleReturnItem.SalesOrderID = dr.GetInt32(dr.GetOrdinal("SalesOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemId")) == false)
{
objSaleReturnItem.ItemId = dr.GetInt32(dr.GetOrdinal("ItemId"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false)
{
objSaleReturnItem.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemUnit")) == false)
{
objSaleReturnItem.ItemUnit = dr.GetString(dr.GetOrdinal("ItemUnit"));
}
if (dr.IsDBNull(dr.GetOrdinal("Description")) == false)
{
objSaleReturnItem.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrice")) == false)
{
objSaleReturnItem.ItemPrice = dr.GetDecimal(dr.GetOrdinal("ItemPrice"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objSaleReturnItem.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objSaleReturnItem.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objSaleReturnItem.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objSaleReturnItem.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objSaleReturnItem.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objSaleReturnItem.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objSaleReturnItem.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objSaleReturnItem.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(SaleReturnItem).FullName, 1);
}
return(objSaleReturnItem);
}
