public static Inv_IssueMasterReturn GetInv_IssueMasterReturnByID(int id)
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
SqlInv_IssueMasterReturnProvider sqlInv_IssueMasterReturnProvider = new SqlInv_IssueMasterReturnProvider();
inv_IssueMasterReturn = sqlInv_IssueMasterReturnProvider.GetInv_IssueMasterReturnByID(id);
return inv_IssueMasterReturn;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
inv_IssueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(Int32.Parse(Request.QueryString["inv_IssueMasterReturnID"]));
Inv_IssueMasterReturn tempInv_IssueMasterReturn = new Inv_IssueMasterReturn();
tempInv_IssueMasterReturn.Inv_IssueMasterReturnID = inv_IssueMasterReturn.Inv_IssueMasterReturnID;
tempInv_IssueMasterReturn.IssueReturnName = txtIssueReturnName.Text;
tempInv_IssueMasterReturn.IssueReturnDate = txtIssueReturnDate.Text;
tempInv_IssueMasterReturn.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
tempInv_IssueMasterReturn.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
tempInv_IssueMasterReturn.Particulars = txtParticulars.Text;
tempInv_IssueMasterReturn.IsIssue = cbIsIssue.Checked;
tempInv_IssueMasterReturn.ExtraField1 = txtExtraField1.Text;
tempInv_IssueMasterReturn.ExtraField2 = txtExtraField2.Text;
tempInv_IssueMasterReturn.ExtraField3 = txtExtraField3.Text;
tempInv_IssueMasterReturn.ExtraField4 = txtExtraField4.Text;
tempInv_IssueMasterReturn.ExtraField5 = txtExtraField5.Text;
tempInv_IssueMasterReturn.AddedBy = Int32.Parse(txtAddedBy.Text);
tempInv_IssueMasterReturn.AddedDate = DateTime.Now;
tempInv_IssueMasterReturn.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempInv_IssueMasterReturn.UpdatedDate = txtUpdatedDate.Text;
tempInv_IssueMasterReturn.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_IssueMasterReturnManager.UpdateInv_IssueMasterReturn(tempInv_IssueMasterReturn);
Response.Redirect("AdminInv_IssueMasterReturnDisplay.aspx");
}
public int InsertInv_IssueMasterReturn(Inv_IssueMasterReturn inv_IssueMasterReturn)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertInv_IssueMasterReturn", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_IssueMasterReturnID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@IssueReturnName", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.IssueReturnName;
cmd.Parameters.Add("@IssueReturnDate", SqlDbType.DateTime).Value = inv_IssueMasterReturn.IssueReturnDate;
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = inv_IssueMasterReturn.EmployeeID;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_IssueMasterReturn.WorkSatationID;
cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = inv_IssueMasterReturn.Particulars;
cmd.Parameters.Add("@IsIssue", SqlDbType.Bit).Value = inv_IssueMasterReturn.IsIssue;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_IssueMasterReturn.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_IssueMasterReturn.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_IssueMasterReturn.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_IssueMasterReturn.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_IssueMasterReturn.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Inv_IssueMasterReturnID"].Value);
}
}
public static Inv_IssueMasterReturn GetInv_IssueMasterReturnByID(int id)
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
SqlInv_IssueMasterReturnProvider sqlInv_IssueMasterReturnProvider = new SqlInv_IssueMasterReturnProvider();
inv_IssueMasterReturn = sqlInv_IssueMasterReturnProvider.GetInv_IssueMasterReturnByID(id);
return(inv_IssueMasterReturn);
}
private void showInv_IssueMasterReturnData()
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
inv_IssueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(Int32.Parse(Request.QueryString["inv_IssueMasterReturnID"]));
txtIssueReturnName.Text = inv_IssueMasterReturn.IssueReturnName;
txtIssueReturnDate.Text = inv_IssueMasterReturn.IssueReturnDate;
ddlEmployee.SelectedValue = inv_IssueMasterReturn.EmployeeID.ToString();
ddlWorkSatation.SelectedValue = inv_IssueMasterReturn.WorkSatationID.ToString();
txtParticulars.Text = inv_IssueMasterReturn.Particulars;
cbIsIssue.Checked = inv_IssueMasterReturn.IsFeature;
txtExtraField1.Text = inv_IssueMasterReturn.ExtraField1;
txtExtraField2.Text = inv_IssueMasterReturn.ExtraField2;
txtExtraField3.Text = inv_IssueMasterReturn.ExtraField3;
txtExtraField4.Text = inv_IssueMasterReturn.ExtraField4;
txtExtraField5.Text = inv_IssueMasterReturn.ExtraField5;
txtAddedBy.Text = inv_IssueMasterReturn.AddedBy.ToString();
txtUpdatedBy.Text = inv_IssueMasterReturn.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_IssueMasterReturn.UpdatedDate;
ddlRowStatus.SelectedValue = inv_IssueMasterReturn.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
inv_IssueMasterReturn.IssueReturnName = txtIssueReturnName.Text;
inv_IssueMasterReturn.IssueReturnDate = txtIssueReturnDate.Text;
inv_IssueMasterReturn.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMasterReturn.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMasterReturn.Particulars = txtParticulars.Text;
inv_IssueMasterReturn.IsIssue = cbIsIssue.Checked;
inv_IssueMasterReturn.ExtraField1 = txtExtraField1.Text;
inv_IssueMasterReturn.ExtraField2 = txtExtraField2.Text;
inv_IssueMasterReturn.ExtraField3 = txtExtraField3.Text;
inv_IssueMasterReturn.ExtraField4 = txtExtraField4.Text;
inv_IssueMasterReturn.ExtraField5 = txtExtraField5.Text;
inv_IssueMasterReturn.AddedBy = Int32.Parse(txtAddedBy.Text);
inv_IssueMasterReturn.AddedDate = DateTime.Now;
inv_IssueMasterReturn.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
inv_IssueMasterReturn.UpdatedDate = txtUpdatedDate.Text;
inv_IssueMasterReturn.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = Inv_IssueMasterReturnManager.InsertInv_IssueMasterReturn(inv_IssueMasterReturn);
Response.Redirect("AdminInv_IssueMasterReturnDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
inv_IssueMasterReturn.IssueReturnName = txtIssueReturnName.Text;
inv_IssueMasterReturn.IssueReturnDate = txtIssueReturnDate.Text;
inv_IssueMasterReturn.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMasterReturn.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMasterReturn.Particulars = txtParticulars.Text;
inv_IssueMasterReturn.IsIssue = cbIsIssue.Checked;
inv_IssueMasterReturn.ExtraField1 = txtExtraField1.Text;
inv_IssueMasterReturn.ExtraField2 = txtExtraField2.Text;
inv_IssueMasterReturn.ExtraField3 = txtExtraField3.Text;
inv_IssueMasterReturn.ExtraField4 = txtExtraField4.Text;
inv_IssueMasterReturn.ExtraField5 = txtExtraField5.Text;
inv_IssueMasterReturn.AddedBy = Int32.Parse(txtAddedBy.Text);
inv_IssueMasterReturn.AddedDate = DateTime.Now;
inv_IssueMasterReturn.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
inv_IssueMasterReturn.UpdatedDate = txtUpdatedDate.Text;
inv_IssueMasterReturn.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = Inv_IssueMasterReturnManager.InsertInv_IssueMasterReturn(inv_IssueMasterReturn);
Response.Redirect("AdminInv_IssueMasterReturnDisplay.aspx");
}
public Inv_IssueMasterReturn GetInv_IssueMasterReturnFromReader(IDataReader reader)
{
try
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn
(
(int)reader["Inv_IssueMasterReturnID"],
reader["IssueReturnName"].ToString(),
(DateTime)reader["IssueReturnDate"],
(int)reader["EmployeeID"],
(int)reader["WorkSatationID"],
reader["Particulars"].ToString(),
(bool)reader["IsIssue"],
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_IssueMasterReturn;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateInv_IssueMasterReturn(Inv_IssueMasterReturn inv_IssueMasterReturn)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_IssueMasterReturn", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_IssueMasterReturnID", SqlDbType.Int).Value = inv_IssueMasterReturn.Inv_IssueMasterReturnID;
cmd.Parameters.Add("@IssueReturnName", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.IssueReturnName;
cmd.Parameters.Add("@IssueReturnDate", SqlDbType.DateTime).Value = inv_IssueMasterReturn.IssueReturnDate;
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = inv_IssueMasterReturn.EmployeeID;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_IssueMasterReturn.WorkSatationID;
cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = inv_IssueMasterReturn.Particulars;
cmd.Parameters.Add("@IsIssue", SqlDbType.Bit).Value = inv_IssueMasterReturn.IsIssue;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_IssueMasterReturn.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_IssueMasterReturn.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_IssueMasterReturn.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_IssueMasterReturn.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_IssueMasterReturn.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_IssueMasterReturn.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
private void loadData()
{
int IssueReturnID = int.Parse(Request.QueryString["IssueReturnID"]);
//purchase info
Inv_IssueMasterReturn issueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(IssueReturnID);
lblPurchaseDate.Text = issueMasterReturn.IssueReturnDate.ToString("dd-MMM-yyyy");
lblPurchaseID.Text = issueMasterReturn.Inv_IssueMasterReturnID.ToString();
//lblInvoiceNo.Text = purchase.InvoiceNo;
lblSupplierName.Text = issueMasterReturn.ExtraField1;
lblParticulars.Text = issueMasterReturn.Particulars;
if (issueMasterReturn.IsIssue)
{
#region Productive issue
//Item Info
List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterReturnID(IssueReturnID.ToString());
List <Inv_IssueDetail> inv_IssueDetailsArranged = new List <Inv_IssueDetail>();
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
{
AddedIssedItem.IsProcessed = false;
}
foreach (Inv_IssueDetail rootIssedItem in inv_IssueDetailsFromDB)
{
if (rootIssedItem.AdditionalWithIssueDetailID == 0)
{
rootIssedItem.ParentChildGap = "";
rootIssedItem.IsProcessed = true;
inv_IssueDetailsArranged.Add(rootIssedItem);
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
{
if (AddedIssedItem.AdditionalWithIssueDetailID == rootIssedItem.Inv_IssueDetailID)
{
AddedIssedItem.IsProcessed = true;
AddedIssedItem.ParentChildGap = "----";
inv_IssueDetailsArranged.Add(AddedIssedItem);
}
}
}
}
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
{
if (!AddedIssedItem.IsProcessed)
{
AddedIssedItem.IsProcessed = true;
AddedIssedItem.ParentChildGap = "";
inv_IssueDetailsArranged.Add(AddedIssedItem);
}
}
string htmlTable = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
<tr id='tableHeader'>
<td style='border-left:0px;'>SL no</td>
<td>Code</td>
<td>Description</td>
<td>Quantity</td>
<td>Unit</td>
<td>Unit price</td>
<td>Amount</td>
<td>Quality</td>
<td>Issue For</td>
<td>Qppx. Qty</td>
</tr>";
int lastProductID = 0;
decimal subTotalQuantity = 0;
decimal subTotalAmount = 0;
decimal subTotalAppxQty = 0;
decimal totalQuantity = 0;
decimal totalAmount = 0;
decimal totalAppxQty = 0;
int serialNo = 1;
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsArranged)
{
if (lastProductID != 0 && lastProductID != AddedIssedItem.ProductID)
{
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + subTotalQuantity.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + subTotalAmount.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + subTotalAppxQty.ToString("0,0.00") + @"</td>
</tr>";
subTotalQuantity = 0;
subTotalAmount = 0;
subTotalAppxQty = 0;
}
if (lastProductID != AddedIssedItem.ProductID)
{
lastProductID = AddedIssedItem.ProductID;
htmlTable += @"<tr>
<td colspan='10' style='padding-left:50px; border-top:1px solid black;border-bottom:1px solid black;font-weight:bold;'>
Issued For: " + AddedIssedItem.ProductName + @"
</td>
</tr>";
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" + AddedIssedItem.ItemCode + @"</td>
<td>" + AddedIssedItem.ItemName + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.Quantity.ToString("0,0.00") + @"</td>
<td>" + AddedIssedItem.QuantityUnitName + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.PricePerUnit.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.TotalPrice.ToString("0,0.00") + @"</td>
<td>" + AddedIssedItem.QualityUnitValue + @" - " + AddedIssedItem.QualityUnitName + @"</td>
<td>" + AddedIssedItem.ProductName + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.ApproximateQuantity.ToString("0,0.00") + @"</td>
</tr>";
subTotalQuantity += AddedIssedItem.Quantity;
subTotalAmount += AddedIssedItem.TotalPrice;
subTotalAppxQty += AddedIssedItem.ApproximateQuantity;
totalQuantity += AddedIssedItem.Quantity;
totalAmount += AddedIssedItem.TotalPrice;
totalAppxQty += AddedIssedItem.ApproximateQuantity;
}
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + subTotalQuantity.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + subTotalAmount.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + subTotalAppxQty.ToString("0,0.00") + @"</td>
</tr>";
htmlTable += @"<tr id='lastRow'>
<td> </td>
<td> </td>
<td>Grand Total</td>
<td>" + totalQuantity.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + totalAmount.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + totalAppxQty.ToString("0,0.00") + @"</td>
</tr></table>";
lblItemList.Text = htmlTable;
#endregion
}
else
{
#region Non-productive issue
//Item Info
List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterReturnID(IssueReturnID.ToString());
List <Inv_IssueDetail> inv_IssueDetailsArranged = new List <Inv_IssueDetail>();
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
{
AddedIssedItem.IsProcessed = false;
}
foreach (Inv_IssueDetail rootIssedItem in inv_IssueDetailsFromDB)
{
if (rootIssedItem.AdditionalWithIssueDetailID == 0)
{
rootIssedItem.ParentChildGap = "";
rootIssedItem.IsProcessed = true;
inv_IssueDetailsArranged.Add(rootIssedItem);
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
{
if (AddedIssedItem.AdditionalWithIssueDetailID == rootIssedItem.Inv_IssueDetailID)
{
AddedIssedItem.IsProcessed = true;
AddedIssedItem.ParentChildGap = "----";
inv_IssueDetailsArranged.Add(AddedIssedItem);
}
}
}
}
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
{
if (!AddedIssedItem.IsProcessed)
{
AddedIssedItem.IsProcessed = true;
AddedIssedItem.ParentChildGap = "";
inv_IssueDetailsArranged.Add(AddedIssedItem);
}
}
string htmlTable = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
<tr id='tableHeader'>
<td style='border-left:0px;'>SL no</td>
<td>Product ID</td>
<td>Description</td>
<td>Quantity</td>
<td>Rate</td>
<td>Amount</td>
</tr>";
decimal totalQuantity = 0;
decimal totalAmount = 0;
int serialNo = 1;
foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsArranged)
{
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" + AddedIssedItem.ItemCode + @"</td>
<td>" + AddedIssedItem.ItemName + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.Quantity.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.PricePerUnit.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + AddedIssedItem.TotalPrice.ToString("0,0.00") + @"</td>
</tr>";
totalQuantity += AddedIssedItem.Quantity;
totalAmount += AddedIssedItem.TotalPrice;
}
htmlTable += @"<tr id='lastRow'>
<td> </td>
<td> </td>
<td>Grand Total</td>
<td>" + totalQuantity.ToString("0,0.00") + @"</td>
<td> </td>
<td>" + totalAmount.ToString("0,0.00") + @"</td>
</tr></table>";
lblItemList.Text = htmlTable;
#endregion
}
}
private void showInv_IssueMasterReturnData()
{
Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();
inv_IssueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(Int32.Parse(Request.QueryString["inv_IssueMasterReturnID"]));
txtIssueReturnName.Text = inv_IssueMasterReturn.IssueReturnName;
txtIssueReturnDate.Text = inv_IssueMasterReturn.IssueReturnDate;
ddlEmployee.SelectedValue = inv_IssueMasterReturn.EmployeeID.ToString();
ddlWorkSatation.SelectedValue = inv_IssueMasterReturn.WorkSatationID.ToString();
txtParticulars.Text = inv_IssueMasterReturn.Particulars;
cbIsIssue.Checked = inv_IssueMasterReturn.IsFeature;
txtExtraField1.Text = inv_IssueMasterReturn.ExtraField1;
txtExtraField2.Text = inv_IssueMasterReturn.ExtraField2;
txtExtraField3.Text = inv_IssueMasterReturn.ExtraField3;
txtExtraField4.Text = inv_IssueMasterReturn.ExtraField4;
txtExtraField5.Text = inv_IssueMasterReturn.ExtraField5;
txtAddedBy.Text = inv_IssueMasterReturn.AddedBy.ToString();
txtUpdatedBy.Text = inv_IssueMasterReturn.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_IssueMasterReturn.UpdatedDate;
ddlRowStatus.SelectedValue = inv_IssueMasterReturn.RowStatusID.ToString();
}
public static bool UpdateInv_IssueMasterReturn(Inv_IssueMasterReturn inv_IssueMasterReturn)
{
SqlInv_IssueMasterReturnProvider sqlInv_IssueMasterReturnProvider = new SqlInv_IssueMasterReturnProvider();
return(sqlInv_IssueMasterReturnProvider.UpdateInv_IssueMasterReturn(inv_IssueMasterReturn));
}
public static int InsertInv_IssueMasterReturn(Inv_IssueMasterReturn inv_IssueMasterReturn)
{
SqlInv_IssueMasterReturnProvider sqlInv_IssueMasterReturnProvider = new SqlInv_IssueMasterReturnProvider();
return(sqlInv_IssueMasterReturnProvider.InsertInv_IssueMasterReturn(inv_IssueMasterReturn));
}
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_IssueMasterReturn(Inv_IssueMasterReturn inv_IssueMasterReturn)
{
SqlInv_IssueMasterReturnProvider sqlInv_IssueMasterReturnProvider = new SqlInv_IssueMasterReturnProvider();
return sqlInv_IssueMasterReturnProvider.UpdateInv_IssueMasterReturn(inv_IssueMasterReturn);
}
public static int InsertInv_IssueMasterReturn(Inv_IssueMasterReturn inv_IssueMasterReturn)
{
SqlInv_IssueMasterReturnProvider sqlInv_IssueMasterReturnProvider = new SqlInv_IssueMasterReturnProvider();
return sqlInv_IssueMasterReturnProvider.InsertInv_IssueMasterReturn(inv_IssueMasterReturn);
}
