コード例 #1
0
    /// <summary>
    /// Add or updates the default process and rate for the item
    /// </summary>
    /// <param name="Item">The <c ref="DTO.Item">DTO</c> Item</param>
    /// <param name="branchId">The Branch Id</param>
    protected void SaveDefPrcAndRate(ref DTO.Item Item, string branchId)
    {
        // if there is no process defined, and no rate is specified
        // then do nothing!

        SaveDefPrcAndRate(ref Item, branchId, false);
    }
コード例 #2
0
 /// <summary>
 /// Add or updates the default process and rate for the item
 /// </summary>
 /// <param name="Item">The <see cref="DTO.Item">DTO</see> Item</param>
 /// <param name="isUpdating">Is updating the record</param>
 /// <param name="branchId">The branchId</param>
 protected void SaveDefPrcAndRate(ref DTO.Item Item, string branchId, bool isUpdating)
 {
     // not using DAL, because no real work is being done there, might as well skip it!
     if (!string.IsNullOrEmpty(txtProcess.Text.Trim()) && !string.IsNullOrEmpty(txtDefaultRate.Text.Trim()))
     {
         DAL.DALFactory.Instance.DAL_Item.SaveDefPrcAndRate(ref Item, branchId, isUpdating, int.Parse(ddlRateList.SelectedValue));
     }
 }
コード例 #3
0
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (txtItemName.Text == "")
        {
            lblErr.Text = "Please enter item name to save.";
            return;
        }
        int x1 = 1, TotalSubQty = 0;

        for (int x = 0; x < lstSubItem.Items.Count; x++)
        {
            x1 = x + 1;
        }
        try
        {
            if (rdbinch.Checked)
            {
                TotalSubQty = 1;
                x1          = 1;
            }
            if (rdbpanel.Checked)
            {
                TotalSubQty = 1;
                x1          = 1;
            }
            if (rdbPcs.Checked)
            {
                TotalSubQty = int.Parse(txtItemSubQty.Text.Trim());
            }
        }
        catch (Exception excp)
        {
            lblErr.Text = "Error: Invalid no. of sub items.";
            return;
        }
        if (txtProcess.Text != "")
        {
            if (BAL.BALFactory.Instance.BAL_Item.CheckIfProcessCodeExits(txtProcess.Text, Globals.BranchID) != true)
            {
                lblErr.Text = "Please select valid process.";
                txtProcess.Focus();
                txtProcess.Attributes.Add("onfocus", "javascript:select();");
                return;
            }
        }
        if (TotalSubQty == x1)
        {
            Item          = SetValue();
            Common.Result = BAL.BALFactory.Instance.BAL_Item.UpdateItem(Item);
            if (Common.Result == "Record Saved")
            {
                Item.OldItemName = (string)ViewState["ItemPrevName"];
                Common.Result    = BAL.BALFactory.Instance.BAL_Item.DeleteSubItem(Item);
                if (Common.Result == "Record Saved")
                {
                    if (Item.NoOfItem == "1")
                    {
                        Item.SubItemName  = txtItemName.Text;
                        Item.SubItemOrder = "1";
                        Common.Result     = DAL.DALFactory.Instance.DAL_Item.SaveSubItem(Item);
                        if (Common.Result == "Record Saved")
                        {
                            lblMsg.Text = "Item Updated Successfully";
                            SaveDefPrcAndRate(ref Item, Globals.BranchID, true);
                            RefreshPage();
                        }
                    }
                    else
                    {
                        int inc = 0;
                        for (int i = 1; i <= lstSubItem.Items.Count; i++)
                        {
                            Item.SubItemName  = lstSubItem.Items[inc].Text;
                            Item.SubItemOrder = i.ToString();
                            Common.Result     = DAL.DALFactory.Instance.DAL_Item.SaveSubItem(Item);
                            if (Common.Result != "Record Saved")
                            {
                                break;
                            }
                            inc++;
                        }
                        if (Common.Result == "Record Saved")
                        {
                            lblMsg.Text = PrjClass.UpdateSuccess;
                            SaveDefPrcAndRate(ref Item, Globals.BranchID, true);
                            RefreshPage();
                        }
                        else
                        {
                            lblErr.Text = Common.Result;
                        }
                    }
                }
            }
            else
            {
                lblErr.Text = Common.Result;
                txtItemCode.Focus();
                txtItemCode.Attributes.Add("onfocus", "javascript:select();");
            }
            if (Common.Result == "Record Saved")
            {
                Item.OldItemName = (string)ViewState["ItemPrevName"];
                Common.Result    = BAL.BALFactory.Instance.BAL_Item.UpdateExitingItem(Item);
                RefreshPage();
            }
        }
        else
        {
            lblErr.Text = "Item List Should be match with Sub Items Quantity";
            txtItemSubQty.Focus();
            return;
        }
    }
