Exemplo n.º 1
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if ((MessageBox.Show("Do u really want to delete this item. ", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) == DialogResult.Yes)
            {
                CUOM    oUOM    = Getformdata();
                CUOMBO  oUOMBO  = new CUOMBO();
                CResult oresult = new CResult();
                if (txtUOMid.Text.Trim() != string.Empty)
                {
                    oresult = oUOMBO.Delete(oUOM);
                    if (oresult.IsSuccess == true)
                    {
                        if (oresult.Data.ToString() == "0")
                        {
                            MessageBox.Show("Deletion Not Possible", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            LoadUOMType();
                            ClearFormData();
                        }

                        else
                        {
                            MessageBox.Show("Deleted Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            LoadUOMType();
                            ClearFormData();
                        }
                    }

                    else
                    {
                        MessageBox.Show("Error" + oresult.ErrMsg + "");
                    }
                }
            }
        }
Exemplo n.º 2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            CUOM    oUOM    = Getformdata();
            CUOMBO  oUOMBO  = new CUOMBO();
            CResult oresult = new CResult();

            if (validatedata())
            {
                if (txtUOMid.Text.Trim() != string.Empty)
                {
                    if (DialogResult.OK == MessageBox.Show("Are you wanted to upadte " + txtUOMCode.Text + " ?", "Confirmation!", MessageBoxButtons.OKCancel))
                    {
                        oresult = oUOMBO.Update(oUOM);
                    }
                }
                else
                {
                    if (!IsUpdateMode)
                    {
                        oresult = oUOMBO.Create(oUOM);
                    }
                }

                if (oresult.IsSuccess)
                {
                    LoadUOMType();
                    ClearFormData();
                }
                else
                {
                    MessageBox.Show("Not Saved" + oresult.ErrMsg + "");
                }
            }
        }
Exemplo n.º 3
0
        private CItem Getformdata()
        {
            CItem      oitem      = new CItem();
            CItemType  oItemType  = (CItemType)ddlItemType.SelectedItem;
            CItemGroup oitemgroup = (CItemGroup)ddlGroupNAme.SelectedItem;
            CUOM       oUOM       = (CUOM)ddlUOM.SelectedItem;
            CSize      oSize      = (CSize)cmbItemSize.SelectedItem;

            oitem.Item_OID     = txthiddenitemid.Text;
            oitem.Item_Branch  = currentBranch.CompBrn_Code;
            oitem.Item_GroupID = oitemgroup.Catg_OID;
            oitem.Item_TypeID  = oItemType.ITyp_OID;
            oitem.Item_UOMID   = oUOM.UOM_OID;
            oitem.Item_Code    = txtItemCode.Text.Trim();
            if (cmbItemSize.SelectedItem != null && txtICode.Text != "")
            {
                oitem.Item_ItemName = txtItemName.Text + "-" + txtICode.Text + "-- " + oSize.Size_Name;
            }
            if (txtICode.Text != "")
            {
                oitem.Item_ItemName = txtItemName.Text + "-" + txtICode.Text;
            }
            else
            {
                oitem.Item_ItemName = txtItemName.Text;
            }
            //oitem.Item_ItemName = txtItemName.Text;
            oitem.Item_Pprice  = float.Parse(txtpprice.Text);
            oitem.Remarks      = txtRemarks.Text;
            oitem.Item_RQTY    = float.Parse(txtRQTY.Text);
            oitem.Item_Sprice  = float.Parse(txtSprice.Text);
            oitem.Creator      = currentUser.User_OID;
            oitem.CreationDate = DateTime.Now;
            oitem.UpdateBy     = currentUser.User_OID;
            oitem.UpdateDate   = DateTime.Now;
            oitem.CreationDate = DateTime.Now.Date;
            if (chkIsActive.Checked)
            {
                oitem.IsActive = "Y";
            }
            else
            {
                oitem.IsActive = "N";
            }

            oitem.Item_Priority = int.Parse(nupdnItemPriority.Text.Trim());

            oitem.ItemImage = this.ItemImage;

            return(oitem);
        }
Exemplo n.º 4
0
            public CResult Update(CUOM oUOM)
            {
                oResult = new CResult();
                conn    = oConnManager.GetConnection(out s_DBError);
                if (conn != null)
                {
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;

                    cmd.Transaction = oConnManager.BeginTransaction();
                    try
                    {
                        cmd.CommandText = "sp_UOM_Update";
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.AddWithValue("@UOM_OID", oUOM.UOM_OID);
                        cmd.Parameters.AddWithValue("@UOM_Code", oUOM.UOM_Code);
                        cmd.Parameters.AddWithValue("@UOM_Name", oUOM.UOM_Name);
                        cmd.Parameters.AddWithValue("@UOM_Branch", oUOM.UOM_Branch);
                        cmd.Parameters.AddWithValue("@Creator", oUOM.Creator);
                        cmd.Parameters.AddWithValue("@CreationDate", oUOM.CreationDate);
                        cmd.Parameters.AddWithValue("@UpdateBy", oUOM.UpdateBy);
                        cmd.Parameters.AddWithValue("@UpdateDate", oUOM.UpdateDate);
                        cmd.Parameters.AddWithValue("@IsActive", oUOM.IsActive);
                        cmd.Parameters.AddWithValue("@Remarks", oUOM.Remarks);

                        cmd.ExecuteNonQuery();
                        oConnManager.Commit();
                        oResult.IsSuccess = true;
                    }
                    catch (SqlException e)
                    {
                        string sRollbackError = oConnManager.Rollback();

                        oResult.IsSuccess = false;
                        oResult.ErrMsg    = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
                    }
                    finally
                    {
                        oConnManager.Close();
                    }
                }
                else
                {
                    oResult.IsSuccess = false;
                    oResult.ErrMsg    = s_DBError;
                }

                return(oResult);
            }
Exemplo n.º 5
0
 private void LLUOMType_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (LLUOMType.SelectedIndex != -1)
     {
         if (LLUOMType.Items.Count > 0)
         {
             CUOM oCUOM = (CUOM)LLUOMType.SelectedItem;
             txtUOMid.Text   = oCUOM.UOM_OID.ToString();
             txtUOMCode.Text = oCUOM.UOM_Code;
             txtUOMName.Text = oCUOM.UOM_Name;
             txtRemarks.Text = oCUOM.Remarks;
             FormControlMode(1);
         }
     }
 }
