public Inv_Wastage GetInv_WastageFromReader(IDataReader reader)
{
try
{
Inv_Wastage inv_Wastage = new Inv_Wastage
(
(int)reader["Inv_WastageID"],
(DateTime)reader["WastageDate"],
reader["IssueIDs"].ToString(),
(int)reader["WorkSatationID"],
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_Wastage);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateInv_Wastage(Inv_Wastage inv_Wastage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Wastage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_WastageID", SqlDbType.Int).Value = inv_Wastage.Inv_WastageID;
cmd.Parameters.Add("@WastageDate", SqlDbType.DateTime).Value = inv_Wastage.WastageDate;
cmd.Parameters.Add("@IssueIDs", SqlDbType.NVarChar).Value = inv_Wastage.IssueIDs;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_Wastage.WorkSatationID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Wastage.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Wastage.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Wastage.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Wastage.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Wastage.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage = Inv_WastageManager.GetInv_WastageByID(Int32.Parse(Request.QueryString["inv_WastageID"]));
Inv_Wastage tempInv_Wastage = new Inv_Wastage();
tempInv_Wastage.Inv_WastageID = inv_Wastage.Inv_WastageID;
tempInv_Wastage.WastageDate = txtWastageDate.Text;
tempInv_Wastage.IssueIDs = Int32.Parse(ddlIssue.SelectedValue);
tempInv_Wastage.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
tempInv_Wastage.ExtraField1 = txtExtraField1.Text;
tempInv_Wastage.ExtraField2 = txtExtraField2.Text;
tempInv_Wastage.ExtraField3 = txtExtraField3.Text;
tempInv_Wastage.ExtraField4 = txtExtraField4.Text;
tempInv_Wastage.ExtraField5 = txtExtraField5.Text;
tempInv_Wastage.AddedBy = Int32.Parse(txtAddedBy.Text);
tempInv_Wastage.AddedDate = DateTime.Now;
tempInv_Wastage.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempInv_Wastage.UpdatedDate = txtUpdatedDate.Text;
tempInv_Wastage.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_WastageManager.UpdateInv_Wastage(tempInv_Wastage);
Response.Redirect("AdminInv_WastageDisplay.aspx");
}
public static Inv_Wastage GetInv_WastageByID(int id)
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
SqlInv_WastageProvider sqlInv_WastageProvider = new SqlInv_WastageProvider();
inv_Wastage = sqlInv_WastageProvider.GetInv_WastageByID(id);
return inv_Wastage;
}
public static Inv_Wastage GetInv_WastageByID(int id)
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
SqlInv_WastageProvider sqlInv_WastageProvider = new SqlInv_WastageProvider();
inv_Wastage = sqlInv_WastageProvider.GetInv_WastageByID(id);
return(inv_Wastage);
}
private void showInv_WastageData()
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage = Inv_WastageManager.GetInv_WastageByID(Int32.Parse(Request.QueryString["inv_WastageID"]));
txtWastageDate.Text = inv_Wastage.WastageDate;
ddlIssue.SelectedValue = inv_Wastage.IssueIDs.ToString();
ddlWorkSatation.SelectedValue = inv_Wastage.WorkSatationID.ToString();
txtExtraField1.Text = inv_Wastage.ExtraField1;
txtExtraField2.Text = inv_Wastage.ExtraField2;
txtExtraField3.Text = inv_Wastage.ExtraField3;
txtExtraField4.Text = inv_Wastage.ExtraField4;
txtExtraField5.Text = inv_Wastage.ExtraField5;
txtAddedBy.Text = inv_Wastage.AddedBy.ToString();
txtUpdatedBy.Text = inv_Wastage.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Wastage.UpdatedDate;
ddlRowStatus.SelectedValue = inv_Wastage.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage.WastageDate = txtWastageDate.Text;
inv_Wastage.IssueIDs = Int32.Parse(ddlIssue.SelectedValue);
inv_Wastage.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_Wastage.ExtraField1 = txtExtraField1.Text;
inv_Wastage.ExtraField2 = txtExtraField2.Text;
inv_Wastage.ExtraField3 = txtExtraField3.Text;
inv_Wastage.ExtraField4 = txtExtraField4.Text;
inv_Wastage.ExtraField5 = txtExtraField5.Text;
inv_Wastage.AddedBy = Int32.Parse(txtAddedBy.Text);
inv_Wastage.AddedDate = DateTime.Now;
inv_Wastage.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
inv_Wastage.UpdatedDate = txtUpdatedDate.Text;
inv_Wastage.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = Inv_WastageManager.InsertInv_Wastage(inv_Wastage);
Response.Redirect("AdminInv_WastageDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage.WastageDate = txtWastageDate.Text;
inv_Wastage.IssueIDs = Int32.Parse(ddlIssue.SelectedValue);
inv_Wastage.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_Wastage.ExtraField1 = txtExtraField1.Text;
inv_Wastage.ExtraField2 = txtExtraField2.Text;
inv_Wastage.ExtraField3 = txtExtraField3.Text;
inv_Wastage.ExtraField4 = txtExtraField4.Text;
inv_Wastage.ExtraField5 = txtExtraField5.Text;
inv_Wastage.AddedBy = Int32.Parse(txtAddedBy.Text);
inv_Wastage.AddedDate = DateTime.Now;
inv_Wastage.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
inv_Wastage.UpdatedDate = txtUpdatedDate.Text;
inv_Wastage.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = Inv_WastageManager.InsertInv_Wastage(inv_Wastage);
Response.Redirect("AdminInv_WastageDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage = Inv_WastageManager.GetInv_WastageByID(Int32.Parse(Request.QueryString["inv_WastageID"]));
Inv_Wastage tempInv_Wastage = new Inv_Wastage();
tempInv_Wastage.Inv_WastageID = inv_Wastage.Inv_WastageID;
tempInv_Wastage.WastageDate = txtWastageDate.Text;
tempInv_Wastage.IssueIDs = Int32.Parse(ddlIssue.SelectedValue);
tempInv_Wastage.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
tempInv_Wastage.ExtraField1 = txtExtraField1.Text;
tempInv_Wastage.ExtraField2 = txtExtraField2.Text;
tempInv_Wastage.ExtraField3 = txtExtraField3.Text;
tempInv_Wastage.ExtraField4 = txtExtraField4.Text;
tempInv_Wastage.ExtraField5 = txtExtraField5.Text;
tempInv_Wastage.AddedBy = Int32.Parse(txtAddedBy.Text);
tempInv_Wastage.AddedDate = DateTime.Now;
tempInv_Wastage.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempInv_Wastage.UpdatedDate = txtUpdatedDate.Text;
tempInv_Wastage.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_WastageManager.UpdateInv_Wastage(tempInv_Wastage);
Response.Redirect("AdminInv_WastageDisplay.aspx");
}
private void showInv_WastageData()
{
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage = Inv_WastageManager.GetInv_WastageByID(Int32.Parse(Request.QueryString["inv_WastageID"]));
txtWastageDate.Text = inv_Wastage.WastageDate;
ddlIssue.SelectedValue = inv_Wastage.IssueIDs.ToString();
ddlWorkSatation.SelectedValue = inv_Wastage.WorkSatationID.ToString();
txtExtraField1.Text = inv_Wastage.ExtraField1;
txtExtraField2.Text = inv_Wastage.ExtraField2;
txtExtraField3.Text = inv_Wastage.ExtraField3;
txtExtraField4.Text = inv_Wastage.ExtraField4;
txtExtraField5.Text = inv_Wastage.ExtraField5;
txtAddedBy.Text = inv_Wastage.AddedBy.ToString();
txtUpdatedBy.Text = inv_Wastage.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Wastage.UpdatedDate;
ddlRowStatus.SelectedValue = inv_Wastage.RowStatusID.ToString();
}
public static bool UpdateInv_Wastage(Inv_Wastage inv_Wastage)
{
SqlInv_WastageProvider sqlInv_WastageProvider = new SqlInv_WastageProvider();
return sqlInv_WastageProvider.UpdateInv_Wastage(inv_Wastage);
}
public static int InsertInv_Wastage(Inv_Wastage inv_Wastage)
{
SqlInv_WastageProvider sqlInv_WastageProvider = new SqlInv_WastageProvider();
return sqlInv_WastageProvider.InsertInv_Wastage(inv_Wastage);
}
public static bool UpdateInv_Wastage(Inv_Wastage inv_Wastage)
{
SqlInv_WastageProvider sqlInv_WastageProvider = new SqlInv_WastageProvider();
return(sqlInv_WastageProvider.UpdateInv_Wastage(inv_Wastage));
}
private void loadData()
{
int adjustmentID = int.Parse(Request.QueryString["WastageID"]);
Inv_Wastage purchaseAdjustment = Inv_WastageManager.GetInv_WastageByID(adjustmentID);
//purchase info
lblPurchaseDate.Text = purchaseAdjustment.WastageDate.ToString("dd-MMM-yyyy");
lblPurchaseReturnID.Text = purchaseAdjustment.Inv_WastageID.ToString();
//lblRefPurchaseNo.Text = purchaseAdjustment.PurchaseIDs;
lblSupplierName.Text = purchaseAdjustment.ExtraField1;
lblParticulars.Text = purchaseAdjustment.ExtraField2;
//Item Info
List <Inv_Item> items = new List <Inv_Item>();
items = Inv_ItemManager.GetAllInv_ItemsByWastageID(adjustmentID);
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;'>S/L</td>
<td>Product Code</td>
<td>Product Name</td>
<td>Quantity</td>
<td>Unit</td>
<td>Price</td>
<td>Amount</td>
</tr>";
int lastRawMaterialID = 0;
decimal Total = 0;
decimal Subtotal = 0;
decimal TotalAmount = 0;
decimal SubtotalAmount = 0;
int serialNo = 1;
foreach (Inv_Item item in items)
{
if (lastRawMaterialID != 0 && lastRawMaterialID != item.RawMaterialID)
{
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + Subtotal.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + SubtotalAmount.ToString("0,0.00") + @"</td>
</tr>";
Subtotal = 0;
SubtotalAmount = 0;
}
if (lastRawMaterialID != item.RawMaterialID)
{
lastRawMaterialID = item.RawMaterialID;
htmlTable += @"<tr>
<td colspan='7' style='padding-left:50px; border-top:1px solid black;border-bottom:1px solid black;font-weight:bold;'>
Item: " + item.RawMaterialName + @"
</td>
</tr>";
}
htmlTable += @"<tr class='itemCss'>
<td style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
<td>" + item.ItemCode + @"</td>
<td>" + item.ItemName + @"</td>
<td style='text-align:right;'>" + item.PurchasedQuantity.ToString("0,0.00") + @"</td>
<td >" + item.QuantityUnitName + @"</td>
<td style='text-align:right;'>" + item.PricePerUnit.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>" + item.PurchasedQuantityPrice.ToString("0,0.00") + @"</td>
</tr>";
Subtotal += item.PurchasedQuantity;
SubtotalAmount += item.PurchasedQuantityPrice;
Total += item.PurchasedQuantity;
TotalAmount += item.PurchasedQuantityPrice;
}
htmlTable += @"<tr class='subtotalRow'>
<td> </td>
<td> </td>
<td>Sub Total</td>
<td>" + Subtotal.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + SubtotalAmount.ToString("0,0.00") + @"</td>
</tr>";
htmlTable += @"<tr id='lastRow'>
<td> </td>
<td> </td>
<td>Grand Total</td>
<td>" + Total.ToString("0,0.00") + @"</td>
<td> </td>
<td> </td>
<td>" + TotalAmount.ToString("0,0.00") + @"</td>
</tr></table>";
lblItemList.Text = htmlTable;
}
public static int InsertInv_Wastage(Inv_Wastage inv_Wastage)
{
SqlInv_WastageProvider sqlInv_WastageProvider = new SqlInv_WastageProvider();
return(sqlInv_WastageProvider.InsertInv_Wastage(inv_Wastage));
}
protected void btnWastage_Click(object sender, EventArgs e)
{
String sql = "";
int utilizationID = 0;
int JournalMasterID = 0;
int wastageID = 0;
if (txtUtilizationID.Text == "0")
{
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "3";//Voucher Type
aCC_JournalMaster.ExtraField1 = "";
aCC_JournalMaster.ExtraField2 = "";
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = txtParticulars.Text;
aCC_JournalMaster.JournalDate = DateTime.Parse(txtDate.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 = 0;//ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
Inv_Wastage inv_Wastage = new Inv_Wastage();
inv_Wastage.WastageDate = DateTime.Parse(txtDate.Text);
inv_Wastage.IssueIDs = "";
inv_Wastage.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue);
inv_Wastage.ExtraField1 = JournalMasterID.ToString();
inv_Wastage.ExtraField2 = "";
inv_Wastage.ExtraField3 = "";
inv_Wastage.ExtraField4 = "";
inv_Wastage.ExtraField5 = "";
inv_Wastage.AddedBy = getLogin().LoginID;
inv_Wastage.AddedDate = DateTime.Now;
inv_Wastage.UpdatedBy = getLogin().LoginID;
inv_Wastage.UpdatedDate = DateTime.Now;
inv_Wastage.RowStatusID = 1;
bool isWasted = false;
foreach (GridViewRow gvr in gvInv_IssueDetail.Rows)
{
CheckBox chkSelect = (CheckBox)gvr.FindControl("chkSelect");
TextBox txtWasted = (TextBox)gvr.FindControl("txtWasted");
if (chkSelect.Checked && txtWasted.Text != "0")
{
isWasted = true;
}
}
if (isWasted)
{
wastageID = Inv_WastageManager.InsertInv_Wastage(inv_Wastage);
hlnkWastagePrint.NavigateUrl = "WastagePrint.aspx?WastageID=" + wastageID;
hlnkWastagePrint.Visible = true;
}
sql += "Update ACC_JournalMaster set Note='Wastage ID = " + wastageID.ToString() + "' where ACC_JournalMasterID=" + JournalMasterID.ToString() + ";";
}
else
{
wastageID = int.Parse(txtUtilizationID.Text);
DataSet ds = CommonManager.SQLExec("select ExtraField1 from Inv_Wastage where Inv_WastageID=" + txtUtilizationID.Text);
if (ds.Tables[0].Rows.Count == 0)
{
showAlartMessage("Wrong old Wastage ID");
return;
}
JournalMasterID = int.Parse(ds.Tables[0].Rows[0]["ExtraField1"].ToString());
}
string inv_itemID = "";
//update item
foreach (GridViewRow gvr in gvInv_IssueDetail.Rows)
{
TextBox txtUtilization = (TextBox)gvr.FindControl("txtUtilization");
TextBox txtWasted = (TextBox)gvr.FindControl("txtWasted");
TextBox txtProductionQuantity = (TextBox)gvr.FindControl("txtProductionQuantity");
TextBox txtProductionQuantityFresh = (TextBox)gvr.FindControl("txtProductionQuantityFresh");
TextBox txtProductionQuantityReject = (TextBox)gvr.FindControl("txtProductionQuantityReject");
Label lblApproximateQuantity = (Label)gvr.FindControl("lblApproximateQuantity");
Label lblExtraField1 = (Label)gvr.FindControl("lblExtraField1");
Label lblItemCode = (Label)gvr.FindControl("lblItemCode");
Label lblPricePerUnit = (Label)gvr.FindControl("lblPricePerUnit");
Label lblProductName = (Label)gvr.FindControl("lblProductName");
CheckBox chkSelect = (CheckBox)gvr.FindControl("chkSelect");
CheckBox chkMain = (CheckBox)gvr.FindControl("chkMain");
HiddenField hfItemID = (HiddenField)gvr.FindControl("hfItemID");
HiddenField hfRawMaterialID = (HiddenField)gvr.FindControl("hfRawMaterialID");
HiddenField hfInv_IssueDetailID = (HiddenField)gvr.FindControl("hfInv_IssueDetailID");
HiddenField hfACC_HeadTypeID = (HiddenField)gvr.FindControl("hfACC_HeadTypeID");
decimal totalmoney = decimal.Parse(txtWasted.Text);
if (chkSelect.Checked && decimal.Parse(txtWasted.Text) != 0)
{
if (
decimal.Parse(lblExtraField1.Text)
<
(decimal.Parse(txtWasted.Text))
)
{
showAlartMessage("Stock can not be less than utilization and wastage for " + lblItemCode.Text);
return;
}
if (chkMain.Checked)
{
inv_itemID = hfItemID.Value;
}
//update Inv_IssueDetail
//update Inv_IssueDetail
sql += "Update Inv_IssueDetail set ExtraField1 =(cast ((cast(ExtraField1 as decimal(18,2))-" + txtWasted.Text + ") as nvarchar)) "
+ (txtWasted.Text == "0" ? "" : ", ExtraField4 =(cast ((cast(ExtraField4 as decimal(18,2))+" + txtWasted.Text + ") as nvarchar)) ")
+ " where Inv_IssueDetailID=" + hfInv_IssueDetailID.Value + ";";
//update Inv_Item
sql += "Update Inv_Item set "
+ (txtWasted.Text == "0" ? "" : "ExtraFieldQuantity4 +=" + txtWasted.Text + " ")
+ " where Inv_ItemID=" + hfItemID.Value + ";";
if (txtWasted.Text != "0")
{
sql += @"INSERT INTO [Inv_ItemTransaction]
([ItemID]
,[Quantity]
,[ItemTrasactionTypeID]
,[ReferenceID]
,[ExtraField1]
,[ExtraField2]
,[ExtraField3]
,[ExtraField4]
,[ExtraField5]
,[AddedBy]
,[AddedDate]
,[UpdatedBy]
,[UpdatedDate]
,[RowStatusID])
VALUES (" + hfItemID.Value + "," + txtWasted.Text + ",6," + wastageID
+ ",'','','','',''," + getLogin().LoginID + ",GETDATE()," + getLogin().LoginID + ",'" + DateTime.Parse(txtDate.Text).ToString("yyyy-MM-dd") + "',1);";
/*
sql += @"INSERT INTO [ACC_JournalDetail]
([JournalMasterID]
,[ACC_ChartOfAccountLabel4ID]
,[ACC_ChartOfAccountLabel3ID]
,[WorkStation]
,[Debit]
,[Credit]
,[ExtraField3]
,[ExtraField2]
,[ExtraField1]
,[AddedBy]
,[AddedDate]
,[UpdatedBy]
,[UpdatedDate]
,[RowStatusID])
VALUES("
+ JournalMasterID + ","
+ ddlFinalProduct.SelectedValue + ","
+ "9" + ","
+ ddlWorkSatation.SelectedValue + ","
+ (totalmoney * decimal.Parse(lblPricePerUnit.Text)).ToString("0.00") + ","
+ "0" + ","
+ "''" + ","
+ "''" + ","
+ "'" + hfItemID.Value + "'" + ","
+ getLogin().LoginID + ","
+ "GETDATE()" + ","
+ getLogin().LoginID + ","
+ "GETDATE()" + ","
+ "1);"
;
sql += @"INSERT INTO [ACC_JournalDetail]
([JournalMasterID]
,[ACC_ChartOfAccountLabel4ID]
,[ACC_ChartOfAccountLabel3ID]
,[WorkStation]
,[Debit]
,[Credit]
,[ExtraField3]
,[ExtraField2]
,[ExtraField1]
,[AddedBy]
,[AddedDate]
,[UpdatedBy]
,[UpdatedDate]
,[RowStatusID])
VALUES("
+ JournalMasterID + ","
+ hfRawMaterialID.Value + ","
+ "7" + ","
+ ddlWorkSatation.SelectedValue + ","
+ "0" + ","
+ (totalmoney * decimal.Parse(lblPricePerUnit.Text)).ToString("0.00") + ","
+ "''" + ","
+ "''" + ","
+ "'" + hfItemID.Value + "'" + ","
+ getLogin().LoginID + ","
+ "GETDATE()" + ","
+ getLogin().LoginID + ","
+ "GETDATE()" + ","
+ "1);"
;
*/
}
}
}
try
{
if (CommonManager.SQLExec(sql + "select 1;").Tables[0].Rows[0][0].ToString() == "1")
{
showAlartMessage("Successfully Submitted the wastage");
cearlAlltheControl();
//btnSearch_Click(this, new EventArgs());
}
}
catch (Exception ex)
{
showAlartMessage("Someting wrong");
}
}
public Inv_Wastage GetInv_WastageFromReader(IDataReader reader)
{
try
{
Inv_Wastage inv_Wastage = new Inv_Wastage
(
(int)reader["Inv_WastageID"],
(DateTime)reader["WastageDate"],
reader["IssueIDs"].ToString(),
(int)reader["WorkSatationID"],
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_Wastage;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateInv_Wastage(Inv_Wastage inv_Wastage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Wastage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_WastageID", SqlDbType.Int).Value = inv_Wastage.Inv_WastageID;
cmd.Parameters.Add("@WastageDate", SqlDbType.DateTime).Value = inv_Wastage.WastageDate;
cmd.Parameters.Add("@IssueIDs", SqlDbType.NVarChar).Value = inv_Wastage.IssueIDs;
cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_Wastage.WorkSatationID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Wastage.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Wastage.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Wastage.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Wastage.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Wastage.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Wastage.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
