private void ExportGridView()
{
Int32 intItemTypeIdno = Convert.ToInt32(ddlType.SelectedValue);
string strItemName = Convert.ToString(txtName.Text.Trim());
ItemMasterDAL objItemMast = new ItemMasterDAL();
var lstGridData = objItemMast.SelectForSearch(intItemTypeIdno, strItemName);
objItemMast = null;
grdMain.AllowPaging = false;
string attachment = "attachment; filename=ManageItemMasterReport.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grdMain.Columns[3].Visible = true;
grdMain.Columns[4].Visible = false;
grdMain.DataSource = lstGridData;
grdMain.DataBind();
grdMain.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
private void BindItemUnit()
{
ItemMasterDAL objItemMast = new ItemMasterDAL();
var lst = objItemMast.SelectUnitType();
objItemMast = null;
ddlItemUnit.DataSource = lst;
ddlItemUnit.DataTextField = "UOM_Name";
ddlItemUnit.DataValueField = "UOM_Idno";
ddlItemUnit.DataBind();
ddlItemUnit.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindGroupType()
{
ItemMasterDAL objItemMast = new ItemMasterDAL();
var lst = objItemMast.SelectGroupType();
objItemMast = null;
ddlGroupType.DataSource = lst;
ddlGroupType.DataTextField = "IGrp_Name";
ddlGroupType.DataValueField = "IGrp_Idno";
ddlGroupType.DataBind();
ddlGroupType.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindGrid()
{
Int32 intItemTypeIdno = Convert.ToInt32(ddlGroupType.SelectedValue);
string strItemName = Convert.ToString(txtItemName.Text.Trim());
ItemMasterDAL objItemMast = new ItemMasterDAL();
var lstGridData = objItemMast.SelectForSearch(intItemTypeIdno, strItemName);
objItemMast = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("ItemName", typeof(string));
dt.Columns.Add("GroupName", typeof(string));
dt.Columns.Add("UOM", typeof(string));
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["ItemName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "ItemName"));
dr["GroupName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "IgrpName"));
dr["UOM"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "UOMName"));
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record(s): " + lstGridData.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record(s): 0 ";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string strMsg = string.Empty;
ItemMasterDAL objItemMast = new ItemMasterDAL();
Int64 intItemIdno = 0;
string HSNSAC = string.IsNullOrEmpty(Convert.ToString(txtHSNSAC.Text.Trim())) ? "" : Convert.ToString(txtHSNSAC.Text.Trim());
if (string.IsNullOrEmpty(hidItemidno.Value) == true)
{
intItemIdno = objItemMast.Insert(txtItemName.Text.Trim(), txtItemNameHindi.Text.Trim(), txtDescription.Text.Trim(), Convert.ToInt64(ddlGroupType.SelectedValue), Convert.ToInt64(ddlItemUnit.SelectedValue), Convert.ToBoolean(chkStatus.Checked), empIdno, HSNSAC);
}
else
{
intItemIdno = objItemMast.Update(txtItemName.Text.Trim(), txtItemNameHindi.Text.Trim(), txtDescription.Text.Trim(), Convert.ToInt64(ddlGroupType.SelectedValue), Convert.ToInt64(ddlItemUnit.SelectedValue), Convert.ToBoolean(chkStatus.Checked), Convert.ToInt32(hidItemidno.Value), empIdno, HSNSAC);
}
objItemMast = null;
if (intItemIdno > 0)
{
if (string.IsNullOrEmpty(hidItemidno.Value) == false)
{
ShowMessage("Record updated successfully.");
}
else
{
ShowMessage("Record saved successfully.");
}
this.ClearControls();
}
else if (intItemIdno < 0)
{
ShowMessageErr("Record already exists.");
}
else
{
if (string.IsNullOrEmpty(hidItemidno.Value) == false)
{
ShowMessageErr("Record not updated.");
}
else
{
ShowMessageErr("Record not saved.");
}
}
txtItemName.Focus();
}
private void UpdateStockIssue(SKIssueH issue, DataActionMode mode)
{
if (new StockDAL().UpdateStockIssue(issue, mode) > 0)
{
// save issue item
if (_mode == DataActionMode.Add)
{
foreach (SKIssueItem item in _issueItems)
{
if (new StockDAL().UpdateIssueItem(item, DataActionMode.Add) > 0)
{
MessageBox.Show($"Issue '{issue.ISSUE_NUM}' save!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
if (_doPosted)
{
// Posting - update IssueItem
foreach (SKIssueItem item in _issueItems)
{
item.IsPosted = _doPosted;
if (new StockDAL().UpdateIssueItem(item, mode) > 0)
{
}
}
// Update Transaction
if (new StockDAL().PostedStockIssueItems(_issueItems) > 0)
{
// update last cost for ItemMaster
int _r = 0;
foreach (var _item in _issueItems)
{
_r += new ItemMasterDAL().UpdateLastUnitCost(_item.ItemNo);
}
if (_r > 0)
{
MessageBox.Show($"Posted Issue '{issue.ISSUE_NUM}' successfully!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}
}
/// <summary>
/// To Populate all controls
/// </summary>
/// <param name="ItemIdno"></param>
private void Populate(int ItemIdno)
{
ItemMasterDAL objItemMast = new ItemMasterDAL();
var objitmMast = objItemMast.SelectById(ItemIdno);
objItemMast = null;
if (objitmMast != null)
{
txtItemName.Text = Convert.ToString(objitmMast.Item_Name);
txtItemNameHindi.Text = Convert.ToString(objitmMast.ItemNamel_Hindi);
txtDescription.Text = Convert.ToString(objitmMast.Item_Desc);
ddlGroupType.SelectedValue = Convert.ToString(objitmMast.IGrp_Idno);
ddlItemUnit.SelectedValue = Convert.ToString(objitmMast.Unit_Idno);
chkStatus.Checked = Convert.ToBoolean(objitmMast.Status);
hidItemidno.Value = Convert.ToString(objitmMast.Item_Idno);
txtHSNSAC.Text = string.IsNullOrEmpty(Convert.ToString(objitmMast.HSNSAC_No))?"":Convert.ToString(objitmMast.HSNSAC_No);
txtItemName.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.Print == false)
{
imgBtnExcel.Visible = false;
}
this.BindGroupType();
ItemMasterDAL Obj = new ItemMasterDAL();
// lblTotalRecord.Text = "T. Record (s): " + Obj.Select_ItemMastCount();
ddlGroupType.Focus();
}
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton imgBtnStatus = (ImageButton)e.Row.FindControl("imgBtnStatus");
bool status = Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "Status"));
// Used to hide Delete button if ItemgrpId exists in Rate Master,Goods Received, Quotation,GR Preparation,Commission Master
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
string ItemIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "ItemIdno"));
if (ItemIdno != "")
{
ItemMasterDAL obj = new ItemMasterDAL();
var ItemExist = obj.CheckItemExistInOtherMaster(Convert.ToInt32(ItemIdno));
if (ItemExist != null && ItemExist.Count > 0)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
}
// end----
imgBtnStatus.Visible = true;
if (status == false)
{
imgBtnStatus.ImageUrl = "~/Images/inactive.png";
}
else
{
imgBtnStatus.ImageUrl = "~/Images/active.png";
}
}
}
public ItemMaster()
{
objDB = new ItemMasterDAL();
}
private void UpdateStockReceive()
{
_stockH.IsPosted = _doPost;
_stockH.SK_Code = _SKCode;
_stockH.DocDate = dtpDocDate.Value;
_stockH.DOC_NUM = txtReceiveNo.Text;
if (_doPost)
{
_stockH.PostedDate = DateTime.Now;
}
_stockH.PostedBy = _doPost ? vars.USER_NAME : "";
_stockH.ModifyDate = DateTime.Today;
_stockH.OtherServices = Convert.ToDecimal(txtOtherCost.Text);
_stockH.Reason = cbxReason.Text;
_stockH.ReceiveBy = txtReceiveBy.Text;
_stockH.Remark = txtRemark.Text;
_stockH.TaxAndClearing = Convert.ToDecimal(txtTaxClearing.Text);
_stockH.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
_stockH.TotalItemCost = Convert.ToDecimal(txtItemCost.Text);
_stockH.TransportCost = Convert.ToDecimal(txtTransport.Text);
//
// update information
//
if (new StockDAL().updateStokReceiveH(_stockH, _mode) > 0)
{
// Save data only
decimal _avgShippingCode = AverageShippingCostRatio();
decimal _avgTax = AverageTaxRatio();
decimal _avgOtherCode = AverageOtherCostRatio();
if (_mode == DataActionMode.Edit)
{
_items = new StockDAL().GetStockReceivedItemLists(_stockH.DOC_NUM);
}
foreach (var _item in _items)
{
_item.IsPosted = _doPost;
_item.Transport = _avgShippingCode * _item.TotalItemCost;
_item.TaxClearing = _avgTax * _item.TotalItemCost;
_item.OtherCost = _avgOtherCode * _item.TotalItemCost;
_item.ItemTotalAmount = (_item.TaxClearing + _item.Transport + _item.OtherCost + _item.TotalItemCost);
_item.AvgUnitCost = _item.ItemTotalAmount / _item.Qty;
new StockDAL().UpdateStockReceiveItem(_item, _mode);
}
// Posted Data to Transaction
if (_doPost)
{
if (new StockDAL().PostedStockRecivedItems(_items) <= 0)
{
// reset the state
_stockH.IsPosted = false;
_stockH.PostedDate = null;
_stockH.PostedBy = "";
if (new StockDAL().updateStokReceiveH(_stockH, _mode) > 0)
{
foreach (var _item in _items)
{
_item.IsPosted = false;
new StockDAL().UpdateStockReceiveItem(_item, _mode);
}
}
MessageBox.Show("Error posted,\n\n Please contact your administrator for help.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
// update last cost for ItemMaster
foreach (var _item in _items)
{
int _x = new ItemMasterDAL().UpdateLastUnitCost(_item.ItemNo);
}
MessageBox.Show("Posted update stock successfully", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Update stock successfully", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdEdit")
{
Response.Redirect("ItemMaster.aspx?ItemIdno=" + e.CommandArgument, true);
}
else if (e.CommandName == "cmdstatus")
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
int intitemIdno = 0;
bool bStatus = false;
string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' });
if (strStatus.Length > 1)
{
intitemIdno = Convert.ToInt32(strStatus[0]);
if (Convert.ToBoolean(strStatus[1]) == true)
{
bStatus = false;
}
else
{
bStatus = true;
}
ItemMasterDAL objItemMast = new ItemMasterDAL();
int value = objItemMast.UpdateStatus(intitemIdno, bStatus, empIdno);
objItemMast = null;
if (value > 0)
{
this.BindGrid();
strMsg = "Status updated successfully.";
txtItemName.Focus();
}
else
{
strMsg = "Status not updated.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
else if (e.CommandName == "cmddelete")
{
ItemMasterDAL objItemMast = new ItemMasterDAL();
long intValue = objItemMast.Delete(Convert.ToInt32(e.CommandArgument));
objItemMast = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
ddlGroupType.Focus();
}
else
{
if (intValue == -1)
{
strMsg = "Record can not be deleted. It is in use.";
}
else
{
strMsg = "Record not deleted.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.ADD == false)
{
lnkbtnSave.Visible = false;
}
if (base.View == false)
{
lblViewList.Visible = false;
}
txtReceiptDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
this.GetAllItems();
this.BindCity();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ReceiptGoodsReceivedDAL obj1 = new ReceiptGoodsReceivedDAL();
var lst = obj1.SelectCityCombo();
obj1 = null;
drpBaseCity.DataSource = lst;
drpBaseCity.DataTextField = "City_Name";
drpBaseCity.DataValueField = "City_Idno";
drpBaseCity.DataBind();
drpBaseCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
ReceiptGoodsReceivedDAL objChlnBookingDAL = new ReceiptGoodsReceivedDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
if (obj != null)
{
drpBaseCity.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
}
drpBaseCity.SelectedValue = Convert.ToString(base.UserFromCity);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ReceiptGoodsReceivedDAL obja = new ReceiptGoodsReceivedDAL();
var SenderReceiver = obja.SelectAcntMastByType(2);
BindDropdownDAL objagent = new BindDropdownDAL();
var Agent = objagent.BindAgent();
obj = null;
drpSender.DataSource = SenderReceiver;
drpSender.DataTextField = "Acnt_Name";
drpSender.DataValueField = "Acnt_Idno";
drpSender.DataBind();
drpSender.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.BindSenderReceiverAgent();
}
drpSender.SelectedValue = Convert.ToString(base.Sender);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ItemMasterDAL obja = new ItemMasterDAL();
var lst = obja.GetItems();
obj = null;
drpItemName.DataSource = lst;
drpItemName.DataTextField = "ItemName";
drpItemName.DataValueField = "ItemId";
drpItemName.DataBind();
drpItemName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.GetAllItems();
}
drpItemName.SelectedValue = Convert.ToString(base.ItemName);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
UOMMasterDAL obja = new UOMMasterDAL();
var lst = obja.GetUnit();
obj = null;
drpUnitName.DataSource = lst;
drpUnitName.DataTextField = "UOMName";
drpUnitName.DataValueField = "UOMId";
drpUnitName.DataBind();
drpUnitName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.GetAllUnit();
}
drpUnitName.SelectedValue = Convert.ToString(base.Unit);
//this.GetAllUnit();
this.BindDateRange();
ddlDateRange_SelectedIndexChanged(null, null);
ddlDateRange.SelectedIndex = 0;
drpBaseCity.Enabled = true;
this.GetReceiptNo();
if (Request.QueryString["q"] != null)
{
this.BindSenderReceiverAgentPopulate();
Populate(Convert.ToInt64(Request.QueryString["q"]));
hidgoodsreceivedid.Value = Convert.ToString(Request.QueryString["q"]);
btnNew.Visible = true;
lnkbtnNew.Visible = true;
ddlDateRange.Enabled = false; imgPrint.Visible = true;
}
else
{
lnkbtnNew.Visible = false;
ddlDateRange.Enabled = true;
imgPrint.Visible = false;
//this.BindSenderReceiverAgent();
}
txtWeight.Attributes.Add("onkeypress", "return allowOnlyFloatNumber(event);");
txtQty.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtSenderNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtReceiptDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtRemark.Attributes.Add("onkeypress", "return notAllowSpecialCharacters_Spaceallow(event);");
}
Int32 intYearIdno = Convert.ToInt32(ddlDateRange.SelectedValue);
}