Exemplo n.º 6
0
        private CUOM Getformdata()
        {
            CUOM oUOM = new CUOM();

            oUOM.UOM_OID      = txtUOMid.Text.Trim();
            oUOM.UOM_Branch   = currentBranch.CompBrn_Code;
            oUOM.UOM_Code     = txtUOMCode.Text.Trim();
            oUOM.UOM_Name     = txtUOMName.Text.Trim();
            oUOM.Remarks      = txtRemarks.Text.Trim();
            oUOM.CreationDate = DateTime.Now;
            oUOM.Creator      = currentUser.User_OID;
            oUOM.UpdateBy     = currentUser.User_OID;
            oUOM.UpdateDate   = DateTime.Now;
            oUOM.IsActive     = "Y";
            return(oUOM);
        }
Exemplo n.º 7
0
            private CUOM GetResultSetToUOM(DataRow dr)
            {
                CUOM oUOM = new CUOM();

                oUOM.UOM_OID      = dr[0].ToString();
                oUOM.UOM_Code     = dr[1].ToString();
                oUOM.UOM_Name     = dr[2].ToString();
                oUOM.UOM_Branch   = dr[3].ToString();
                oUOM.Creator      = dr[4].ToString();
                oUOM.CreationDate = DateTime.Parse(dr[5].ToString()).Date;
                oUOM.UpdateBy     = dr[6].ToString();
                oUOM.UpdateDate   = DateTime.Parse(dr[7].ToString()).Date;
                oUOM.IsActive     = dr[8].ToString();
                oUOM.Remarks      = dr[9].ToString();

                return(oUOM);
            }
Exemplo n.º 8
0
            public CResult Delete(CUOM oUOM)
            {
                oResult = new CResult();
                conn    = oConnManager.GetConnection(out s_DBError);
                if (conn != null)
                {
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;

                    cmd.Transaction = oConnManager.BeginTransaction();
                    try
                    {
                        cmd.CommandText = "sp_UOM_Delete";
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.AddWithValue("@UOM_OID", oUOM.UOM_OID);
                        cmd.Parameters.Add("@IsSuccess", SqlDbType.Char, 1);
                        cmd.Parameters["@IsSuccess"].Direction = ParameterDirection.ReturnValue;
                        cmd.ExecuteNonQuery();
                        string st = cmd.Parameters["@IsSuccess"].Value.ToString();

                        oConnManager.Commit();
                        oResult.Data      = st;
                        oResult.IsSuccess = true;
                    }
                    catch (SqlException e)
                    {
                        string sRollbackError = oConnManager.Rollback();

                        oResult.IsSuccess = false;
                        oResult.ErrMsg    = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
                    }
                    finally
                    {
                        oConnManager.Close();
                    }
                }
                else
                {
                    oResult.IsSuccess = false;
                    oResult.ErrMsg    = s_DBError;
                }

                return(oResult);
            }