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); }