コード例 #4
0
    protected void btnTemp_Click(object sender, EventArgs e)
    {
        DataSet dsMain = new DataSet();

        try
        {
            itemname = txtItemNameSearch.Text.Split('-');
            txtItemNameSearch.Text = itemname[1].Trim();
            if (BAL.BALFactory.Instance.Bal_Processmaster.CheckCorrectItem(Globals.BranchID, itemname[1].Trim()) == false)
            {
                Session["ReturnMsg"] = "Please enter valid item name.";
                txtItemNameSearch.Focus();
                txtItemNameSearch.Attributes.Add("onfocus", "javascript:select();");
            }
            else
            {
                ddlRateList.SelectedIndexChanged -= ddlRateListChange;
                ddlRateList.SelectedIndex         = 0;
                ddlRateList.SelectedIndexChanged += ddlRateListChange;
                lblUpdateId.Text = BAL.BALFactory.Instance.Bal_Processmaster.GetItemId(Globals.BranchID, itemname[1].Trim(), itemname[0].Trim());
                dsMain           = BAL.BALFactory.Instance.Bal_Processmaster.getItem(lblUpdateId.Text, Globals.BranchID);
                DTO.Item Ob = new DTO.Item();

                if (dsMain.Tables[0].Rows.Count > 0)
                {
                    Ob.ItemName        = "" + dsMain.Tables[0].Rows[0]["ItemName"].ToString();
                    Ob.BranchId        = Globals.BranchID;
                    txtItemName.Text   = "" + dsMain.Tables[0].Rows[0]["ItemName"].ToString();
                    txtItemSubQty.Text = "" + dsMain.Tables[0].Rows[0]["NumberOfSubItems"].ToString();
                    hdntemp.Value      = txtItemSubQty.Text;
                    txtItemCode.Text   = "" + dsMain.Tables[0].Rows[0]["ItemCode"].ToString();
                    hdnItemCode.Value  = txtItemCode.Text;
                    SetTextbox();
                    hdntemp.Value = "1";
                    string unit = dsMain.Tables[0].Rows[0]["Unit"].ToString();
                    lstSubItem.Items.Clear();
                    if (dsMain.Tables[1].Rows.Count > 1)
                    {
                        for (int i = 0; i < dsMain.Tables[1].Rows.Count; i++)
                        {
                            lstSubItem.Items.Add(dsMain.Tables[1].Rows[i]["SubItemName"].ToString());
                        }
                    }
                    if (dsMain.Tables[2].Rows.Count > 0)
                    {
                        txtDefaultRate.Text = "" + dsMain.Tables[2].Rows[0]["ProcessPrice"].ToString();
                        txtProcess.Text     = "" + dsMain.Tables[2].Rows[0]["ProcessCode"].ToString();
                    }
                    else
                    {
                        txtDefaultRate.Text = "";
                        txtProcess.Text     = "";
                    }
                    lblSaveOption.Text        = "2";
                    ViewState["ItemPrevName"] = txtItemName.Text;
                    EnableModification(false);
                    EnableModification(true);
                    txtItemName.Focus();
                    btnSave.Visible = false;
                    //btnCopy.Visible = true;
                    if (unit == "Pcs")
                    {
                        rdbPcs.Checked   = true;
                        rdbpanel.Checked = false;
                        rdbinch.Checked  = false;
                    }
                    else if (unit == "P")
                    {
                        rdbpanel.Checked      = true;
                        rdbinch.Checked       = false;
                        rdbPcs.Checked        = false;
                        txtItemSubQty.Enabled = false;
                    }
                    else if (unit == "LB")
                    {
                        rdbinch.Checked       = true;
                        rdbPcs.Checked        = false;
                        rdbpanel.Checked      = false;
                        txtItemSubQty.Enabled = false;
                    }
                    if (BAL.BALFactory.Instance.BAL_Item.CheckItemStatus(Ob) == true)
                    {
                        rdbinch.Enabled   = false;
                        rdbpanel.Enabled  = false;
                        rdbPcs.Enabled    = false;
                        btnUpdate.Visible = true;
                        btnDelete.Visible = false;
                        EnableModification(false);
                        txtItemCode.Enabled = true;
                        txtItemCode.Focus();
                        txtItemCode.Attributes.Add("onfocus", "javascript:select();");
                    }
                    else
                    {
                        rdbinch.Enabled   = true;
                        rdbpanel.Enabled  = true;
                        rdbPcs.Enabled    = true;
                        btnUpdate.Visible = true;
                        btnDelete.Visible = true;
                        txtItemName.Focus();
                        txtItemName.Attributes.Add("onfocus", "javascript:select();");
                    }
                }
                else
                {
                    lblErr.Text += " Could not get details.";
                    lstSubItem.Items.Clear();
                }
            }
        }
        catch (Exception ex)
        {
            Session["ReturnMsg"] = "Please enter valid item name.";
            txtItemNameSearch.Focus();
            txtItemNameSearch.Attributes.Add("onfocus", "javascript:select();");
        }
    }
コード例 #5
0
    protected void grdSearchResult_SelectedIndexChanged(object sender, EventArgs e)
    {
        lblUpdateId.Text = grdSearchResult.SelectedRow.Cells[3].Text.Replace("&nbsp;", "");
        SqlConnection sqlcon = new SqlConnection(PrjClass.sqlConStr);
        DataSet       dsMain = new DataSet();

        try
        {
            sqlcon.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection  = sqlcon;
            cmd.CommandText = "SP_Sel_RecForItemIdUpdate";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@ItemId", lblUpdateId.Text));
            cmd.Parameters.Add(new SqlParameter("@BranchId", Globals.BranchID));
            SqlDataAdapter sadp = new SqlDataAdapter();
            sadp.SelectCommand = cmd;
            sadp.Fill(dsMain);
        }
        catch (Exception excp)
        {
            lblErr.Text = "Error : " + excp.Message;
        }
        finally
        {
            sqlcon.Close();
            sqlcon = null;
        }
        if (dsMain.Tables[0].Rows.Count > 0)
        {
            DTO.Item Ob = new DTO.Item();
            Ob.ItemName        = "" + dsMain.Tables[0].Rows[0]["ItemName"].ToString();
            Ob.BranchId        = Globals.BranchID;
            txtItemName.Text   = "" + dsMain.Tables[0].Rows[0]["ItemName"].ToString();
            txtItemSubQty.Text = "" + dsMain.Tables[0].Rows[0]["NumberOfSubItems"].ToString();
            hdntemp.Value      = txtItemSubQty.Text;
            txtItemCode.Text   = "" + dsMain.Tables[0].Rows[0]["ItemCode"].ToString();
            hdnItemCode.Value  = txtItemCode.Text;
            string unit = "" + dsMain.Tables[0].Rows[0]["Unit"].ToString();
            SetTextbox();
            hdntemp.Value = "1";
            lstSubItem.Items.Clear();
            if (dsMain.Tables[1].Rows.Count > 1)
            {
                for (int i = 0; i < dsMain.Tables[1].Rows.Count; i++)
                {
                    lstSubItem.Items.Add(dsMain.Tables[1].Rows[i]["SubItemName"].ToString());
                }
            }
            if (dsMain.Tables[2].Rows.Count > 0)
            {
                txtDefaultRate.Text = "" + dsMain.Tables[2].Rows[0]["ProcessPrice"].ToString();
                txtProcess.Text     = "" + dsMain.Tables[2].Rows[0]["ProcessCode"].ToString();
            }
            else
            {
                txtDefaultRate.Text = "";
                txtProcess.Text     = "";
            }
            lblSaveOption.Text        = "2";
            ViewState["ItemPrevName"] = txtItemName.Text;
            EnableModification(false);
            EnableModification(true);
            txtItemName.Focus();
            btnSave.Visible = false;
            // btnCopy.Visible = true;
            if (unit == "Pcs")
            {
                rdbPcs.Checked   = true;
                rdbpanel.Checked = false;
                rdbinch.Checked  = false;
            }
            else if (unit == "P")
            {
                rdbpanel.Checked      = true;
                rdbinch.Checked       = false;
                rdbPcs.Checked        = false;
                txtItemSubQty.Enabled = false;
            }
            else if (unit == "LB")
            {
                rdbinch.Checked       = true;
                rdbPcs.Checked        = false;
                rdbpanel.Checked      = false;
                txtItemSubQty.Enabled = false;
            }
            if (BAL.BALFactory.Instance.BAL_Item.CheckItemStatus(Ob) == true)
            {
                rdbinch.Enabled   = false;
                rdbpanel.Enabled  = false;
                rdbPcs.Enabled    = false;
                btnUpdate.Visible = true;
                btnDelete.Visible = false;
                EnableModification(false);
                txtItemCode.Enabled = true;
                txtItemCode.Focus();
                txtItemCode.Attributes.Add("onfocus", "javascript:select();");
            }
            else
            {
                rdbinch.Enabled   = true;
                rdbpanel.Enabled  = true;
                rdbPcs.Enabled    = true;
                btnUpdate.Visible = true;
                btnDelete.Visible = true;
                txtItemName.Focus();
                txtItemName.Attributes.Add("onfocus", "javascript:select();");
            }
        }
        else
        {
            lblErr.Text += " Could not get details.";
            lstSubItem.Items.Clear();
        }
    }