public List <clsUnitofMeasure> GetAllUOMsInfo()
        {
            List <clsUnitofMeasure> lst = new List <clsUnitofMeasure>();

            using (SqlConnection conn = new SqlConnection(strConn))
            {
                conn.Open();

                using (SqlCommand cmd = new SqlCommand("TMR_USP_GetUOMInfo"))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Connection  = conn;

                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        var info = new clsUnitofMeasure();

                        info.strUOMid   = reader["UnitofMID"].ToString();
                        info.strUOMDesc = reader["UnitofMDescription"].ToString();
                        info.id         = Convert.ToInt32(reader["ID"]);

                        lst.Add(info);
                    }
                    conn.Close();
                }
            }
            return(lst);
        }
        public bool AddUOMInfo(clsUnitofMeasure info)
        {
            int st = 0;

            try
            {
                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();

                    {
                        using (SqlCommand cmd = new SqlCommand("TMR_USP_AddUOMInfo"))
                        {
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Connection  = conn;
                            cmd.Parameters.AddWithValue("@UnitID", info.strUOMid);
                            cmd.Parameters.AddWithValue("@UnitDescription", info.strUOMDesc);
                            cmd.Parameters.AddWithValue("@ID", info.id);

                            st = cmd.ExecuteNonQuery();
                        }
                    }
                    conn.Close();
                }
            }
            catch (Exception ex) { }
            if (st > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }