protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(Int32.Parse(Request.QueryString["inv_IssueMasterID"]));
Inv_IssueMaster tempInv_IssueMaster = new Inv_IssueMaster();
tempInv_IssueMaster.Inv_IssueMasterID = inv_IssueMaster.Inv_IssueMasterID;
tempInv_IssueMaster.IssueName = txtIssueName.Text;
tempInv_IssueMaster.IssueDate = txtIssueDate.Text;
tempInv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
tempInv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
tempInv_IssueMaster.Particulars = txtParticulars.Text;
tempInv_IssueMaster.IsIssue = cbIsIssue.Checked;
tempInv_IssueMaster.ExtraField1 = txtExtraField1.Text;
tempInv_IssueMaster.ExtraField2 = txtExtraField2.Text;
tempInv_IssueMaster.ExtraField3 = txtExtraField3.Text;
tempInv_IssueMaster.ExtraField4 = txtExtraField4.Text;
tempInv_IssueMaster.ExtraField5 = txtExtraField5.Text;
tempInv_IssueMaster.AddedBy = getLogin().LoginID;
tempInv_IssueMaster.AddedDate = DateTime.Now;
tempInv_IssueMaster.UpdatedBy = getLogin().LoginID;
tempInv_IssueMaster.UpdatedDate = DateTime.Now;
tempInv_IssueMaster.RowStatusID = 1;
bool result = Inv_IssueMasterManager.UpdateInv_IssueMaster(tempInv_IssueMaster);
Response.Redirect("AdminInv_IssueMasterDisplay.aspx");
}
public Inv_IssueMaster GetInv_IssueMasterFromReader(IDataReader reader)
{
try
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster
(
(int)reader["Inv_IssueMasterID"],
reader["IssueName"].ToString(),
(DateTime)reader["IssueDate"],
(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_IssueMaster);
}
catch (Exception ex)
{
return(null);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(Int32.Parse(Request.QueryString["inv_IssueMasterID"]));
Inv_IssueMaster tempInv_IssueMaster = new Inv_IssueMaster();
tempInv_IssueMaster.Inv_IssueMasterID = inv_IssueMaster.Inv_IssueMasterID;
tempInv_IssueMaster.IssueName = txtIssueName.Text;
tempInv_IssueMaster.IssueDate = txtIssueDate.Text;
tempInv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
tempInv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
tempInv_IssueMaster.Particulars = txtParticulars.Text;
tempInv_IssueMaster.IsIssue = cbIsIssue.Checked;
tempInv_IssueMaster.ExtraField1 = txtExtraField1.Text;
tempInv_IssueMaster.ExtraField2 = txtExtraField2.Text;
tempInv_IssueMaster.ExtraField3 = txtExtraField3.Text;
tempInv_IssueMaster.ExtraField4 = txtExtraField4.Text;
tempInv_IssueMaster.ExtraField5 = txtExtraField5.Text;
tempInv_IssueMaster.AddedBy =getLogin().LoginID;
tempInv_IssueMaster.AddedDate = DateTime.Now;
tempInv_IssueMaster.UpdatedBy = getLogin().LoginID;
tempInv_IssueMaster.UpdatedDate = DateTime.Now;
tempInv_IssueMaster.RowStatusID = 1;
bool result = Inv_IssueMasterManager.UpdateInv_IssueMaster(tempInv_IssueMaster);
Response.Redirect("AdminInv_IssueMasterDisplay.aspx");
}
public bool UpdateInv_IssueMaster(Inv_IssueMaster inv_IssueMaster)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_IssueMaster", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_IssueMasterID", SqlDbType.Int).Value = inv_IssueMaster.Inv_IssueMasterID;
cmd.Parameters.Add("@IssueName", SqlDbType.NVarChar).Value = inv_IssueMaster.IssueName;
cmd.Parameters.Add("@IssueDate", SqlDbType.DateTime).Value = inv_IssueMaster.IssueDate;
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = inv_IssueMaster.EmployeeID;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_IssueMaster.WorkSatationID;
cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = inv_IssueMaster.Particulars;
cmd.Parameters.Add("@IsIssue", SqlDbType.Bit).Value = inv_IssueMaster.IsIssue;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_IssueMaster.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_IssueMaster.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_IssueMaster.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_IssueMaster.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_IssueMaster.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static Inv_IssueMaster GetInv_IssueMasterByID(int id)
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
SqlInv_IssueMasterProvider sqlInv_IssueMasterProvider = new SqlInv_IssueMasterProvider();
inv_IssueMaster = sqlInv_IssueMasterProvider.GetInv_IssueMasterByID(id);
return(inv_IssueMaster);
}
private void showInv_IssueDetailGrid()
{
Inv_IssueMaster issueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(int.Parse(Request.QueryString["IssueMasterID"]));
txtIssueDate.Text = issueMaster.IssueDate.ToString("dd MMM yyyy");
ddlEmployee.SelectedValue = issueMaster.EmployeeID.ToString();
ddlWorkSatation.SelectedValue = issueMaster.WorkSatationID.ToString();
txtParticulars.Text = issueMaster.Particulars;
}
private void showInv_IssueDetailGrid()
{
Inv_IssueMaster issueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(int.Parse(Request.QueryString["IssueMasterID"]));
txtIssueDate.Text = issueMaster.IssueDate.ToString("dd MMM yyyy");
ddlEmployee.SelectedValue = issueMaster.EmployeeID.ToString();
ddlWorkSatation.SelectedValue = issueMaster.WorkSatationID.ToString();
List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterID(Request.QueryString["IssueMasterID"]);
gvInv_IssueDetail.DataSource = inv_IssueDetailsFromDB;
gvInv_IssueDetail.DataBind();
}
private void showInv_IssueMasterData()
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(Int32.Parse(Request.QueryString["inv_IssueMasterID"]));
txtIssueName.Text = inv_IssueMaster.IssueName;
txtIssueDate.Text = inv_IssueMaster.IssueDate;
ddlEmployee.SelectedValue = inv_IssueMaster.EmployeeID.ToString();
ddlWorkSatation.SelectedValue = inv_IssueMaster.WorkSatationID.ToString();
txtParticulars.Text = inv_IssueMaster.Particulars;
cbIsIssue.Checked = inv_IssueMaster.IsFeature;
txtExtraField1.Text = inv_IssueMaster.ExtraField1;
txtExtraField2.Text = inv_IssueMaster.ExtraField2;
txtExtraField3.Text = inv_IssueMaster.ExtraField3;
txtExtraField4.Text = inv_IssueMaster.ExtraField4;
txtExtraField5.Text = inv_IssueMaster.ExtraField5;
txtAddedBy.Text = inv_IssueMaster.AddedBy.ToString();
txtUpdatedBy.Text = inv_IssueMaster.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_IssueMaster.UpdatedDate;
ddlRowStatus.SelectedValue = inv_IssueMaster.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster.IssueName = txtIssueName.Text;
inv_IssueMaster.IssueDate = txtIssueDate.Text;
inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMaster.Particulars = txtParticulars.Text;
inv_IssueMaster.IsIssue = cbIsIssue.Checked;
inv_IssueMaster.ExtraField1 = txtExtraField1.Text;
inv_IssueMaster.ExtraField2 = txtExtraField2.Text;
inv_IssueMaster.ExtraField3 = txtExtraField3.Text;
inv_IssueMaster.ExtraField4 = txtExtraField4.Text;
inv_IssueMaster.ExtraField5 = txtExtraField5.Text;
inv_IssueMaster.AddedBy =getLogin().LoginID;
inv_IssueMaster.AddedDate = DateTime.Now;
inv_IssueMaster.UpdatedBy = getLogin().LoginID;
inv_IssueMaster.UpdatedDate = DateTime.Now;
inv_IssueMaster.RowStatusID = 1;
int resutl = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster);
Response.Redirect("AdminInv_IssueMasterDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster.IssueName = txtIssueName.Text;
inv_IssueMaster.IssueDate = txtIssueDate.Text;
inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMaster.Particulars = txtParticulars.Text;
inv_IssueMaster.IsIssue = cbIsIssue.Checked;
inv_IssueMaster.ExtraField1 = txtExtraField1.Text;
inv_IssueMaster.ExtraField2 = txtExtraField2.Text;
inv_IssueMaster.ExtraField3 = txtExtraField3.Text;
inv_IssueMaster.ExtraField4 = txtExtraField4.Text;
inv_IssueMaster.ExtraField5 = txtExtraField5.Text;
inv_IssueMaster.AddedBy = getLogin().LoginID;
inv_IssueMaster.AddedDate = DateTime.Now;
inv_IssueMaster.UpdatedBy = getLogin().LoginID;
inv_IssueMaster.UpdatedDate = DateTime.Now;
inv_IssueMaster.RowStatusID = 1;
int resutl = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster);
Response.Redirect("AdminInv_IssueMasterDisplay.aspx");
}
public bool UpdateInv_IssueMaster(Inv_IssueMaster inv_IssueMaster)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_IssueMaster", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_IssueMasterID", SqlDbType.Int).Value = inv_IssueMaster.Inv_IssueMasterID;
cmd.Parameters.Add("@IssueName", SqlDbType.NVarChar).Value = inv_IssueMaster.IssueName;
cmd.Parameters.Add("@IssueDate", SqlDbType.DateTime).Value = inv_IssueMaster.IssueDate;
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = inv_IssueMaster.EmployeeID;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_IssueMaster.WorkSatationID;
cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = inv_IssueMaster.Particulars;
cmd.Parameters.Add("@IsIssue", SqlDbType.Bit).Value = inv_IssueMaster.IsIssue;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_IssueMaster.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_IssueMaster.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_IssueMaster.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_IssueMaster.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_IssueMaster.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_IssueMaster.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
private void showInv_IssueMasterData()
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(Int32.Parse(Request.QueryString["inv_IssueMasterID"]));
txtIssueName.Text = inv_IssueMaster.IssueName;
txtIssueDate.Text = inv_IssueMaster.IssueDate;
ddlEmployee.SelectedValue = inv_IssueMaster.EmployeeID.ToString();
ddlWorkSatation.SelectedValue = inv_IssueMaster.WorkSatationID.ToString();
txtParticulars.Text = inv_IssueMaster.Particulars;
cbIsIssue.Checked = inv_IssueMaster.IsFeature;
txtExtraField1.Text = inv_IssueMaster.ExtraField1;
txtExtraField2.Text = inv_IssueMaster.ExtraField2;
txtExtraField3.Text = inv_IssueMaster.ExtraField3;
txtExtraField4.Text = inv_IssueMaster.ExtraField4;
txtExtraField5.Text = inv_IssueMaster.ExtraField5;
txtAddedBy.Text = inv_IssueMaster.AddedBy.ToString();
txtUpdatedBy.Text = inv_IssueMaster.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_IssueMaster.UpdatedDate;
ddlRowStatus.SelectedValue = inv_IssueMaster.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!checking())
{
return;
}
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster.IssueName = "";
inv_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text);
inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMaster.Particulars = txtParticulars.Text;
inv_IssueMaster.IsIssue = (Request.QueryString["IsNonProduction"] != null ? false : true);
inv_IssueMaster.ExtraField1 = "";
inv_IssueMaster.ExtraField2 = "";
inv_IssueMaster.ExtraField3 = "";
inv_IssueMaster.ExtraField4 = "";
inv_IssueMaster.ExtraField5 = "";
inv_IssueMaster.AddedBy = getLogin().LoginID;
inv_IssueMaster.AddedDate = DateTime.Now;
inv_IssueMaster.UpdatedBy = getLogin().LoginID;
inv_IssueMaster.UpdatedDate = DateTime.Now;
inv_IssueMaster.RowStatusID = 1;
if (txtOldIssueID.Text == "")
{
inv_IssueMaster.Inv_IssueMasterID = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster);
}
else
{
inv_IssueMaster.Inv_IssueMasterID = int.Parse(txtOldIssueID.Text);
}
int JournalMasterID = 0;
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID");
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
TextBox txtIssueQuantity = (TextBox)gvr.FindControl("txtIssueQuantity");
TextBox txtApproximateQuantity = (TextBox)gvr.FindControl("txtApproximateQuantity");
DropDownList ddlProduct = (DropDownList)gvr.FindControl("ddlProduct");
HiddenField hfRawMaterialTypeID = (HiddenField)gvr.FindControl("hfRawMaterialTypeID");
if (hfRawMaterialTypeID.Value == "10" && JournalMasterID == 0)
{
if (ddlWorkSatation.SelectedValue != "1")
{
//Journal Entry
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "3";//Journal Voucher
aCC_JournalMaster.ExtraField1 = ddlWorkSatation.SelectedItem.Text;
aCC_JournalMaster.ExtraField2 = "";
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = "Inventory Issue-" + inv_IssueMaster.Inv_IssueMasterID.ToString();
aCC_JournalMaster.JournalDate = DateTime.Parse(txtIssueDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
}
}
Label lblAvailableQuantity = (Label)gvr.FindControl("lblExtraFieldQuantity1");
if (txtIssueQuantity.Text != "0" && txtIssueQuantity.Text != "")
{
Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail();
inv_IssueDetail.ItemID = Int32.Parse(hfInv_ItemID.Value);
inv_IssueDetail.Quantity = Decimal.Parse(txtIssueQuantity.Text);
inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_IssueDetail.AdditionalWithIssueDetailID = 0;
inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text);
inv_IssueDetail.ExtraField1 = txtIssueQuantity.Text;
inv_IssueDetail.ExtraField2 = "0";
inv_IssueDetail.ExtraField3 = "0";
inv_IssueDetail.ExtraField4 = (hfRawMaterialTypeID.Value == "10"?JournalMasterID.ToString():"0");
inv_IssueDetail.ExtraField5 = inv_IssueMaster.Inv_IssueMasterID.ToString();
inv_IssueDetail.AddedBy = getLogin().LoginID;
inv_IssueDetail.AddedDate = DateTime.Now;
inv_IssueDetail.UpdatedBy = getLogin().LoginID;
inv_IssueDetail.UpdatedDate = DateTime.Now;
inv_IssueDetail.RowStatusID = 1;
if (Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail) <= 0)
{
showAlartMessage("Double Pressed");
return;
}
}
}
hlnkIssuePrint.NavigateUrl = "IssuePrint.aspx?IssueID=" + inv_IssueMaster.Inv_IssueMasterID.ToString();
hlnkIssuePrint.Visible = true;
showInv_IssueDetailGrid();
}
private void loadData()
{
int issueID = int.Parse(Request.QueryString["IssueID"]);
//purchase info
Inv_IssueMaster issueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(issueID);
lblPurchaseDate.Text = issueMaster.IssueDate.ToString("dd-MMM-yyyy");
lblPurchaseID.Text = "<a href='IssueModification.aspx?IssueMasterID=" + issueMaster.Inv_IssueMasterID.ToString() + "' target='_blank'>" + issueMaster.Inv_IssueMasterID.ToString() + "</a>";
//lblInvoiceNo.Text = purchase.InvoiceNo;
lblSupplierName.Text = issueMaster.ExtraField1;
lblParticulars.Text = issueMaster.Particulars;
if (issueMaster.IsIssue)
{
#region Productive issue
//Item Info
List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterID(issueID.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;'>
Issue For: " + AddedIssedItem.ProductName + @"
</td>
</tr>";
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + (AddedIssedItem.AddedDate <= DateTime.Parse("19 Apr 2012")?"": (" <a href='IssueDetailDelete.aspx?IssueDetailID=" + AddedIssedItem.Inv_IssueDetailID.ToString() + "&IssueID=" + Request.QueryString["IssueID"] + "' style='color:red;'>X</a>")) + @"</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_IssueDetailsByIssueMasterID(issueID.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
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!checking())
{
return;
}
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster.IssueName = "";
inv_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text);
inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMaster.Particulars = txtParticulars.Text;
inv_IssueMaster.IsIssue = (Request.QueryString["IsNonProduction"] != null ? false : true);
inv_IssueMaster.ExtraField1 = "";
inv_IssueMaster.ExtraField2 = "";
inv_IssueMaster.ExtraField3 = "";
inv_IssueMaster.ExtraField4 = "";
inv_IssueMaster.ExtraField5 = "";
inv_IssueMaster.AddedBy = getLogin().LoginID;
inv_IssueMaster.AddedDate = DateTime.Now;
inv_IssueMaster.UpdatedBy = getLogin().LoginID;
inv_IssueMaster.UpdatedDate = DateTime.Now;
inv_IssueMaster.RowStatusID = 1;
if (txtOldIssueID.Text == "")
{
inv_IssueMaster.Inv_IssueMasterID = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster);
}
else
{
inv_IssueMaster.Inv_IssueMasterID = int.Parse(txtOldIssueID.Text);
}
int JournalMasterID = 0;
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID");
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
TextBox txtIssueQuantity = (TextBox)gvr.FindControl("txtIssueQuantity");
TextBox txtApproximateQuantity = (TextBox)gvr.FindControl("txtApproximateQuantity");
DropDownList ddlProduct = (DropDownList)gvr.FindControl("ddlProduct");
HiddenField hfRawMaterialTypeID = (HiddenField)gvr.FindControl("hfRawMaterialTypeID");
if (hfRawMaterialTypeID.Value == "10" && JournalMasterID == 0)
{
if (ddlWorkSatation.SelectedValue != "1")
{
//Journal Entry
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "3";//Journal Voucher
aCC_JournalMaster.ExtraField1 = ddlWorkSatation.SelectedItem.Text;
aCC_JournalMaster.ExtraField2 = "";
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = "Inventory Issue-" + inv_IssueMaster.Inv_IssueMasterID.ToString();
aCC_JournalMaster.JournalDate = DateTime.Parse(txtIssueDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
}
}
Label lblAvailableQuantity = (Label)gvr.FindControl("lblExtraFieldQuantity1");
if (txtIssueQuantity.Text != "0" && txtIssueQuantity.Text != "")
{
Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail();
inv_IssueDetail.ItemID = Int32.Parse(hfInv_ItemID.Value);
inv_IssueDetail.Quantity = Decimal.Parse(txtIssueQuantity.Text);
inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_IssueDetail.AdditionalWithIssueDetailID = 0;
inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text);
inv_IssueDetail.ExtraField1 = txtIssueQuantity.Text;
inv_IssueDetail.ExtraField2 = "0";
inv_IssueDetail.ExtraField3 = "0";
inv_IssueDetail.ExtraField4 = (hfRawMaterialTypeID.Value == "10"?JournalMasterID.ToString():"0");
inv_IssueDetail.ExtraField5 = inv_IssueMaster.Inv_IssueMasterID.ToString();
inv_IssueDetail.AddedBy = getLogin().LoginID;
inv_IssueDetail.AddedDate = DateTime.Now;
inv_IssueDetail.UpdatedBy = getLogin().LoginID;
inv_IssueDetail.UpdatedDate = DateTime.Now;
inv_IssueDetail.RowStatusID = 1;
if (Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail) <= 0)
{
showAlartMessage("Double Pressed");
return;
}
}
}
hlnkIssuePrint.NavigateUrl = "IssuePrint.aspx?IssueID=" + inv_IssueMaster.Inv_IssueMasterID.ToString();
hlnkIssuePrint.Visible = true;
showInv_IssueDetailGrid();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
//if(Request.QueryString["IsNonProduction"] == null)
//addConfiguration();
if (Request.QueryString["IsNonProduction"] != null)
{
txtApproximateQuantity.Text = txtQuantity.Text;
}
if (hfInv_IssueMasterID.Value == "0" || hfInv_IssueMasterID.Value == "")
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster.IssueName = "";
inv_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text);
inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMaster.Particulars = txtParticulars.Text;
inv_IssueMaster.IsIssue =( Request.QueryString["IsNonProduction"] != null ?false:true);
inv_IssueMaster.ExtraField1 = "";
inv_IssueMaster.ExtraField2 = "";
inv_IssueMaster.ExtraField3 = "";
inv_IssueMaster.ExtraField4 = "";
inv_IssueMaster.ExtraField5 = "";
inv_IssueMaster.AddedBy = getLogin().LoginID;
inv_IssueMaster.AddedDate = DateTime.Now;
inv_IssueMaster.UpdatedBy = getLogin().LoginID;
inv_IssueMaster.UpdatedDate = DateTime.Now;
inv_IssueMaster.RowStatusID = 1;
hfInv_IssueMasterID.Value = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster).ToString();
}
Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail();
inv_IssueDetail.ItemID = Int32.Parse(ddlItem.SelectedValue);
inv_IssueDetail.Quantity = Decimal.Parse(txtQuantity.Text);
inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue);
if (ddlIssuedItem.Items.Count == 0 || ddlIssuedItem.SelectedValue == "0")
{
inv_IssueDetail.AdditionalWithIssueDetailID = 0;
inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text);
}
else
{
inv_IssueDetail.AdditionalWithIssueDetailID = int.Parse(ddlIssuedItem.SelectedValue);
inv_IssueDetail.ApproximateQuantity = 0;
}
//inv_IssueDetail.ExtraField1 = ddlItem.SelectedItem.Text.Split(' ')[0]; //Item COde
//inv_IssueDetail.ExtraField2 = ddlItem.SelectedItem.Text.Split('{')[0].Trim().Replace(inv_IssueDetail.ExtraField1 +" - ","");//item Name
//inv_IssueDetail.ExtraField3 = ddlItem.SelectedItem.Text.Split('{')[1].Split('}')[0];//quality
//inv_IssueDetail.ExtraField4 = Request.QueryString["IsNonProduction"] != null ?"":ddlProduct.SelectedItem.Text;//productName
//inv_IssueDetail.ExtraField5 = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(ddlItem.SelectedValue)).PricePerUnit.ToString("0,0.00");//Price Per unit
inv_IssueDetail.ExtraField1 = txtQuantity.Text;
inv_IssueDetail.ExtraField2 = "0";
inv_IssueDetail.ExtraField3 = "0";
inv_IssueDetail.ExtraField4 = "0";
inv_IssueDetail.ExtraField5 = hfInv_IssueMasterID.Value;
inv_IssueDetail.AddedBy =getLogin().LoginID;
inv_IssueDetail.AddedDate = DateTime.Now;
inv_IssueDetail.UpdatedBy = getLogin().LoginID;
inv_IssueDetail.UpdatedDate = DateTime.Now;
inv_IssueDetail.RowStatusID = 1;
Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail);
showInv_IssueDetailGrid();
//btnClear_Click(this, new EventArgs());
}
public Inv_IssueMaster GetInv_IssueMasterFromReader(IDataReader reader)
{
try
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster
(
(int)reader["Inv_IssueMasterID"],
reader["IssueName"].ToString(),
(DateTime)reader["IssueDate"],
(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_IssueMaster;
}
catch(Exception ex)
{
return null;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
//if(Request.QueryString["IsNonProduction"] == null)
//addConfiguration();
if (Request.QueryString["IsNonProduction"] != null)
{
txtApproximateQuantity.Text = txtQuantity.Text;
}
if (hfInv_IssueMasterID.Value == "0" || hfInv_IssueMasterID.Value == "")
{
Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster();
inv_IssueMaster.IssueName = "";
inv_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text);
inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_IssueMaster.Particulars = txtParticulars.Text;
inv_IssueMaster.IsIssue = (Request.QueryString["IsNonProduction"] != null ?false:true);
inv_IssueMaster.ExtraField1 = "";
inv_IssueMaster.ExtraField2 = "";
inv_IssueMaster.ExtraField3 = "";
inv_IssueMaster.ExtraField4 = "";
inv_IssueMaster.ExtraField5 = "";
inv_IssueMaster.AddedBy = getLogin().LoginID;
inv_IssueMaster.AddedDate = DateTime.Now;
inv_IssueMaster.UpdatedBy = getLogin().LoginID;
inv_IssueMaster.UpdatedDate = DateTime.Now;
inv_IssueMaster.RowStatusID = 1;
hfInv_IssueMasterID.Value = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster).ToString();
}
Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail();
inv_IssueDetail.ItemID = Int32.Parse(ddlItem.SelectedValue);
inv_IssueDetail.Quantity = Decimal.Parse(txtQuantity.Text);
inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue);
if (ddlIssuedItem.Items.Count == 0 || ddlIssuedItem.SelectedValue == "0")
{
inv_IssueDetail.AdditionalWithIssueDetailID = 0;
inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text);
}
else
{
inv_IssueDetail.AdditionalWithIssueDetailID = int.Parse(ddlIssuedItem.SelectedValue);
inv_IssueDetail.ApproximateQuantity = 0;
}
//inv_IssueDetail.ExtraField1 = ddlItem.SelectedItem.Text.Split(' ')[0]; //Item COde
//inv_IssueDetail.ExtraField2 = ddlItem.SelectedItem.Text.Split('{')[0].Trim().Replace(inv_IssueDetail.ExtraField1 +" - ","");//item Name
//inv_IssueDetail.ExtraField3 = ddlItem.SelectedItem.Text.Split('{')[1].Split('}')[0];//quality
//inv_IssueDetail.ExtraField4 = Request.QueryString["IsNonProduction"] != null ?"":ddlProduct.SelectedItem.Text;//productName
//inv_IssueDetail.ExtraField5 = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(ddlItem.SelectedValue)).PricePerUnit.ToString("0,0.00");//Price Per unit
inv_IssueDetail.ExtraField1 = txtQuantity.Text;
inv_IssueDetail.ExtraField2 = "0";
inv_IssueDetail.ExtraField3 = "0";
inv_IssueDetail.ExtraField4 = "0";
inv_IssueDetail.ExtraField5 = hfInv_IssueMasterID.Value;
inv_IssueDetail.AddedBy = getLogin().LoginID;
inv_IssueDetail.AddedDate = DateTime.Now;
inv_IssueDetail.UpdatedBy = getLogin().LoginID;
inv_IssueDetail.UpdatedDate = DateTime.Now;
inv_IssueDetail.RowStatusID = 1;
Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail);
showInv_IssueDetailGrid();
//btnClear_Click(this, new EventArgs());
}
public static int InsertInv_IssueMaster(Inv_IssueMaster inv_IssueMaster)
{
SqlInv_IssueMasterProvider sqlInv_IssueMasterProvider = new SqlInv_IssueMasterProvider();
return(sqlInv_IssueMasterProvider.InsertInv_IssueMaster(inv_IssueMaster));
}
public static bool UpdateInv_IssueMaster(Inv_IssueMaster inv_IssueMaster)
{
SqlInv_IssueMasterProvider sqlInv_IssueMasterProvider = new SqlInv_IssueMasterProvider();
return(sqlInv_IssueMasterProvider.UpdateInv_IssueMaster(inv_IssueMaster));
}
