public static Inv_ItemTransaction GetInv_ItemTransactionByID(int id)
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider();
inv_ItemTransaction = sqlInv_ItemTransactionProvider.GetInv_ItemTransactionByID(id);
return inv_ItemTransaction;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction.ItemID = Int32.Parse(ddlItem.SelectedValue);
inv_ItemTransaction.Quantity = Decimal.Parse(txtQuantity.Text);
inv_ItemTransaction.ItemTrasactionTypeID = Int32.Parse(ddlItemTrasactionType.SelectedValue);
inv_ItemTransaction.ReferenceID = Int32.Parse(ddlReference.SelectedValue);
inv_ItemTransaction.ExtraField1 = txtExtraField1.Text;
inv_ItemTransaction.ExtraField2 = txtExtraField2.Text;
inv_ItemTransaction.ExtraField3 = txtExtraField3.Text;
inv_ItemTransaction.ExtraField4 = txtExtraField4.Text;
inv_ItemTransaction.ExtraField5 = txtExtraField5.Text;
inv_ItemTransaction.AddedBy =getLogin().LoginID;
inv_ItemTransaction.AddedDate = DateTime.Now;
inv_ItemTransaction.UpdatedBy = getLogin().LoginID;
inv_ItemTransaction.UpdatedDate = DateTime.Now;
inv_ItemTransaction.RowStatusID = 1;
int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction);
Response.Redirect("AdminInv_ItemTransactionDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction = Inv_ItemTransactionManager.GetInv_ItemTransactionByID(Int32.Parse(Request.QueryString["inv_ItemTransactionID"]));
Inv_ItemTransaction tempInv_ItemTransaction = new Inv_ItemTransaction();
tempInv_ItemTransaction.Inv_ItemTransactionID = inv_ItemTransaction.Inv_ItemTransactionID;
tempInv_ItemTransaction.ItemID = Int32.Parse(ddlItem.SelectedValue);
tempInv_ItemTransaction.Quantity = Decimal.Parse(txtQuantity.Text);
tempInv_ItemTransaction.ItemTrasactionTypeID = Int32.Parse(ddlItemTrasactionType.SelectedValue);
tempInv_ItemTransaction.ReferenceID = Int32.Parse(ddlReference.SelectedValue);
tempInv_ItemTransaction.ExtraField1 = txtExtraField1.Text;
tempInv_ItemTransaction.ExtraField2 = txtExtraField2.Text;
tempInv_ItemTransaction.ExtraField3 = txtExtraField3.Text;
tempInv_ItemTransaction.ExtraField4 = txtExtraField4.Text;
tempInv_ItemTransaction.ExtraField5 = txtExtraField5.Text;
tempInv_ItemTransaction.AddedBy =getLogin().LoginID;
tempInv_ItemTransaction.AddedDate = DateTime.Now;
tempInv_ItemTransaction.UpdatedBy = getLogin().LoginID;
tempInv_ItemTransaction.UpdatedDate = DateTime.Now;
tempInv_ItemTransaction.RowStatusID = 1;
bool result = Inv_ItemTransactionManager.UpdateInv_ItemTransaction(tempInv_ItemTransaction);
Response.Redirect("AdminInv_ItemTransactionDisplay.aspx");
}
public bool UpdateInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_ItemTransaction", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ItemTransactionID", SqlDbType.Int).Value = inv_ItemTransaction.Inv_ItemTransactionID;
cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = inv_ItemTransaction.ItemID;
cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = inv_ItemTransaction.Quantity;
cmd.Parameters.Add("@ItemTrasactionTypeID", SqlDbType.Int).Value = inv_ItemTransaction.ItemTrasactionTypeID;
cmd.Parameters.Add("@ReferenceID", SqlDbType.Decimal).Value = inv_ItemTransaction.ReferenceID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_ItemTransaction.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_ItemTransaction.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_ItemTransaction.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_ItemTransaction.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_ItemTransaction.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public Inv_ItemTransaction GetInv_ItemTransactionFromReader(IDataReader reader)
{
try
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction
(
(int)reader["Inv_ItemTransactionID"],
(int)reader["ItemID"],
(decimal)reader["Quantity"],
(int)reader["ItemTrasactionTypeID"],
(decimal)reader["ReferenceID"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
return inv_ItemTransaction;
}
catch(Exception ex)
{
return null;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int purchaseReturnID = 0;
Inv_PurchaseReturen inv_PurchaseReturen = new Inv_PurchaseReturen();
inv_PurchaseReturen.PurchseReturenDate = DateTime.Parse(txtPurchaseReturnDate.Text);
inv_PurchaseReturen.PurchaseIDs = getPurchaseIDs(true);
inv_PurchaseReturen.WorkSatationID = 2;
inv_PurchaseReturen.ExtraField1 = ddlSuppier.SelectedValue;
inv_PurchaseReturen.ExtraField2 = txtNote.Text;
inv_PurchaseReturen.ExtraField3 = "";
inv_PurchaseReturen.ExtraField4 = "";
inv_PurchaseReturen.ExtraField5 = "";
inv_PurchaseReturen.AddedBy = getLogin().LoginID;
inv_PurchaseReturen.AddedDate = DateTime.Now;
inv_PurchaseReturen.UpdatedBy = getLogin().LoginID;
inv_PurchaseReturen.UpdatedDate = DateTime.Now;
inv_PurchaseReturen.RowStatusID = 1;
int purchaseAdjustmentID = 0;
Inv_PurchaseAdjustment inv_PurchaseAdjustment = new Inv_PurchaseAdjustment();
inv_PurchaseAdjustment.PurchseAdjustmentDate = DateTime.Parse(txtPurchaseReturnDate.Text);
inv_PurchaseAdjustment.PurchaseIDs = getPurchaseIDs(false);
inv_PurchaseAdjustment.WorkSatationID =2;
inv_PurchaseAdjustment.ExtraField1 = ddlSuppier.SelectedValue;
inv_PurchaseAdjustment.ExtraField2 = txtNote.Text;
inv_PurchaseAdjustment.ExtraField3 = "";
inv_PurchaseAdjustment.ExtraField4 = "";
inv_PurchaseAdjustment.ExtraField5 = "";
inv_PurchaseAdjustment.AddedBy = getLogin().LoginID;
inv_PurchaseAdjustment.AddedDate = DateTime.Now;
inv_PurchaseAdjustment.UpdatedBy = getLogin().LoginID;
inv_PurchaseAdjustment.UpdatedDate = DateTime.Now;
inv_PurchaseAdjustment.RowStatusID = 1;
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID");
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
TextBox txtReturnQuantity = (TextBox)gvr.FindControl("txtReturnQuantity");
TextBox txtAdjustmentQuantity = (TextBox)gvr.FindControl("txtAdjustmentQuantity");
if (txtReturnQuantity.Text != "0")
{
if (purchaseReturnID == 0)
{
purchaseReturnID = Inv_PurchaseReturenManager.InsertInv_PurchaseReturen(inv_PurchaseReturen);
}
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value);
inv_ItemTransaction.Quantity = Decimal.Parse(txtReturnQuantity.Text);
inv_ItemTransaction.ItemTrasactionTypeID = 1;//purchase return
inv_ItemTransaction.ReferenceID = purchaseReturnID;
inv_ItemTransaction.ExtraField1 ="";
inv_ItemTransaction.ExtraField2 = "";
inv_ItemTransaction.ExtraField3 = "";
inv_ItemTransaction.ExtraField4 = "";
inv_ItemTransaction.ExtraField5 = "";
inv_ItemTransaction.AddedBy = getLogin().LoginID;
inv_ItemTransaction.AddedDate = DateTime.Now;
inv_ItemTransaction.UpdatedBy = getLogin().LoginID;
inv_ItemTransaction.UpdatedDate = DateTime.Parse(txtPurchaseReturnDate.Text);
inv_ItemTransaction.RowStatusID = 1;
int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction);
}
if (txtAdjustmentQuantity.Text != "0")
{
if (purchaseAdjustmentID == 0)
{
purchaseAdjustmentID = Inv_PurchaseAdjustmentManager.InsertInv_PurchaseAdjustment(inv_PurchaseAdjustment);
}
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value);
inv_ItemTransaction.Quantity = Decimal.Parse(txtAdjustmentQuantity.Text);
inv_ItemTransaction.ItemTrasactionTypeID =7;//Adjustment
inv_ItemTransaction.ReferenceID = purchaseAdjustmentID;
inv_ItemTransaction.ExtraField1 = "";
inv_ItemTransaction.ExtraField2 = "";
inv_ItemTransaction.ExtraField3 = "";
inv_ItemTransaction.ExtraField4 = "";
inv_ItemTransaction.ExtraField5 = "";
inv_ItemTransaction.AddedBy = getLogin().LoginID;
inv_ItemTransaction.AddedDate = DateTime.Now;
inv_ItemTransaction.UpdatedBy = getLogin().LoginID;
inv_ItemTransaction.UpdatedDate = DateTime.Parse(txtPurchaseReturnDate.Text);
inv_ItemTransaction.RowStatusID = 1;
int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction);
}
}
if (purchaseReturnID != 0)
{
hlnkPurchasePrint.NavigateUrl = "PurchaseReturnPrint.aspx?ReturnID=" + purchaseReturnID.ToString();
hlnkPurchasePrint.Visible = true;
}
if (purchaseAdjustmentID != 0)
{
hlnkAdjustmentPrint.NavigateUrl = "AdjustmentPrint.aspx?AdjustmentID=" + purchaseAdjustmentID.ToString();
hlnkAdjustmentPrint.Visible = true;
}
showInv_IssueDetailGrid();
}
private void showInv_ItemTransactionData()
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction = Inv_ItemTransactionManager.GetInv_ItemTransactionByID(Int32.Parse(Request.QueryString["inv_ItemTransactionID"]));
ddlItem.SelectedValue = inv_ItemTransaction.ItemID.ToString();
txtQuantity.Text = inv_ItemTransaction.Quantity.ToString();
ddlItemTrasactionType.SelectedValue = inv_ItemTransaction.ItemTrasactionTypeID.ToString();
ddlReference.SelectedValue = inv_ItemTransaction.ReferenceID.ToString();
txtExtraField1.Text = inv_ItemTransaction.ExtraField1;
txtExtraField2.Text = inv_ItemTransaction.ExtraField2;
txtExtraField3.Text = inv_ItemTransaction.ExtraField3;
txtExtraField4.Text = inv_ItemTransaction.ExtraField4;
txtExtraField5.Text = inv_ItemTransaction.ExtraField5;
txtAddedBy.Text = inv_ItemTransaction.AddedBy.ToString();
txtUpdatedBy.Text = inv_ItemTransaction.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_ItemTransaction.UpdatedDate;
ddlRowStatus.SelectedValue = inv_ItemTransaction.RowStatusID.ToString();
}
public static bool UpdateInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction)
{
SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider();
return sqlInv_ItemTransactionProvider.UpdateInv_ItemTransaction(inv_ItemTransaction);
}
public static int InsertInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction)
{
SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider();
return sqlInv_ItemTransactionProvider.InsertInv_ItemTransaction(inv_ItemTransaction);
}
protected void btnIssueReturn_Click(object sender, EventArgs e)
{
bool hasReturnItem = false;
foreach (GridViewRow gvr in gvInv_IssueDetail.Rows)
{
TextBox txtIssueReturn = (TextBox)gvr.FindControl("txtIssueReturn");
if (txtIssueReturn.Text != "0" || txtIssueReturn.Text != "")
{
hasReturnItem = true;
break;
}
}
if (hasReturnItem)
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
inv_IssueMasterReturn.IssueReturnName = "";
inv_IssueMasterReturn.IssueReturnDate = DateTime.Parse(txtDate.Text);
inv_IssueMasterReturn.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMasterReturn.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMasterReturn.Particulars = txtParticulars.Text;
inv_IssueMasterReturn.IsIssue = ddlProduct.SelectedValue =="0"?false:true;
inv_IssueMasterReturn.ExtraField1 = "";
inv_IssueMasterReturn.ExtraField2 = "";
inv_IssueMasterReturn.ExtraField3 = "";
inv_IssueMasterReturn.ExtraField4 = "";
inv_IssueMasterReturn.ExtraField5 = "";
inv_IssueMasterReturn.AddedBy = getLogin().LoginID;
inv_IssueMasterReturn.AddedDate = DateTime.Now;
inv_IssueMasterReturn.UpdatedBy = getLogin().LoginID;
inv_IssueMasterReturn.UpdatedDate = DateTime.Now;
inv_IssueMasterReturn.RowStatusID = 1;
inv_IssueMasterReturn.Inv_IssueMasterReturnID = Inv_IssueMasterReturnManager.InsertInv_IssueMasterReturn(inv_IssueMasterReturn);
foreach (GridViewRow gvr in gvInv_IssueDetail.Rows)
{
TextBox txtIssueReturn = (TextBox)gvr.FindControl("txtIssueReturn");
HiddenField hfItemID = (HiddenField)gvr.FindControl("hfItemID");
HiddenField hfInv_IssueDetailID = (HiddenField)gvr.FindControl("hfInv_IssueDetailID");
if (txtIssueReturn.Text != "0" && txtIssueReturn.Text != "")
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction.ItemID = Int32.Parse(hfItemID.Value);
inv_ItemTransaction.Quantity = Decimal.Parse(txtIssueReturn.Text);
inv_ItemTransaction.ItemTrasactionTypeID = 3;//issue return
inv_ItemTransaction.ReferenceID = inv_IssueMasterReturn.Inv_IssueMasterReturnID;
inv_ItemTransaction.ExtraField1 = hfInv_IssueDetailID.Value;
inv_ItemTransaction.ExtraField2 = "";
inv_ItemTransaction.ExtraField3 = "";
inv_ItemTransaction.ExtraField4 = "";
inv_ItemTransaction.ExtraField5 = inv_IssueMasterReturn.Inv_IssueMasterReturnID.ToString();
inv_ItemTransaction.AddedBy = getLogin().LoginID;
inv_ItemTransaction.AddedDate = DateTime.Now;
inv_ItemTransaction.UpdatedBy = getLogin().LoginID;
inv_ItemTransaction.UpdatedDate = DateTime.Parse(txtDate.Text);
inv_ItemTransaction.RowStatusID = 1;
int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction);
}
}
hlnkIssueReturnPrint.NavigateUrl = "IssueReturnPrint.aspx?IssueReturnID=" + inv_IssueMasterReturn.Inv_IssueMasterReturnID;
hlnkIssueReturnPrint.Visible = true;
}
}
public static bool UpdateInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction)
{
SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider();
return(sqlInv_ItemTransactionProvider.UpdateInv_ItemTransaction(inv_ItemTransaction));
}
public static int InsertInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction)
{
SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider();
return(sqlInv_ItemTransactionProvider.InsertInv_ItemTransaction(inv_ItemTransaction));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_PurchaseReturen inv_PurchaseReturen = new Inv_PurchaseReturen();
inv_PurchaseReturen.PurchseReturenDate = DateTime.Parse(txtPurchaseReturnDate.Text);
inv_PurchaseReturen.PurchaseIDs = getPurchaseIDs();
inv_PurchaseReturen.WorkSatationID = 2;
inv_PurchaseReturen.ExtraField1 = ddlSuppier.SelectedValue;
inv_PurchaseReturen.ExtraField2 = txtNote.Text;
inv_PurchaseReturen.ExtraField3 = "";
inv_PurchaseReturen.ExtraField4 = "";
inv_PurchaseReturen.ExtraField5 = "";
inv_PurchaseReturen.AddedBy = getLogin().LoginID;
inv_PurchaseReturen.AddedDate = DateTime.Now;
inv_PurchaseReturen.UpdatedBy = getLogin().LoginID;
inv_PurchaseReturen.UpdatedDate = DateTime.Now;
inv_PurchaseReturen.RowStatusID = 1;
int purchaseReturnID = 0;
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID");
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
TextBox txtReturnQuantity = (TextBox)gvr.FindControl("txtReturnQuantity");
TextBox txtAdjustmentQuantity = (TextBox)gvr.FindControl("txtAdjustmentQuantity");
if (txtReturnQuantity.Text != "0")
{
if (purchaseReturnID == 0)
{
purchaseReturnID = Inv_PurchaseReturenManager.InsertInv_PurchaseReturen(inv_PurchaseReturen);
}
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value);
inv_ItemTransaction.Quantity = Decimal.Parse(txtReturnQuantity.Text);
inv_ItemTransaction.ItemTrasactionTypeID = 1;//purchase return
inv_ItemTransaction.ReferenceID = purchaseReturnID;
inv_ItemTransaction.ExtraField1 = "";
inv_ItemTransaction.ExtraField2 = "";
inv_ItemTransaction.ExtraField3 = "";
inv_ItemTransaction.ExtraField4 = "";
inv_ItemTransaction.ExtraField5 = "";
inv_ItemTransaction.AddedBy = getLogin().LoginID;
inv_ItemTransaction.AddedDate = DateTime.Now;
inv_ItemTransaction.UpdatedBy = getLogin().LoginID;
inv_ItemTransaction.UpdatedDate = DateTime.Now;
inv_ItemTransaction.RowStatusID = 1;
int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction);
}
if (txtAdjustmentQuantity.Text != "0")
{
Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction();
inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value);
inv_ItemTransaction.Quantity = Decimal.Parse(txtAdjustmentQuantity.Text);
inv_ItemTransaction.ItemTrasactionTypeID = 7;//purchase return
inv_ItemTransaction.ReferenceID = purchaseReturnID;
inv_ItemTransaction.ExtraField1 = "";
inv_ItemTransaction.ExtraField2 = "";
inv_ItemTransaction.ExtraField3 = "";
inv_ItemTransaction.ExtraField4 = "";
inv_ItemTransaction.ExtraField5 = "";
inv_ItemTransaction.AddedBy = getLogin().LoginID;
inv_ItemTransaction.AddedDate = DateTime.Now;
inv_ItemTransaction.UpdatedBy = getLogin().LoginID;
inv_ItemTransaction.UpdatedDate = DateTime.Now;
inv_ItemTransaction.RowStatusID = 1;
int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction);
}
}
if (purchaseReturnID != 0)
{
hlnkPurchasePrint.NavigateUrl = "PurchaseReturnPrint.aspx?ReturnID=" + purchaseReturnID.ToString();
hlnkPurchasePrint.Visible = true;
}
}
